Originally Posted by
knope2001
A participant here sent me a PM asking how to get these numbers, but their profile is (apparently) not set up to receive PM's, so my direct reply was rejected. But I thought I might as well post it here for anyone else who might want to play with the stats.
This is where the domestic onboard load raw data is
http://www.transtats.bts.gov/DL_Sele...Short_Name=Air Carriers
Best bet is to pick a single state and month at a time, because the tables get very large if you don't narrow it down...often moer than the 65k or so records than older versions of Excel can handle. For each month, there's a separate entry for each city pair, each airline, and each operating airline. Simple math formulas in Excel come up with total load factor fairly easily.
Thanks knope2001 for sharing.
Charlie.