I looked at those number but it still doesn’t give me the whole picture... RDU flight didn’t look so great until spring and summer.. but that doesn’t mean the flight wasn’t profitable.. was the first class cabin full but main cabin possibly half full? I’m okay with that.. that makes a profitable flight. But if the main cabin was partial full and first/business class was mainly upgraded people.. that’s not as good.. can’t rally go by the number unless you know what they all mean..
Unfortunately, it is impossible to discern that level of scrutiny from T-100 data. The data only includes total number of seats and a passengers on a monthly basis. It does not differentiate between classes, and it does not provide any form of yield data. Of course, it's not a surprise that airlines don't want to divulge yield data on specific routes. If the yield data were publicly available, I would definitely include it.
My spreadsheet is simply a look at number of seats offered on a route, number of passengers using a route, and the percentage of offered seats filled by passengers on a route. Nothing else can be gleaned from the data. We all know that a full flight does not necessarily mean the flight is profitable, and vice versa for a flight that flies only 2/3rds full. Take the data for what is, a simple accounting of capacity, passengers, and load factors on a monthly and annualized basis.
Also, thanks for the shoutout uconn99. I had no idea people outside of the New Orleans thread were looking at this stuff.
I enjoy seeing your updated spreadsheet when posted since I follow the BDL-DUB flight closely. I have tried looking at the link you provided for T100 data but find it difficult to navigate. Any way to easily download medium and small sized TATL market data? If you would like to send me a private message instead feel free. I would appreciate it!
Some people use this site: http://www.aviationdb.com/Aviation/F4SD ... htm#SUBMIT
But it tends to be 1-3 months behind the actual data
Anyone who is wondering: https://www.transtats.bts.gov/Tables.as ... 20Carriers
-In the T-100 International Segment (All Carriers) box click "download"
-Once you reach the "Air Carriers : T-100 International Segment (All Carriers)" page
- Filter year and month to the time period you desire
- Under Fieldname: unselect all previous values, then select DepScheduled, DepPerformed, Available Seats, Non-Stop Segment Passengers Transported, Non-Stop Segment
Freight Transported (optional), Carrier Name, Origin Airport, Destination Airport, Aircraft Type (optional), Year, Month
- Then click "download"
- That should give you the data you want for all Int'l routes