Airport Codes lets you look up codes for airports around the world, and it maps the airport's location. I use the Windows Phone 7 version, but similar apps are available for iPhone and other mobile platforms.
My best buddy is Worldmate Live. It's an itinerary tracker - meetings, train tickets, plane tickets, hotel accommodations, you name it. You can forward your reservation emails to a specific email address and it will read them and put the information in your phone for you, or you can do it manually.
Car Locator is also available on Android. No "Tripit"? The single most useful app I've ever used in my flying! (which is twice a month). And a Charlott specific app not useful anywhere else? Get real and recommend apps that are useful in the other "couple of airports" located around the country.