a life of coding

Monday, May 22, 2006

Airport ICAO SQL

Getting simple information on flights is a real pain in the ass.  There are airport codes (IATA and ICAO), airplane codes, and airline codes (IATA and ICAO).  Here's the good news:
  • There is an existing database for IATA and ICAO airport codes.
  • There aren't too many airplane codes, and they aren't as important
  • IATA airline codes seem to be out of fashion, and will be officially replaced by ICAO codes soon.
I've scraped Wikipedia to put together ICAO airline codes in SQL.  I won't be maintaining this list, but if you just want to cover the basics, you're welcome.


Post a Comment


Create a Link

<< Home