FlyerTalk Forums - View Single Post - May T-100s (onboard loads)
View Single Post
Old Aug 13, 2011 | 8:23 pm
  #2  
knope2001
 
Join Date: Oct 2004
Posts: 2,653
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.
knope2001 is offline