Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

STAT 2

Authors: Robert R Johnson, Patricia J Kuby

2nd Edition

1133169953, 9781133169956

More Books

Students also viewed these Mathematics questions


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