Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

OpenFlights – airport and airline data

openflights.org

Post reply on HN
Print view View original

11–20 of 62 posts

Re: OpenFlights – airport and airline data

#11

Post by sokoloff »

phsource wrote: post #7

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 bl…

If it’s important and hard to get this data, is it really ridiculous that a provider of the data charges $700 for it?

Re: OpenFlights – airport and airline data

#12

Post by einpoklum »

gbrindisi wrote: post #8

does anyone know any current dataset I could query to check historical routes status? Since the pandemic I've found plenty of airlines selling tickets and systematically cancel the flight a few days before. I was looking to scrape some data to avoid this kind of unreliable flights.

Check out my other comment...

The USDT on-time performance data goes back as far as October 1987 (and you can specify the period to the download script with the --first-year , --first-month , --last-year , --last-month command-line switches).

Once the data is loaded you can use spiffy SQL to print out routes the way you like them. Unfortunately the data is also a bit dirty (which is something I'm working on).

Re: OpenFlights – airport and airline data

#13

Post by angott »

chillydawg wrote: post #9
phsource wrote: post #7

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 bl…

openstreetmap might happen to have a list of airports with decent metadata, but it'll have zero info about actual flights.

Yep. It is quite good for some data that volunteers can provide from open data. Things like runway numbers, surface material and length.

Re: OpenFlights – airport and airline data

#14

Post by ctippett »

phsource wrote: post #7

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 bl…

FlightStats / Cirium have an API for airport data[0] that I’ve found to be mostly complete (sans a few rural Australian airports). It includes historical records for airports that are no longer active, such as Hong Kong’s Kai Tak airport that previously went by the HKG IATA code.

FlightAware have a similar API[1].

These aren’t free or open mind you, but are at least readily accessible for those that need/want it.

[0] https://developer.flightstats.com/api-docs/airports/v1

[1] https://uk.flightaware.com/commercial/aeroapi/

Re: OpenFlights – airport and airline data

#15

Post by kingsloi »

For anyone interested, the nice guys at https://aviation-edge.com supplied me access to their flight API so I can track how many flights fly directly over my little community in Gary Indiana: https://millerbeach.community

I wish I was able to track more frequently than every 15 minutes (free version api max, etc), because some aircraft pass overhead before they're picked up, so it's not the most accurate, but a rough figure to/from O'Hare, Midway, and Gary

Re: OpenFlights – airport and airline data

#16

Post by ant6n »

kingsloi wrote: post #15

For anyone interested, the nice guys at https://aviation-edge.com supplied me access to their flight API so I can track how many flights fly directly over my little community in Gary Indiana: https://millerbeach.community I wish I was able to track more frequently than every 15 minutes (free version api max, etc), because some aircraft pass overhead before they're picked up, so it's not the most accurate, but a rough…

I’m working on some project to compare historical availabilities of seats between city pairs in Europe, too bad their historical api doesnt return aircraft type (so number of seats its unknown). I also couldn’t find how far back their data goes.

... for my project, I actually got some historical paper schedules of the official aviation guide, basically they’re phone books. I hope to find a decent/affordable database for more recent data. (MIT students/alumns actually get access to a database going back to 1979, but alas no access for outsiders...)

Re: OpenFlights – airport and airline data

#17

Post by JamilD »

A few years ago I tried writing a Python wrapper around SABRE's API to get pricing, route, and schedule data, which seemed to work reasonably well. It likely doesn't work anymore, but it was a fun exercise. https://github.com/Jamil/sabre_dev_studio

I wish I had access to the GDS data to get realtime seat/award availability, but I couldn't find any pricing information to get that information through Sabre's API.

Does anyone know how much that costs, or if there are any services which provide it as an API? I use ExpertFlyer for personal use, but ideally I'd want to get that information at the source…

Re: OpenFlights – airport and airline data

#18

Post by squeaky-clean »

sokoloff wrote: post #11
phsource wrote: post #7

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 bl…

If it’s important and hard to get this data, is it really ridiculous that a provider of the data charges $700 for it?

It's only hard to get because IATA doesn't easily provide it. IATA isn't "a" provider of the data, they are the data. It would be like if you had to purchase a list of the bus stops and schedule in your city from your transportation department.

Re: OpenFlights – airport and airline data

#19

Post by nonameiguess »

phsource wrote: post #7

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 bl…

Are you just looking for airports, routes, and schedules? FlightAware provides that: https://flightaware.com/

Not sure what you get with the commercial services, but even the free services are pretty good. It's what we used in 1st CAV to track the redeployment of the last units to leave Iraq in 2011.

Post reply on HN