I am interested in understanding which US airports have what airlines. One could visualize this with a spreadsheet:

enter image description here ​ ​

This examples shows that Southwest flies out of Midway but not O'Hare. Delta flies out of O'Hare and not Midway. Both fly out of Baltimore.

I am not interested in a global \ US map that shows routes destinations of a particular airline: I am not interested in using this data from the passenger use-case. A spreadsheet would be preferable although, I suspect that if the data is out there, it is stored in a RDBMS.

Wondering if there is clever way to tease this info out of http://openflights.org/

closed as too broad by Karlson, blackbird, Jan, Relaxed, neo Jul 29 '16 at 21:42

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Parsing Wiki should work. – JonathanReez Jul 29 '16 at 18:46
  • I am curious what would be the purpose? With the modern flight search engines able to search for flights from any airport in the metropolitan area, I don't see a point in this endeavor. – Karlson Jul 29 '16 at 18:46
  • @JonathenReez: please cite an example of a URL that could be parsed for this data. – gatorback Jul 29 '16 at 20:23
  • with the US alone having over 15000 airports (and over 42000+ worldwide), and nearly 400 airlines, you are up for a large spreadsheet. – Aganju Jul 29 '16 at 20:44
  • 4
    I'm voting to close this question as off-topic because it's not about a genuine problem faced by a traveller but some sort of personal data analysis project. – Relaxed Jul 29 '16 at 21:40

Something like this?

$ wget https://raw.githubusercontent.com/jpatokal/openflights/master/data/routes.dat
$ awk -F, '$3 == "MDW" {print $1}' routes.dat|sort -u
  • I like where this is going! Data is from openflights.org: if only they had an ODBC connector. With regard to this data: How can the 2 lists of 1) airports and 2) airlines be created from this programatically? After these lists are enumerated, they would form the x and y axis as shown in the OP. A two-dimensional array (i.e. spreadsheet 'skeleton') could be created. – gatorback Jul 29 '16 at 23:16
  • The programming tasks needed to process the data as you describe are pretty far off topic for this site. In short, Berwyn gave you a way to get the airlines serving a particular airport. You could then repeat the query for other airports of interest and assemble them into a chart as you see fit. – Zach Lipton Jul 30 '16 at 0:34
  • @gatorback The data is CSV. It effectively already is a spreadsheet, you just need to transform it however you wish – Berwyn Jul 30 '16 at 2:56

Not the answer you're looking for? Browse other questions tagged or ask your own question.