Question
Question 1 You are to analyse a dataset AirTicket.xlsx to answer the following questions. The provided dataset contains several records of one-way airline tickets sold
Question 1 You are to analyse a dataset AirTicket.xlsx to answer the following questions. The provided dataset contains several records of one-way airline tickets sold over a quarter. Each record represents one air ticket. It is possible to have a single ticket that allows multiple passengers to fly, e.g., corporations or travel agencies made the purchase. Variables Dictionary ID: Unique record identifier ORIGIN: Origin Airport Code DEST: Destination Airport Code TICKET_CARRIER: Ticketing Carrier Code for On-line Itineraries OPERATING_CARRIER: Operating Carrier Code for On-line Itineraries PASSENGERS: Number of Passengers MARKET_FARE: Market Fare ($) MARKET_DISTANCE: Market Distance (miles) DISTANCE_GROUP: Distance Group, in 500 Mile Intervals
ID | ORIGIN | DEST | TICKET_CARRIER | OPERATING_CARRIER | PASSENGERS | MARKET_FARE | MARKET_DISTANCE | DISTANCE_GROUP | |
33 | ATL | SNA | DL | DL | 28 | 2926 | 1919 | 4 | |
2 | ABE | ORD | US | US | 1 | 257 | 733 | 2 | |
3 | ABQ | AUS | WN | WN | 1 | 240 | 751 | 2 | |
4 | ABQ | BWI | WN | WN | 2 | 203 | 1670 | 4 | |
5 | ABQ | MCO | WN | WN | 12 | 705 | 1552 | 4 | |
6 | ABQ | TPA | WN | WN | 2 | 246 | 1497 | 3 | |
7 | ACY | TPA | NK | NK | 6 | 261 | 914 | 2 | |
71 | BNA | STT | DL | DL | 1 | 1077 | 1813 | 4 | |
9 | ALB | JAX | WN | WN | 4 | 464 | 951 | 2 | |
10 | ALB | ORD | UA | S5 | 1 | 183 | 723 | 2 | |
11 | ALB | TPA | US | US | 1 | 164 | 1132 | 3 | |
12 | AMA | DAL | WN | WN | 1 | 66 | 324 | 1 | |
13 | ANC | FAI | AS | AS | 1 | 131 | 261 | 1 | |
665 | SLC | GEG | DL | OO | 4 | 761 | 546 | 2 | |
350 | LAX | SAV | DL | DL | 1 | 715 | 2161 | 5 | |
682 | SMF | VPS | DL | DL | 2 | 706 | 2356 | 5 | |
52 | BDL | PBI | DL | DL | 6 | 657 | 1133 | 3 | |
50 | BDL | MLB | DL | DL | 1 | 639 | 1302 | 3 | |
19 | ATL | BWI | FL | FL | 1 | 58 | 576 | 2 | |
578 | PVD | MIA | DL | DL | 10 | 620 | 1498 | 3 | |
668 | SLC | OKC | DL | DL | 1 | 604 | 1300 | 3 | |
76 | BOS | ATL | DL | DL | 1 | 589 | 946 | 2 | |
23 | ATL | DTW | NW | NW | 4 | 461 | 594 | 2 | |
24 | ATL | IAD | UA | YV | 2 | 280 | 533 | 2 | |
80 | BOS | PNS | DL | DL | 4 | 568 | 1218 | 3 | |
134 | CVG | AVL | DL | OH | 1 | 568 | 275 | 1 | |
510 | ORF | CRP | DL | CO | 1 | 566 | 1402 | 3 | |
28 | ATL | MKE | YX | YX | 1 | 153 | 669 | 2 | |
153 | DCA | LAX | DL | DL | 1 | 555 | 2441 | 5 | |
334 | LAX | SAV | DL | DL | NULL | 554 | 2161 | 5 | |
360 | LGA | DCA | DL | DL | NULL | 546 | 214 | 1 | |
177 | DFW | CVG | DL | OH | NULL | 539 | 812 | 2 | |
104 | CAE | TLH | DL | EV | NULL | 522 | 414 | 1 | |
302 | JFK | CVG | DL | DL | NULL | 492 | 589 | 2 | |
32 | ATL | SLC | DL | DL | NULL | 479 | 2332 | 5 | |
36 | AUS | DEN | F9 | F9 | NULL | 237 | 775 | 2 | |
37 | AUS | DTW | NW | NW | NULL | 348 | 1169 | 3 | |
38 | AUS | EWR | CO | CO | NULL | 421 | 1540 | 4 | |
39 | AUS | FAR | UA | OO | NULL | 42 | 1402 | 3 | |
47 | AVP | ATL | DL | EV | 1 | 457 | 714 | 2 | |
41 | AUS | LAS | AA | AA | 1 | 150 | 1245 | 3 | |
42 | AUS | MCI | CO | CO | 1 | 175 | 783 | 2 | |
43 | AUS | OAK | WN | WN | 1 | 281 | 1578 | 4 | |
44 | AUS | PBI | CO | CO | 1 | 158 | 1096 | 3 | |
45 | AUS | TUS | WN | WN | 1 | 166 | 1455 | 3 | |
68 | BNA | PHL | DL | OH | 1 | 450 | 737 | 2 | |
16 | ATL | AUS | DL | DL | 1 | 442 | 813 | 2 | |
48 | BDL | FLL | WN | WN | 1 | 89 | 1228 | 3 | |
49 | BDL | JAX | WN | WN | 1 | 100 | 938 | 2 | |
59 | BHM | STT | DL | DL | 1 | 417 | 1733 | 4 | |
26 | ATL | LGA | DL | DL | 1 | 412 | 761 | 2 | |
86 | BUF | ATL | DL | DL | 1 | 406 | 1524 | 4 | |
53 | BDL | STL | AA | AX | 1 | 154 | 957 | 2 | |
54 | BDL | TUS | AA | AA | 2 | 276 | -9999 | 5 | |
311 | LAS | ANC | DL | DL | 1 | 390 | 2493 | 5 | |
56 | BHM | DFW | AA | AA | 3 | 295 | 597 | 2 | |
57 | BHM | IAH | CO | RU | 1 | 176 | 562 | 2 | |
58 | BHM | MSP | NW | DL | 1 | 179 | 1040 | 3 | |
14 | ATL | ABQ | DL | DL | 1 | 382 | 1269 | 3 | |
60 | BIL | EWR | NW | NW | 1 | 235 | 1756 | 4 | |
61 | BIL | PDX | AS | QX | 3 | 59 | 679 | 2 | |
62 | BIS | MSP | NW | 9E | 1 | 285 | 386 | 1 | |
63 | BNA | BNA | WN | WN | 1 | 150 | 338 | 1 | |
64 | BNA | BNA | UA | OO | 1 | 265 | 1085 | 3 | |
65 | BNA | BNA | UA | OO | 1 | 153 | 1013 | 3 | |
66 | BNA | BNA | WN | WN | 6 | 373 | 670 | 2 | |
67 | BNA | BNA | AA | AA | 1 | 113 | 409 | 1 | |
600 | RSW | BOS | DL | DL | 1 | 374 | 1461 | 3 | |
69 | BNA | SAN | AA | AA | 1 | 471 | 1802 | 4 | |
70 | BNA | SAT | WN | WN | 1 | 150 | 822 | 2 | |
417 | MEM | SLC | DL | DL | 1 | 363 | 1921 | 4 | |
247 | FSD | TYS | DL | OH | 1 | 358 | 927 | 2 | |
73 | BOI | IAH | CO | CO | 1 | 200 | 1482 | 3 | |
74 | BOI | ROC | UA | UA | 1 | 42 | 1965 | 4 | |
22 | ATL | DFW | DL | DL | 1 | 338 | 732 | 2 | |
295 | JAN | PHX | DL | DL | 1 | 320 | 1928 | 4 | |
77 | BOS | IAD | UA | UA | 1 | 113 | 413 | 1 | |
78 | BOS | MIA | AA | AA | 1 | 249 | 1258 | 3 | |
79 | BOS | PBI | B6 | B6 | 1 | 142 | 1197 | 3 | |
137 | CVG | DFW | DL | DL | 1 | 315 | 812 | 2 | |
21 | ATL | DEN | DL | DL | 1 | 306 | 1199 | 3 | |
82 | BOS | SLC | UA | UA | 1 | 154 | 2116 | 5 | |
83 | BOS | SRQ | FL | FL | 1 | 138 | 1220 | 3 | |
84 | BOS | STL | AA | MQ | 1 | 513 | 1046 | 3 | |
85 | BRO | DSM | CO | RU | 1 | 845 | 1110 | 3 | |
672 | SLC | SJC | DL | DL | 1 | 302 | 585 | 2 | |
87 | BUF | BTV | B6 | B6 | 1 | 87 | 568 | 2 | |
88 | BUF | LIT | WN | WN | 1 | 232 | 1193 | 3 | |
89 | BUF | SAN | WN | WN | 1 | 133 | 2216 | 5 | |
90 | BUR | CMH | AA | AA | 1 | 151 | -9999 | 5 | |
91 | BUR | LAS | WN | WN | 30 | 1118 | 223 | 1 | |
92 | BUR | RNO | WN | WN | 1 | 120 | 484 | 1 | |
93 | BUR | RNO | WN | WN | 1 | 123 | 505 | 2 | |
94 | BUR | SFO | UA | UA | 1 | 102 | 326 | 1 | |
95 | BWI | BHM | WN | WN | 2 | 163 | 682 | 2 | |
96 | BWI | FLL | FL | FL | 1 | 242 | 925 | 2 | |
97 | BWI | HOU | WN | WN | 3 | 175 | 1246 | 3 | |
696 | TPA | BOS | DL | DL | 2 | 298 | 1185 | 3 | |
99 | BWI | OAK | UA | UA | 1 | 185 | 2456 | 5 | |
100 | BWI | SAN | WN | WN | 1 | 240 | 2295 | 5 | |
101 | BWI | STL | WN | WN | 4 | 416 | 862 | 2 | |
102 | BZN | ORF | NW | NW | 1 | 379 | 1931 | 4 | |
103 | CAE | PIT | UA | YV | 1 | 108 | 584 | 2 | |
139 | CVG | MHT | DL | OH | 1 | 298 | 741 | 2 | |
105 | CAK | BOS | FL | FL | 1 | 149 | 549 | 2 | |
106 | CHS | PHL | US | RP | 1 | 137 | 550 | 2 | |
107 | CLE | BNA | WN | WN | 1 | 56 | 448 | 1 | |
108 | CLE | BOS | CO | CO | 2 | 647 | 563 | 2 | |
109 | CLE | DFW | CO | RU | 33 | 2591 | 1021 | 3 | |
110 | CLE | MCO | CO | CO | 2 | 0 | 895 | 2 | |
111 | CLE | MIA | AA | MQ | 2 | 117 | 1080 | 3 | |
112 | CLE | ORD | UA | UA | 1 | 120 | 316 | 1 | |
113 | CLE | ORF | CO | RU | 7 | 436 | 435 | 1 | |
114 | CLE | SEA | UA | UA | 1 | 200 | 2225 | 5 | |
714 | TWF | SBA | DL | OO | 1 | 296 | 790 | 2 | |
116 | CLT | DCA | US | US | 1 | 47 | 330 | 1 | |
117 | CLT | DTW | NW | XJ | 1 | 265 | 500 | 2 | |
118 | CLT | ILM | US | 16 | 1 | 333 | 185 | 1 | |
119 | CLT | LAS | US | US | 2 | 208 | 1917 | 4 | |
120 | CLT | MCI | US | 16 | 1 | 699 | 809 | 2 | |
121 | CLT | MIA | AA | MQ | 2 | 154 | 650 | 2 | |
122 | CLT | MIA | US | US | 1 | 272 | 650 | 2 | |
123 | CLT | MSP | US | YV | 1 | 259 | 930 | 2 | |
574 | PNS | MIA | DL | DL | 1 | 293 | 867 | 2 | |
125 | CMH | BWI | WN | WN | 1 | 102 | 336 | 1 | |
126 | CMH | DTW | NW | NW | 3 | 340 | 155 | 1 | |
55 | BHM | DCA | DL | DL | 1 | 279 | 681 | 2 | |
128 | CMH | ORD | UA | UA | 1 | 54 | 296 | 1 | |
129 | COS | ALB | UA | OO | 1 | 486 | 1634 | 4 | |
130 | COS | MCI | UA | UA | 1 | 236 | 605 | 2 | |
131 | CRP | ATL | CO | RU | 1 | 0 | 890 | 2 | |
132 | CRP | TUL | WN | WN | 1 | 156 | 640 | 2 | |
133 | CRW | ORD | UA | OO | 1 | 334 | 416 | 1 | |
607 | SAN | ATL | DL | DL | 1 | 276 | 1891 | 4 | |
606 | RSW | SNA | DL | DL | 1 | 274 | 2434 | 5 | |
136 | CVG | DFW | AA | MQ | 1 | 233 | 812 | 2 | |
519 | PBI | LGA | DL | DL | 1 | 273 | 1306 | 3 | |
584 | PWM | LGA | DL | OH | 1 | 261 | 270 | 1 | |
397 | MCO | LAS | DL | DL | 1 | 253 | 2297 | 5 | |
303 | JFK | FLL | DL | DL | 1 | 250 | 1069 | 3 | |
29 | ATL | MSY | DL | DL | 2 | 249 | 425 | 1 | |
142 | DAL | IAD | CO | RU | 1 | 139 | 1407 | 3 | |
143 | DAL | SAT | WN | WN | 1 | 77 | 248 | 1 | |
144 | DAY | ATL | FL | FL | 33 | 1468 | 432 | 1 | |
145 | DAY | DCA | US | ZW | 1 | 215 | 391 | 1 | |
146 | DCA | AUS | AA | AA | 1 | 170 | 1382 | 3 | |
147 | DCA | BOS | US | US | 7 | 807 | 399 | 1 | |
148 | DCA | BUF | US | US | 1 | 38 | 398 | 1 | |
149 | DCA | CAE | US | ZW | 1 | 175 | 408 | 1 | |
150 | DCA | FLL | US | US | 1 | 148 | 962 | 2 | |
151 | DCA | IND | NW | NW | 3 | 112 | 499 | 1 | |
152 | DCA | JFK | AA | MQ | 1 | 114 | 213 | 1 | |
25 | ATL | LAX | DL | DL | 4 | 244 | 1946 | 4 | |
154 | DCA | LAX | US | US | 1 | 155 | 2341 | 5 | |
155 | DCA | MSP | UA | UA | 2 | 137 | 946 | 2 | |
156 | DCA | MSY | NW | NW | 1 | 140 | 1111 | 3 | |
157 | DCA | RDU | AA | MQ | 1 | 136 | 227 | 1 | |
158 | DCA | SAN | NW | DL | 1 | 123 | 2438 | 5 | |
159 | DEN | ASE | UA | ZW | 1 | 311 | 125 | 1 | |
160 | DEN | AUS | F9 | QX | 1 | 191 | 775 | 2 | |
161 | DEN | BWI | UA | UA | 2 | 304 | 1491 | 3 | |
162 | DEN | BWI | US | US | 1 | 148 | 1698 | 4 | |
163 | DEN | DFW | UA | UA | 1 | 170 | 641 | 2 | |
164 | DEN | EUG | UA | OO | 5 | 360 | 997 | 2 | |
165 | DEN | EWR | CO | CO | 11 | 0 | 1605 | 4 | |
166 | DEN | FLL | UA | UA | 10 | 1420 | 1703 | 4 | |
167 | DEN | LAX | UA | UA | 1 | 154 | 862 | 2 | |
168 | DEN | MDT | US | US | 1 | 259 | 1475 | 3 | |
169 | DEN | MIA | UA | UA | 1 | 172 | 1709 | 4 | |
170 | DEN | PHL | NW | NW | 1 | 97 | 1576 | 4 | |
171 | DEN | RDU | AA | AA | 1 | 963 | 1703 | 4 | |
172 | DEN | RNO | UA | UA | 1 | 95 | 804 | 2 | |
173 | DEN | SAN | UA | UA | 1 | 133 | 853 | 2 | |
174 | DEN | SAT | AA | AA | 1 | 133 | 794 | 2 | |
175 | DEN | STL | UA | UA | 10 | 830 | 770 | 2 | |
176 | DFW | CAK | FL | FL | 1 | 256 | 1260 | 3 | |
75 | BOI | SLC | DL | OO | 5 | 241 | 291 | 1 | |
178 | DFW | DCA | YX | YX | 3 | 100 | 1192 | 3 | |
179 | DFW | GRR | AA | MQ | 1 | 106 | 931 | 2 | |
180 | DFW | HSV | AA | AA | 1 | 59 | 603 | 2 | |
181 | DFW | IAD | CO | RU | 1 | 189 | 1414 | 3 | |
182 | DFW | LAX | AA | AA | 1 | 371 | 1235 | 3 | |
183 | DFW | LAX | AA | AA | 1 | 329 | 1503 | 4 | |
184 | DFW | MCI | AA | AA | 1 | 326 | 460 | 1 | |
185 | DFW | MIA | AA | AA | 4 | 323 | 1121 | 3 | |
186 | DFW | MKE | AA | MQ | 1 | 278 | 853 | 2 | |
187 | DFW | OMA | AA | AA | 1 | 553 | 583 | 2 | |
188 | DFW | PNS | AA | MQ | 1 | 240 | 604 | 2 | |
189 | DFW | PSP | AA | AA | 2 | 142 | 1126 | 3 | |
190 | DFW | RSW | US | US | 1 | 141 | 1537 | 4 | |
191 | DFW | SLC | HP | HP | 1 | 319 | 1375 | 3 | |
192 | DFW | TYS | AA | MQ | 21 | 414 | 772 | 2 | |
642 | SFO | ATL | DL | DL | 1 | 240 | 2139 | 5 | |
194 | DSM | ORD | UA | OO | 3 | 338 | 299 | 1 | |
195 | DTW | AUS | CO | CO | 1 | 512 | 1216 | 3 | |
196 | DTW | BUF | NW | NW | 1 | 439 | 240 | 1 | |
197 | DTW | GSP | NW | 9E | 1 | 168 | 508 | 2 | |
198 | DTW | GUC | AA | AA | 1 | 127 | 1665 | 4 | |
199 | DTW | LAS | NW | NW | 1 | 533 | 1750 | 4 | |
200 | DTW | LGA | NK | NK | 1 | 103 | 501 | 2 | |
201 | DTW | PDX | NW | NW | 1 | 415 | 1954 | 4 | |
202 | DTW | PHX | CO | NW | 1 | 216 | 1671 | 4 | |
203 | DTW | PIT | NW | XJ | 1 | 241 | 201 | 1 | |
204 | DTW | RNO | WN | WN | 1 | 172 | 2272 | 5 | |
205 | DTW | RSW | NW | NW | 1 | 95 | 1085 | 3 | |
206 | EGE | ATL | NW | NW | 1 | 158 | 1694 | 4 | |
207 | EGE | SFO | UA | UA | 1 | 92 | 847 | 2 | |
208 | ELP | LGA | AA | AA | 1 | 126 | 1969 | 4 | |
209 | ELP | RNO | WN | WN | 1 | 198 | 929 | 2 | |
210 | EUG | BNA | UA | OO | 1 | 283 | 2010 | 5 | |
211 | EUG | SFO | UA | OO | 1 | 315 | 451 | 1 | |
212 | EWR | BUF | CO | RU | 2 | 78 | 282 | 1 | |
213 | EWR | IAD | CO | RU | 1 | 288 | 213 | 1 | |
214 | EWR | JAX | FL | FL | 1 | 137 | 1015 | 3 | |
215 | EWR | MIA | AA | AA | 2 | 140 | 1086 | 3 | |
216 | EWR | MSP | NW | NW | 1 | 432 | 1008 | 3 | |
217 | EWR | ORD | CO | CO | 1 | 0 | 719 | 2 | |
218 | EWR | PDX | CO | CO | 1 | 121 | 2433 | 5 | |
219 | EWR | SAT | CO | CO | 1 | 148 | 1591 | 4 | |
220 | EWR | SJU | AA | AA | 1 | 165 | 1608 | 4 | |
221 | FAT | EUG | AS | QX | 1 | 306 | 982 | 2 | |
255 | GSP | MCO | DL | DL | 3 | 239 | 556 | 2 | |
515 | PBI | BOS | DL | DL | 1 | 238 | 1197 | 3 | |
224 | FLL | BDL | WN | WN | 1 | 165 | 1228 | 3 | |
225 | FLL | BOS | FL | FL | 1 | 112 | 1295 | 3 | |
226 | FLL | BWI | WN | WN | 1 | 212 | 925 | 2 | |
227 | FLL | CLT | US | US | 5 | 785 | 632 | 2 | |
228 | FLL | DEN | F9 | F9 | 1 | 194 | 1703 | 4 | |
229 | FLL | DTW | NW | NW | 8 | 616 | 1127 | 3 | |
230 | FLL | IND | NW | NW | 2 | 132 | 1232 | 3 | |
98 | BWI | MSY | DL | DL | 1 | 234 | 1001 | 3 | |
232 | FLL | LAS | UA | UA | 1 | 325 | 2332 | 5 | |
666 | SLC | HSV | DL | DL | 1 | 229 | 1740 | 4 | |
30 | ATL | PIT | DL | DL | 1 | 228 | 526 | 2 | |
235 | FLL | MCI | NW | NW | 1 | 168 | 1243 | 3 | |
236 | FLL | MCI | YX | YX | 1 | 130 | 1242 | 3 | |
237 | FLL | MHT | WN | WN | 6 | 242 | 1263 | 3 | |
238 | FLL | MSY | WN | WN | 2 | 371 | 1260 | 3 | |
239 | FLL | ONT | WN | WN | 1 | 42 | 2297 | 5 | |
240 | FLL | ORD | AA | AA | 1 | 298 | 1182 | 3 | |
241 | FLL | RNO | AA | AA | 1 | 211 | 2464 | 5 | |
242 | FLL | STL | AA | AA | 1 | 590 | 1056 | 3 | |
243 | FLL | TPA | NK | NK | 2 | 47 | 197 | 1 | |
244 | FNT | BNA | NW* | NW | 1 | 136 | 513 | 2 | |
245 | FNT | DCA | AA | MQ | 1 | 128 | 835 | 2 | |
246 | FSD | MSP | NW* | 9E | 1 | 445 | 197 | 1 | |
222 | FCA | SFO | DL | OO | 1 | 225 | 1131 | 3 | |
248 | GEG | ATL | UA | UA | 1 | 188 | 2104 | 5 | |
249 | GEG | SMF | WN | WN | 1 | 141 | 758 | 2 | |
250 | GPT | MSP | NW* | NW | 2 | 367 | 1024 | 3 | |
251 | GPT | PBI | FL | FL | 1 | 443 | 897 | 2 | |
252 | GPT | STL | NW* | NW | 1 | 190 | 580 | 2 | |
253 | GRR | LAS | NW* | NW | 1 | 146 | 1870 | 4 | |
254 | GRR | MIA | NW* | NW | 1 | 421 | 1265 | 3 | |
141 | CVG | SAT | DL | OH | 1 | 224 | 1024 | 3 | |
256 | HNL | LIH | HA | HA | 79 | 2568 | 102 | 1 | |
257 | HOU | TUL | WN | WN | 2 | 152 | 453 | 1 | |
258 | HRL | ELP | WN | WN | 1 | 286 | 953 | 2 | |
259 | IAD | CHS | UA | ZW | 10 | 533 | 441 | 1 | |
260 | IAD | DFW | AA | AA | 1 | 473 | 1172 | 3 | |
261 | IAD | EGE | NW | NW | 1 | 194 | 1696 | 4 | |
369 | LGA | PBI | DL | DL | 4 | 213 | 1035 | 3 | |
263 | IAD | IAH | UA | S5 | 1 | 487 | 1190 | 3 | |
264 | IAD | LAX | UA | UA | 1 | 517 | 2288 | 5 | |
265 | IAD | LGB | B6 | B6 | 1 | 179 | 2277 | 5 | |
266 | IAD | MIA | UA | UA | 1 | 133 | 921 | 2 | |
267 | IAD | PDX | UA | UA | 1 | 246 | 2444 | 5 | |
268 | IAD | SAN | UA | UA | 1 | 335 | 2253 | 5 | |
269 | IAD | SJU | AA | AA | 1 | 132 | 1571 | 4 | |
270 | IAH | DAL | CO | RU | 5 | 256 | 217 | 1 | |
271 | IAH | DEN | CO | CO | 1 | 270 | 861 | 2 | |
272 | IAH | DEN | UA | UA | 1 | 245 | 861 | 2 | |
273 | IAH | GPT | CO | CO | 1 | 453 | 376 | 1 | |
17 | ATL | BTR | DL | EV | 1 | 212 | 449 | 1 | |
275 | IAH | LAX | CO | CO | 1 | 550 | 1379 | 3 | |
276 | IAH | LFT | CO | RU | 1 | 334 | 201 | 1 | |
277 | IAH | PHL | US | RW | 2 | 51 | 1324 | 3 | |
278 | IAH | PIT | CO | RU | 5 | 318 | 1117 | 3 | |
279 | IAH | SJC | CO | CO | 1 | 303 | 1608 | 4 | |
280 | ICT | RSW | FL | FL | 1 | 378 | 1296 | 3 | |
513 | PBI | ATL | DL | DL | 1 | 212 | 545 | 2 | |
282 | IND | FLL | US | US | 1 | 79 | 1060 | 3 | |
283 | IND | GEG | NW | NW | 1 | 267 | 1678 | 4 | |
81 | BOS | RSW | DL | DL | 1 | 207 | 1249 | 3 | |
285 | IND | JAX | CO | CO | 1 | 161 | 1465 | 3 | |
286 | IND | ORD | AA | MQ | 5 | 230 | 177 | 1 | |
287 | IND | SAT | NW | NW | 1 | 261 | 1006 | 3 | |
262 | IAD | ELP | DL | DL | 1 | 207 | 1815 | 4 | |
289 | IND | TPA | NW | NW | 3 | 223 | 838 | 2 | |
290 | ISP | BNA | WN | WN | 1 | 105 | 807 | 2 | |
291 | ISP | PHX | WN | WN | 1 | 178 | 2189 | 5 | |
292 | JAC | FLL | AA | AA | 1 | 880 | -9999 | 5 | |
293 | JAN | MAF | WN | WN | 2 | 294 | 800 | 2 | |
294 | JAN | MDW | WN | WN | 1 | 180 | 666 | 2 | |
532 | PDX | TPA | DL | DL | 1 | 207 | 2497 | 5 | |
296 | JAX | CLT | US | US | 1 | 47 | 329 | 1 | |
297 | JAX | CLT | US | US | 1 | 181 | 329 | 1 | |
587 | RDU | JAN | DL | DL | 1 | 203 | 697 | 2 | |
299 | JAX | MEM | NW | XJ | 1 | 147 | 576 | 2 | |
300 | JAX | MHT | WN | WN | 1 | 147 | 1040 | 3 | |
301 | JAX | SAT | CO | CO | 1 | 179 | 1008 | 3 | |
474 | ONT | ATL | DL | DL | 1 | 197 | 1900 | 4 | |
413 | MEM | ATL | DL | DL | 2 | 191 | 332 | 1 | |
393 | MCO | IAD | DL | DL | 1 | 188 | 936 | 2 | |
305 | JFK | LAS | B6 | B6 | 1 | 185 | 2248 | 5 | |
306 | JFK | LAX | AA | AA | 1 | 1592 | -9999 | 5 | |
594 | RIC | TPA | DL | OH | 1 | 186 | 723 | 2 | |
308 | JFK | PSE | B6 | B6 | 1 | 140 | 1617 | 4 | |
309 | JFK | SJU | AA | AA | 1 | 638 | 1597 | 4 | |
357 | LFT | ATL | DL | EV | 1 | 185 | 503 | 2 | |
72 | BOI | BFL | DL | OO | 1 | 184 | 825 | 2 | |
312 | LAS | AZO | NW | NW | 1 | 276 | 1863 | 4 | |
313 | LAS | CID | G4 | G4 | 6 | 375 | 1320 | 3 | |
314 | LAS | DCA | HP | HP | 1 | 161 | 2089 | 5 | |
315 | LAS | DCA | HP | HP | 1 | 165 | 2089 | 5 | |
316 | LAS | DEN | F9 | F9 | 5 | 295 | 629 | 2 | |
317 | LAS | DTW | NW | NW | 1 | 131 | 1750 | 4 | |
318 | LAS | EWR | HP | HP | 2 | 1074 | 2389 | 5 | |
319 | LAS | IAH | HP | YV | 2 | 234 | 1222 | 3 | |
320 | LAS | IND | WN | WN | 1 | 71 | 1591 | 4 | |
321 | LAS | LAX | AA | AA | 2 | 49 | 236 | 1 | |
322 | LAS | MCO | AA | AA | 1 | 261 | -9999 | 5 | |
323 | LAS | MDW | WN | WN | 1 | 103 | 1521 | 4 | |
324 | LAS | MIA | HP | HP | 1 | 273 | 2175 | 5 | |
325 | LAS | ORD | UA | UA | 1 | 203 | 1515 | 4 | |
326 | LAS | PDX | WN | WN | 1 | 121 | 762 | 2 | |
327 | LAS | SAT | WN | WN | 1 | 174 | 1295 | 3 | |
328 | LAS | SNA | HP | HP | 1 | 118 | 226 | 1 | |
329 | LAX | ATL | FL | FL | 9 | 569 | 1946 | 4 | |
330 | LAX | ATL | HP | HP | 1 | 140 | 1983 | 4 | |
331 | LAX | BHM | WN | WN | 5 | 383 | 1815 | 4 | |
332 | LAX | CLE | CO | CO | 1 | 126 | 2053 | 5 | |
333 | LAX | CLT | UA | UA | 1 | 104 | 2344 | 5 | |
485 | ORD | CHS | DL | DL | 2 | 179 | 865 | 2 | |
335 | LAX | DEN | F9 | F9 | 11 | 778 | 862 | 2 | |
336 | LAX | DTW | NW | NW | 3 | 290 | 1979 | 4 | |
337 | LAX | EWR | AA | AA | 1 | 205 | -9999 | 5 | |
338 | LAX | EWR | UA | UA | 1 | 327 | 2454 | 5 | |
715 | TYS | GSO | DL | DL | 1 | 178 | 458 | 1 | |
340 | LAX | GEG | AS | AS | 1 | 128 | 945 | 2 | |
341 | LAX | HOU | WN | WN | 1 | 106 | 1390 | 3 | |
342 | LAX | MCO | WN | WN | 1 | 278 | 2435 | 5 | |
343 | LAX | ORD | AA | AA | 1 | 302 | 1745 | 4 | |
344 | LAX | ORD | UA | UA | 1 | 461 | 1745 | 4 | |
345 | LAX | ORD | UA | UA | 1 | 207 | 1745 | 4 | |
346 | LAX | PDX | AS | AS | 1 | 0 | 834 | 2 | |
347 | LAX | PHL | UA | UA | 1 | 1315 | 2401 | 5 | |
348 | LAX | PHL | US | US | 10 | 1595 | 2401 | 5 | |
349 | LAX | SAT | WN | WN | 1 | 98 | 1210 | 3 | |
27 | ATL | MDW | DL | EV | 2 | 177 | 590 | 2 | |
351 | LAX | SFO | UA | UA | 1 | 453 | 337 | 1 | |
358 | LGA | ATL | DL | DL | 1 | 175 | 761 | 2 | |
353 | LAX | STL | AA | AA | 1 | 113 | 1593 | 4 | |
354 | LAX | SUN | AA | QX | 1 | 257 | 696 | 2 | |
355 | LBB | SAT | WN | WN | 1 | 149 | 541 | 2 | |
231 | FLL | LAS | DL | DL | 1 | 173 | 2174 | 5 | |
288 | IND | SRQ | DL | DL | 3 | 172 | 877 | 2 | |
40 | AUS | IAD | DL | DL | 1 | 172 | 1346 | 3 | |
359 | LGA | CMH | AA | MQ | 1 | 114 | 478 | 1 | |
35 | ATL | VPS | DL | EV | 1 | 172 | 264 | 1 | |
361 | LGA | DTW | NW | NW | 3 | 490 | 501 | 2 | |
362 | LGA | GEG | UA | UA | 1 | 201 | 2231 | 5 | |
363 | LGA | JAX | US | US | 5 | 279 | 848 | 2 | |
364 | LGA | MCO | FL | FL | 1 | 234 | 1164 | 3 | |
365 | LGA | MIA | AA | AA | 1 | 79 | 1097 | 3 | |
366 | LGA | MSP | US | US | 1 | 183 | 1137 | 3 | |
234 | FLL | LGA | DL | OH | 1 | 172 | 1151 | 3 | |
368 | LGA | ORD | AA | AA | 1 | 326 | 733 | 2 | |
18 | ATL | BUF | DL | EV | 2 | 170 | 712 | 2 | |
370 | LGA | TPA | AA | AA | 11 | 1138 | 1011 | 3 | |
371 | LGA | TUS | AA | AA | 1 | 183 | -9999 | 5 | |
372 | LGB | IAD | B6 | B6 | 4 | 367 | 2277 | 5 | |
373 | LGB | SEA | AS | AS | 1 | 185 | 965 | 2 | |
374 | LIH | HNL | AQ | AQ | 3 | 64 | 102 | 1 | |
375 | LIT | ORF | CO | RU | 1 | 439 | 1353 | 3 | |
376 | LNK | RDU | UA | YV | 1 | 272 | 1113 | 3 | |
377 | LSE | DFW | NW | 9E | 1 | 128 | 819 | 2 | |
378 | MBS | MCO | NW | NW | 1 | 154 | 1055 | 3 | |
379 | MCI | ATL | YX | YX | 1 | 108 | 1105 | 3 | |
380 | MCI | FLL | AA | AA | 1 | 130 | 1585 | 4 | |
381 | MCI | HOU | WN | WN | 3 | 313 | 666 | 2 | |
382 | MCI | MDW | WN | WN | 82 | 2398 | 405 | 1 | |
383 | MCI | ORD | AA | AA | 1 | 229 | 403 | 1 | |
384 | MCI | ORD | UA | UA | 1 | 91 | 403 | 1 | |
385 | MCI | PHL | US | ZW | 9 | 709 | 1038 | 3 | |
386 | MCI | PHL | WN | WN | 1 | 113 | 1038 | 3 | |
387 | MCO | BOS | B6 | B6 | 66 | 2871 | 1121 | 3 | |
388 | MCO | CLE | CO | CO | 1 | 148 | 895 | 2 | |
389 | MCO | DAY | FL | FL | 1 | 111 | 1193 | 3 | |
390 | MCO | DEN | F9 | F9 | 20 | 1565 | 1545 | 4 | |
391 | MCO | FLL | NK | NK | 2 | 43 | 178 | 1 | |
392 | MCO | GRR | NW | NW | 1 | 239 | 1718 | 4 | |
281 | IND | ATL | DL | EV | 1 | 170 | 432 | 1 | |
394 | MCO | IAD | UA | UA | 1 | 86 | 758 | 2 | |
395 | MCO | ISP | WN | WN | 1 | 195 | 972 | 2 | |
223 | FLL | BDL | DL | DL | 2 | 169 | 1173 | 3 | |
356 | LEX | RSW | DL | OH | 1 | 165 | 949 | 2 | |
398 | MCO | LAX | HP | HP | 1 | 186 | 2218 | 5 | |
399 | MCO | LAX | UA | UA | 2 | 52 | 2217 | 5 | |
400 | MCO | ORF | WN | WN | 8 | 390 | 655 | 2 | |
401 | MCO | PHL | US | US | 1 | 162 | 861 | 2 | |
402 | MCO | PVD | WN | WN | 1 | 275 | 1115 | 3 | |
403 | MCO | RDU | FL | FL | 1 | 334 | 759 | 2 | |
404 | MCO | SYR | B6 | B6 | 4 | 269 | 1153 | 3 | |
405 | MCO | SYR | US | US | 1 | 157 | 1071 | 3 | |
406 | MDW | CMH | WN | WN | 3 | 119 | 284 | 1 | |
407 | MDW | FLL | WN | WN | 1 | 246 | 1188 | 3 | |
408 | MDW | JAN | WN | WN | 1 | 88 | 666 | 2 | |
409 | MDW | PBI | AA | AA | 1 | 130 | 1900 | 4 | |
410 | MDW | RSW | FL | FL | 2 | 90 | 1105 | 3 | |
411 | MDW | RSW | TZ | TZ | 3 | 157 | 1105 | 3 | |
412 | MDW | SMF | WN | WN | 1 | 264 | 2208 | 5 | |
310 | LAN | JAX | DL | OH | 1 | 162 | 872 | 2 | |
414 | MEM | DTW | NW | NW | 1 | 321 | 610 | 2 | |
415 | MEM | MCO | NW | NW | 1 | 94 | 683 | 2 | |
416 | MEM | ORD | NW | NW | 2 | 221 | 491 | 1 | |
669 | SLC | PDX | DL | DL | 1 | 157 | 630 | 2 | |
418 | MEM | TPA | NW | NW | 1 | 320 | 656 | 2 | |
419 | MHT | CLT | US | 16 | 1 | 628 | 737 | 2 | |
420 | MHT | MCO | WN | WN | 1 | 142 | 1142 | 3 | |
421 | MHT | SAT | UA | UA | 1 | 288 | 1884 | 4 | |
422 | MHT | SRQ | CO | CO | 1 | 201 | 1243 | 3 | |
423 | MIA | BOS | AA | AA | 1 | 491 | 1258 | 3 | |
424 | MIA | BWI | US | US | 2 | 274 | 1010 | 3 | |
425 | MIA | CLT | US | US | 6 | 912 | 650 | 2 | |
426 | MIA | DFW | AA | AA | 2 | 193 | 1121 | 3 | |
427 | MIA | JFK | AA | AA | 1 | 163 | 1090 | 3 | |
428 | MIA | JFK | AY | AA | 1 | 1043 | 1090 | 3 | |
429 | MIA | LAX | AA | AA | 1 | 150 | -9999 | 5 | |
430 | MIA | LGA | AA | AA | 3 | 182 | 1097 | 3 | |
431 | MIA | MSP | NW | NW | 1 | 218 | 1501 | 4 | |
432 | MIA | ONT | HP | HP | 1 | 449 | 2372 | 5 | |
433 | MIA | ORD | AA | AA | 2 | 220 | 1347 | 3 | |
434 | MKE | BOI | NW | NW | 1 | 255 | 1439 | 3 | |
435 | MKE | IND | YX | AL | 1 | 169 | 238 | 1 | |
436 | MKE | MSY | FL | FL | 1 | 134 | 1094 | 3 | |
437 | MKE | ORD | UA | YV | 1 | 129 | 67 | 1 | |
438 | MSN | DEN | UA | OO | 4 | 692 | 826 | 2 | |
439 | MSN | TPA | NW | NW | 1 | 128 | 1295 | 3 | |
440 | MSP | ABQ | NW | NW | 2 | 0 | 981 | 2 | |
441 | MSP | ALB | CO | RU | 1 | 246 | 1046 | 3 | |
442 | MSP | BDL | NW | NW | 3 | 206 | 1050 | 3 | |
443 | MSP | BOS | NW | NW | 1 | 331 | 1124 | 3 | |
444 | MSP | BUR | AA | AA | 1 | 0 | -9999 | 5 | |
445 | MSP | CLT | US | YV | 1 | 189 | 930 | 2 | |
446 | MSP | DCA | NW | NW | 1 | 129 | 931 | 2 | |
447 | MSP | DCA | UA | UA | 1 | 139 | 931 | 2 | |
448 | MSP | EWR | YX | YX | 5 | 324 | 1022 | 3 | |
449 | MSP | IFP | SY | SY | 3 | 394 | 1310 | 3 | |
450 | MSP | JFK | NW | NW | 1 | 144 | 1028 | 3 | |
451 | MSP | JFK | NW | NW | 1 | 112 | 1028 | 3 | |
452 | MSP | MCI | NW | XJ | 1 | 154 | 393 | 1 | |
453 | MSP | MCO | FL | FL | 3 | 152 | 1310 | 3 | |
454 | MSP | PDX | NW | NW | 1 | 241 | 1426 | 3 | |
455 | MSP | PHX | SY | SY | 1 | 147 | 1276 | 3 | |
456 | MSP | RNO | F9 | F9 | 1 | 154 | 1484 | 3 | |
457 | MSY | AUS | CO | RU | 1 | 115 | 445 | 1 | |
458 | MSY | AUS | WN | WN | 1 | 142 | 451 | 1 | |
459 | MSY | BUR | AA | AA | 1 | 152 | 1679 | 4 | |
233 | FLL | LGA | DL | DL | 1 | 155 | 1076 | 3 | |
461 | MSY | SAN | CO | CO | 1 | 361 | 1608 | 4 | |
462 | MSY | STL | AA | RP | 1 | 246 | 604 | 2 | |
463 | MTJ | IAH | CO | RU | 1 | 139 | 926 | 2 | |
464 | MTJ | LAS | UA | UA | 1 | 146 | 826 | 2 | |
465 | OAK | IAD | HP | HP | 1 | 189 | 2408 | 5 | |
466 | OAK | MDW | WN | WN | 24 | 1343 | 1844 | 4 | |
467 | OKC | BNA | AA | AA | 1 | 143 | 806 | 2 | |
468 | OKC | MCI | WN | WN | 2 | 135 | 313 | 1 | |
469 | OKC | ONT | WN | WN | 1 | 212 | 1158 | 3 | |
470 | OKC | TPA | AA | AA | 1 | 140 | 1104 | 3 | |
471 | OMA | DTW | NW | XJ | 1 | 39 | 651 | 2 | |
472 | OMA | IND | WN | WN | 1 | 144 | 585 | 2 | |
473 | OMA | LGA | NW | NW | 3 | 183 | 1302 | 3 | |
31 | ATL | RDU | DL | EV | 1 | 152 | 356 | 1 | |
475 | ONT | BWI | WN | WN | 3 | 237 | 2303 | 5 | |
476 | ONT | DCA | AA | AA | 1 | 236 | 2381 | 5 | |
477 | ONT | EWR | HP | HP | 1 | 149 | 2458 | 5 | |
478 | ONT | OKC | UA | UA | 1 | 449 | 1314 | 3 | |
479 | ONT | RDM | AS | QX | 1 | 158 | 954 | 2 | |
480 | ONT | SEA | AS | AS | 1 | 39 | 956 | 2 | |
481 | ORD | AUS | AA | AA | 1 | 81 | 978 | 2 | |
482 | ORD | BNA | AA | MQ | 1 | 80 | 409 | 1 | |
483 | ORD | BUF | UA | UA | 1 | 63 | 473 | 1 | |
484 | ORD | BUF | UA | YV | 1 | 235 | 473 | 1 | |
46 | AVL | DFW | DL | RU | 1 | 152 | 1058 | 3 | |
486 | ORD | DFW | AA | AA | 1 | 187 | 802 | 2 | |
487 | ORD | DSM | AA | MQ | 1 | 321 | 299 | 1 | |
488 | ORD | EWR | UA | UA |