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.<p>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 [<a href="https://wanderlog.com" rel="nofollow">https://wanderlog.com</a>], keeps people's flight reservations, so uses it for an autocomplete), and it's been a key building block for all of them.<p>The main datasets we use are:<p>- OpenFlights [1]: mentioned in this post, but this dataset was great since it had timezone too.<p>- 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).<p>- 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.<p>- We now supplement this with airports from autocomplete APIs like Skyscanner's, because they're still the most up-to-date.<p>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.<p>[0] <a href="https://www.iata.org/en/publications/store/airline-coding-directory/" rel="nofollow">https://www.iata.org/en/publications/store/airline-coding-di...</a><p>[1] <a href="https://github.com/jpatokal/openflights/" rel="nofollow">https://github.com/jpatokal/openflights/</a><p>[2] <a href="http://ourairports.com/data/" rel="nofollow">http://ourairports.com/data/</a><p>[3] <a href="https://gist.github.com/tdreyno/4278655" rel="nofollow">https://gist.github.com/tdreyno/4278655</a>