Is an antenna adapter required to put an aftermarket head unit in a 1997 plymouth neon?

No. Chrysler used the standard "Motorola" type radio plug until the 2002 model year. Any earlier Chrysler vehicle should match up with an after-market head unit without needing an adapter.