Federal Aviation Administration Data Analysis Junyuan Ke Senhao

Federal Aviation Administration Data Analysis Junyuan Ke, Senhao Hu, Chen Fang

What we are trying to figure out: • Problem 1: How do flight delays vary among different airline carriers? • Do the SIZE or TYPE of an airline influence its certain aspect of delay? • The size of an airline is measured by the amount of flights it operated from July 2013 to 2014. • Airlines are categorized into Major airlines, Low-cost Airlines and Regional airlines. • Do extreme values exists? If so, what causes the different delay pattern? • Problem 2: Do a certain type of delay have a less stable pattern than others? How are they more unpredictable?

Although several carriers(Frontier, American Eagle, Jet. Blue, Express) have higher percentage of delay than others, the size of carriers does not determine their total percentage of delay. Percentage of Delay of Carriers Sorted by Size 0. 3 Delay Ratio 0. 25 0. 2 0. 15 0. 1 0. 05 Ai rw Ha ay w s ai ia n Ai rli ne Je s t. B lu e Ai rw Ex pr ay es s s. J et Ai rli en s De lta Ai rli ne s US Ai rw ay Un s ite d Ai rli Am ne er s ica n Ai So rli ne ut hw s es t. A irl in es n Ai r. T ra t. A irl in e s gle Ea yw es n Sk ica er Am rg in Ai Am er ica s rli ne s ka Al as Vi Pi nn ac le Ai rli av or ne Ai es de es M En a. A irl in s in e irl r. A tie on Fr r 0 Airline Carriers (sorted from small to large) New Variables: Percentage of Delay = Total delay flights / total flights

Different types of delay do not follow certain trends among carriers. Late aircraft, Carrier and NAS delays accounted for the major portion of the total delay. The percentages of delay due to Weather and Security reasons are significantly smaller than the rest. Percentage of Delay by Reasons among Carriers 0. 7 Percentage of Total Delay 0. 6 Total Percentage of Delay by Reason 0. 5 Late aircraft 39% 0. 4 0. 3 0. 2 NAS 29% 0. 1 carrier_ct weather_ct nas_ct security_ct s t. A Ai So ut hw es n ica er New Variables: Percentage of Total Delay = Certain Delay Count /Total Delay Count of irl i rli ne ne s s rli ne Ai d late_aircraft_ct Am ite Un US lta De Ex Airline Carriers (sorted from small to large) Ai rw ay s s ne Ai rli ie n Ai rl s. J et pr es lu e Je t. B ia s s Ai rw ay s ne Ai rli n Ai rw ay s Ha w ai n in e ra Ai r. T yw es n Sk ica er Am in rg t. A irl Ea er Am rli Ai s gle ica s ne s ka Al as Vi Pi nn ac le Ai rli av or ne Ai s de es M En a. A irl in e s in e irl r. A tie on r 0 Fr Carrier 29% Security 0. 15% Weather 3%

Delay By Reasons of Regional Airlines Delay By Reasons of Major Airlines 0. 7 0. 6 0. 5 0. 4 0. 3 American Eagles Skywest Mesa Hawaiian Delta Frontier Virgin Air Express. Jet US Airline Alaska United Airlines Air. Tran Airways Jet. Blue American Airlines ct ai rc ra e_ la t Endeavor Pinnacle ft_ ct y_ rit cu se na er ea th s_ t _c ct r_ w ai rc ra rie ft_ ct la te _ se cu rit y_ s_ er th w ea na _c ct r_ rie ct 0 t 0. 1 ca r ct e_ la t se cu ai rc ra rit y_ ft_ ct ct s_ er th ea w na t _c ct r_ rie ca r 0. 1 ct 0. 2 ca r 0. 5 0. 4 0. 35 0. 3 0. 25 0. 2 0. 15 0. 1 0. 05 0 Delay By Reasons of Low-Cost Airlines Southwest Airlines

cle or a r as k Am Virg a in er Ai ica r n Ea gle s S Ai r. T kyw ra es n Ai t rw a Ha ys w ai ia n Je t. B Ex lue pr es s. J et De lta U Un S Ai rli it ne Am ed A irl er i i So can nes ut A hw irli n es t A es irl in es Al na Pi n av es M tie on de En Fr Carrier and NAS Delay 0. 7 0. 6 0. 5 0. 4 0. 3 0. 2 0. 1 0 carrier_ct nas_ct