DBEA55AED16C0C92252A6554BC1553B2 Clicky DBEA55AED16C0C92252A6554BC1553B2 Clicky
April 23, 2024
Care to share?

Air travel is all about schedule. Passengers buy on price, but they are aware that once they have made a booking, their planning focuses around that schedule.  Mess with the schedule and all kinds of messages and images from annoyed travelers hit social media.

In fairness, airlines build a schedule which they want to operate – time is money for them in a very real sense.  But there are exogenous things like weather and illness that interrupt even the best-laid plans. Consequently, we are showing delays in average minutes.

How did US airlines doing with schedules in 2017 and 2018?  The model below allows you to drill down on several levels. Note the model has two pages, the first shows information by airline and aircraft. The second shows information by flight number. On either page, select a year and an airline then watch the numbers change.

On page one we list information by tail number and aircraft type – so you can see if there’s a specific “hanger queen”. Switch between years for a specific airline to see which numbers are near the top.  When you select a tail number the tables identify the OEM and model.

The model is huge – we combined more than 6m flights over 24 months and close to 6,000 aircraft from T-100D, TransStats and FlightRadar24. Because it is complex it might react slower than you like, but give it a moment. As always, click the double arrow on the right of the gray bar to maximize the screen.

author avatar
Addison Schonland
Co-Founder AirInsight. My previous life includes stints at Shell South Africa, CIC Research, and PA Consulting. Got bitten by the aviation bug and ended up an Avgeek. Then the data bug got me, making me a curious Avgeek seeking data-driven logic. Also, I appreciate conversations with smart people from whom I learn so much. Summary: I am very fortunate to work with and converse with great people.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.