OpenFlights – airport and airline data
It's ridiculous that the only original source of this data, the IATA [0], charges $700+ for this list, so kudos to OpenFlights.I can't stress just how important (and how hard) it is to get a great source of data for airports -- I've now built 3 travel-related projects (the latest, Wanderlog [https://wanderlog.com], keeps people's flight reservations, so uses it for an autocomplete), and it's been a key building block for all of them.The main datasets we use are:- OpenFlights [1]: mentioned in this post, but this dataset was great since it had timezone too.- OurAirports [2]: no timezone here, but the "type" and "scheduled_service" columns in this dataset are essential. "Type" lets you distinguish between small/medium/large airports, and "scheduled_service" lets you easily filter out airports without real flights (which you often might not care about).- Random other GitHub Gist [3]: I have no idea where this data comes from, but it was surprisingly complete and has a few golden nuggets like "num_flights" and "runway_length" in addition to "timezone". The presence of a "woeid" suggests Yahoo-related origins, but it's hard to be sure.- We now supplement this with airports from autocomplete APIs like Skyscanner's, because they're still the most up-to-date.Long story short, it'd be AWESOME to have one complete, updated database with all this data in one place. This kind of data really should be public and a public service, but until then it's unfortunately up to the community.[0] https://www.iata.org/en/publications/store/airline-coding-di...[1] https://github.com/jpatokal/openflights/[2] http://ourairports.com/data/[3] https://gist.github.com/tdreyno/4278655