Very nice data! Would you please tell me where you found all the route-specific data?
I tried to look on DOT's website, but couldn't find the route data like this. All I found was something like this https://www.transtats.bts.gov/Oneway.as ... lay_Flag=0
Thanks in advance!
https://www.transtats.bts.gov/Tables.as ... 20Carriers
This will link you to the tables for all carriers, there is also a US only one. Domestic data is 3 months behind, International 6 months (hence why my numbers are May), there's a lot of numbers to wade through, and the route info is all there, however you have to summarize it, which i do by formulas, then use that to post the data accordingly. Fair warning, the data is only as accurate as the information provided by the airlines, technically it's supposed to be accurate under pain of death, but there are plenty of filing errors in there, trust me. You also have to watch for diverts which will throw some of the route data off, but this should get you started and you can find the rest from there.