FlyerTalk Forums - View Single Post - May T-100s (onboard loads)
View Single Post
Old Aug 14, 2011 | 6:19 pm
  #4  
AviationFan24
 
Join Date: Jul 2008
Location: Colorado
Programs: Skymiles, Mileage Plus
Posts: 89
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.
AviationFan24 is offline