This is one my favorite local airports:
Vansant, Erwinna, PA
To paraphrase part of their site, on a nice clear day you can go soaring above it and see Philadelphia to one side, beautiful Bucks County below you, and New York in the other direction.
I work at this one, just a few miles away:
Doylestown Airport, Doylestown, PA
There are over 40 airports within 25NM of my house.
To me, the "local airport" is a general aviation place where people can learn to fly, and on any given Sunday afternoon you can walk into the pilot's lounge and chat with 100,000 combined flying hours of airport bums.