I'm dealing with a bit of data overload regarding open source O&D data for the domestic US. I hope this thread will assist the next person learning how to pull O&D data as well.
I want to see the daily average number of passengers traveling directly from origin(a) to all direct destinations by quarter with average fares.
On one end of the spectrum there is a tool on the Airline Empires site called "paxdata" that has a very simple UI and maps the data for you, but customized queries do not seem to be functioning and It appears that you can't look at data over time. Also did not see documentation on how timely the data is.
Transtats is highly sited here. I am attempting to decode the process to get the information I am looking for. I'm sure it looks intuitive to someone already familiar with the too. I'm not sure if I need to build out my own access DB and insert their tables or if there is a way to select a city and timeline and export a spreadsheet with relevant O&D data.
There are others of course. I'm not sure which are applicable to the US market and some seem to deliver different data sets than others.
Thanks for your help!