Welcome Earline. How old is your son? I'm assuming a teenager?
There are a few things you should know about the 93-95 (FD is how they're commonly referred to as that is their model designation from Mazda and 95 was the last year that they were imported to the States). They are one of the most gorgeous cars ever produced in my opinion, but they have some rather severe down sides for the uninitiated. First off is that none of them are cheap, expect to pay 15k or better for a decent example. Yes, they are a used car, but they are highly sought after by enthusiasts. Secondly they break, a lot, when pushed hard. If driven they way they were designed to be they aren't bad, but a teenager will not drive them that way. I know I didn't. They are not fuel efficient in any sense of the word and finding someone to work on a rotary engined vehicle that actually knows what they're doing can be a challenge. I'm sure he has his heart set on the FD and if he is willing to learn and study a lot to work on it himself, it can be a good car.
I guess what I'm trying to point out is that it all depends on your son's abilities and situation as to whether this would be a good choice for him. If the above is not applicable to him, then a Miata would be a better choice. They are a very fun car that get good mileage, are durable, and proven on the racetrack as one of the best handling cars for the money that you can buy.
Just some advice, although I'm sure he would have absolutely no interest in hearing it.