Ask a Librarian & FAQs

To get load factor for one or two fields, go to https://www.transtats.bts.gov/ 

Click "Aviation" and then one of the Air Carrier Statistics (Form 41 Traffic) databases, depending on which carriers you need. Then select one of the T-100 Segment schedules.

Click "Analysis" next to "Load Factor." Bear in mind, this will let you do up to 2 fields using crosstabs, like Carrier and Origin Airport, but not more.

If you want load factor by more than two fields, carrier AND route, for example, follow these instructions:

From the TranStats home page, click "Aviation" and then one of the Air Carrier Statistics (Form 41 Traffic) databases, depending on which carriers you need. Then click "Download" next to one of the T-100 Segment schedules. Set the filter menus to a particular state and/or month, if you want to limit the search that way.

Download the following fields:

1. Departures Performed
2. Seats
3. Passengers
4. Carrier fields
5. Origin fields
6. Destination fields
7. Month
8. Aircraft Type
9. Service Class (the last 3 are optional, but there will be separate rows for each within the carrier/origin/destination sets)

Calculating in Excel:

1. Filter out rows with no passengers
2. If you want to just look at scheduled service, filter for Service Class F as well.
3. Custom sort or filter by carrier, then origin, then destination
4. For each row, multiply distance times the number of departures
5. Multiply that total distance by available seats to get Available Seat Miles for each row
6. Multiply total distance by revenue passengers to get Revenue Passenger Miles for each row
7. Sum the total ASMs and RPMs for the rows with the flights you want, for example, AS from ATL to SEA
8. Then divide RPMs by ASMs for each set of flights in #6 to get the load factor for that Carrier/Origin/Destination

Here is an example, based on one month's data, with flights in and out of Georgia only: