Visualizing what airlines fly in US Airports [closed]

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

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/

Best Answer

Something like this?

$ wget https://raw.githubusercontent.com/jpatokal/openflights/master/data/routes.dat
$ awk -F, '$3 == "MDW" {print $1}' routes.dat|sort -u
AF
DL
F9
FL
KL
P1
PD
SY
WN
Y4

Pictures about "Visualizing what airlines fly in US Airports [closed]"

Visualizing what airlines fly in US Airports [closed] - White and Blue Lufthansa Airplane

Visualizing what airlines fly in US Airports [closed] - White Airplane Near Man in Green Vest

Visualizing what airlines fly in US Airports [closed] - Photo of Airplane Over Runway

What airports have the most Cancelled flights?

Summary: Louis Armstrong New Orleans International Airport reported the highest cancellation rates in the country for 2021 with an average cancellation rate of more than 6%. Airports in Texas, DFW, HOU, and DAL, also topped the list of flight cancellations.

Which airlines fly to USA now?

United, Air India, Air Canada and American Airlines all fly direct to United States.

Did flights stop during Covid?

Significant reductions in passenger numbers have resulted in flights being cancelled or planes flying empty between airports, which in turn massively reduced revenues for airlines and forced many airlines to lay off employees or declare bankruptcy.

Is any flight Cancelled today?

There is no flight cancellation for today.

A New Pilot Makes His First Ever Flight With Passengers! | EasyJet: Inside The Cockpit | ITV

Sources: Stack Exchange - This article follows the attribution requirements of Stack Exchange and is licensed under CC BY-SA 3.0.

Images: Bibhash (knapsnack.life) Banerjee, Pixabay, Tim Gouw, Winnie The Pooh