Placekicker From United States of America, joined Apr 2008, 22 posts, RR: 0 Posted (6 years 1 week 5 days 8 hours ago) and read 2514 times:
the percentage of occupancy for any given flight? Is this data published by the airlines? If I wanted to know the occupancy rate for all of American Airlines flights between city "A" and city "B" (i.e. MIA-to-SFO) for a 12 week span, is there any easy way to obtain that data? Are there websites which publish such data?
Kleinsim From Qatar, joined Jan 2007, 154 posts, RR: 0
Reply 2, posted (6 years 1 week 5 days 7 hours ago) and read 2465 times:
As a matter of fact there is. So long as you are dealing with domestic United States operations. The datasets you want are the DB1B Origin/Destination survey which is a 10% sample of all airline tickets flown in the United States and the T-100 survey which gives you passengers, seats, aircraft, origin, destination, etc. by route. None of the datasets break this down to a flight number or timing basis. The best you get is monthly data (T-100) or quarterly (DB1B).
Please note that the datasets are extremely large. You will need SAS or STATA to open them (Excel will not do) since one quarter of DB1B data is 1.3GB big. IM me or reply if you need more information. I'd be happy to help.