col : airline | destination(s) | aircraft scheduled | service date(s) | comments row 1 : air florida | new york jfk, tampa, washington national | boeing 737-200, dc-9-10 | jfk: 6/14/79-9/5/79, dc | nan row 2 : airtran airways | atlanta, dayton, orlando | boeing 737-200, dc-9-30, boeing 717-200 | 11/14/1996-2/28/1998, 10/3/2000 | nan row 3 : air wisconsin | akron-canton, chicago o'hare, cleveland | bae 146, bae atp, dash 8-300 | ?-02/03/1993 | original and operating as united express. row 4 : allegiant air* | las vegas | md-80 | 12/15/2005-4/24/2006 | nan row 5 : america west express | columbus, flint | beech 1900 | nan | operated by mesa dba superior airlines row 6 : american eagle airlines* | dallas/fort worth | erj-145 | nan | operated by simmons airlines (now american eagle airlines) and chautau row 7 : atlantic coast airlines | cincinnati | dornier 328jet | nan | dba delta connection row 8 : atlantic southeast airlines | atlanta, cincinnati | atr 72, crj-200, crj-700 | nan | dba delta connection row 9 : beaver aviation / bas airlines | beaver falls (pa), detroit city, youngstown | piper navajo | early 1980s | nan row 10 : capital airlines | akron, chicago, cleveland, detroit, flint, grand rapids | viscount, dc-3, dc-4 | 1/8/1948-05-31-1961 | * merged with united. * at the time, 14 flights at startup row 11 : chicago express airlines | chicago midway, south bend | jetstream 31, saab 340 | 1993-1995, 6/28/2002-1/4/2005 | original and returned as ata connection row 12 : chicago and southern airlines | deroit, fort wayne | nan | nan | merged with delta row 13 : comair | atlanta, cincinnati, columbus, indianapolis | piper chieftain, piper navajo, e | 1979, 01/03/1981-? | original and as delta connection row 14 : continental express | cleveland | emb-120, beech 1900, dash-8-200 | nan | nan row 15 : delta air lines | atlanta, cincinnati, dayton, detroit, fort wayne | convair 440, boeing 727-200, boeing 737 | nan | nan row 16 : eastern airlines | columbus | constellation l-1049g, locheed electra, | nan | nan row 17 : frontier airlines mk 1 | denver, detroit | boeing 737-200, md-80 | nan | nan row 18 : liberty airlines | chicago midway & o'hare | convair 440 | 02/1982-5/16/1983 | plans for cmh, cle, stl, buf, row 19 : midway connection | chicago midway | emb-120, dornier 228 | nan | nan row 20 : mesaba aviation | detroit, youngstown | dash 8-200, fokker 27, metro iii, saa | nan | original and dba northwest airlink row 21 : piedmont airlines | dayton | boeing 727-200, boeing 737-200 | nan | merged with usair row 22 : transmeridian airlines | las vegas, sanford/orlando | boeing 757-200, boeing 727-200, md-80 | nan | filed for bankruptcy row 23 : trans midwest airlines | columbus, dayton, detroit metro, lima | piper navajo | 1983-1985 | nan row 24 : trans world airlines | st. louis | boeing 727-100, dc-9, martin 404 | nan | nan row 25 : united airlines | chicago o'hare, cleveland, denver, fort wayne, peori | dc-8 series 21, boeing 727-122, 727-222, | nan | nan
what are all the scheduled aircraft?
boeing 737-200, dc-9-10, boeing 737-200, dc-9-30, boeing 717-200, bae 146, bae atp, dash 8-300, md-80, beech 1900, erj-145, dornier 328jet, atr 72, crj-200, crj-700, piper navajo, viscount, dc-3, dc-4, jetstream 31, saab 340, , piper chieftain, piper navajo, e, emb-120, beech 1900, dash-8-200, convair 440, boeing 727-200, boeing 737, constellation l-1049g, locheed electra,, boeing 737-200, md-80, convair 440, emb-120, dornier 228, dash 8-200, fokker 27, metro iii, saa, boeing 727-200, boeing 737-200, boeing 757-200, boeing 727-200, md-80, piper navajo, boeing 727-100, dc-9, martin 404, dc-8 series 21, boeing 727-122, 727-222,, convair 580, boeing 727-200, md-80, metro iii, jetstream 31, saab 340, dash 8, boeing 737-400
Airline Destination(s) Aircraft Scheduled Service Date(s) Comments
what are all the scheduled aircraft?
Air Florida New York JFK, Tampa, Washington National Boeing 737-200, DC-9-10 JFK: 6/14/79-9/5/79, DC nan
AirTran Airways Atlanta, Dayton, Orlando Boeing 737-200, DC-9-30, Boeing 717-200 11/14/1996-2/28/1998, 10/3/2000 nan
Air Wisconsin Akron-Canton, Chicago O'Hare, Cleveland BAe 146, BAe ATP, Dash 8-300 ?-02/03/1993 Original and operating as United Express.
Allegiant Air* Las Vegas MD-80 12/15/2005-4/24/2006 nan
America West Express Columbus, Flint Beech 1900 nan Operated by Mesa dba Superior Airlines
American Eagle Airlines* Dallas/Fort Worth ERJ-145 nan Operated by Simmons Airlines (now American Eagle Airlines) and Chautau
Atlantic Coast Airlines Cincinnati Dornier 328JET nan dba Delta Connection
Atlantic Southeast Airlines Atlanta, Cincinnati ATR 72, CRJ-200, CRJ-700 nan dba Delta Connection
Beaver Aviation / BAS Airlines Beaver Falls (PA), Detroit City, Youngstown Piper Navajo Early 1980s nan
Capital Airlines Akron, Chicago, Cleveland, Detroit, Flint, Grand Rapids Viscount, DC-3, DC-4 1/8/1948-05-31-1961 * Merged with United. * At the time, 14 flights at startup
Chicago Express Airlines Chicago Midway, South Bend Jetstream 31, Saab 340 1993-1995, 6/28/2002-1/4/2005 Original and returned as ATA Connection
Chicago and Southern Airlines Deroit, Fort Wayne nan nan Merged with Delta
Comair Atlanta, Cincinnati, Columbus, Indianapolis Piper Chieftain, Piper Navajo, E 1979, 01/03/1981-? Original and as Delta Connection
Continental Express Cleveland EMB-120, Beech 1900, Dash-8-200 nan nan
Delta Air Lines Atlanta, Cincinnati, Dayton, Detroit, Fort Wayne Convair 440, Boeing 727-200, Boeing 737 nan nan
Eastern Airlines Columbus Constellation L-1049G, Locheed Electra, nan nan
Frontier Airlines mk 1 Denver, Detroit Boeing 737-200, MD-80 nan nan
Liberty Airlines Chicago Midway & O'Hare Convair 440 02/1982-5/16/1983 Plans for CMH, CLE, STL, BUF,
Midway Connection Chicago Midway EMB-120, Dornier 228 nan nan
Mesaba Aviation Detroit, Youngstown Dash 8-200, Fokker 27, Metro III, Saa nan Original and dba Northwest Airlink
Piedmont Airlines Dayton Boeing 727-200, Boeing 737-200 nan Merged with USAir
TransMeridian Airlines Las Vegas, Sanford/Orlando Boeing 757-200, Boeing 727-200, MD-80 nan Filed for Bankruptcy
Trans Midwest Airlines Columbus, Dayton, Detroit Metro, Lima Piper Navajo 1983-1985 nan
Trans World Airlines St. Louis Boeing 727-100, DC-9, Martin 404 nan nan
United Airlines Chicago O'Hare, Cleveland, Denver, Fort Wayne, Peori DC-8 series 21, Boeing 727-122, 727-222, nan nan
Boeing 737-200, DC-9-10 Boeing 737-200, DC-9-30, Boeing 717-200 BAe 146, BAe ATP, Dash 8-300 MD-80 Beech 1900 ERJ-145 Dornier 328JET ATR 72, CRJ-200, CRJ-700 Piper Navajo Viscount, DC-3, DC-4 Jetstream 31, Saab 340 Piper Chieftain, Piper Navajo, E EMB-120, Beech 1900, Dash-8-200 Convair 440, Boeing 727-200, Boeing 737 Constellation L-1049G, Locheed Electra, Boeing 737-200, MD-80 Convair 440 EMB-120, Dornier 228 Dash 8-200, Fokker 27, Metro III, Saa Boeing 727-200, Boeing 737-200 Boeing 757-200, Boeing 727-200, MD-80 Piper Navajo Boeing 727-100, DC-9, Martin 404 DC-8 series 21, Boeing 727-122, 727-222, Convair 580, Boeing 727-200, MD-80 Metro III, Jetstream 31, Saab 340, Dash 8 Boeing 737-400
what are all the scheduled aircraft? || 