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 the destination cities?
new york jfk, tampa, washington national, atlanta, dayton, orlando, akron-canton, chicago o'hare, cleveland, las vegas, columbus, flint, dallas/fort worth, cincinnati, atlanta, cincinnati, beaver falls (pa), detroit city, youngstown, akron, chicago, cleveland, detroit, flint, grand rapids, chicago midway, south bend, deroit, fort wayne, atlanta, cincinnati, columbus, indianapolis, cleveland, atlanta, cincinnati, dayton, detroit, fort wayne, columbus, denver, detroit, chicago midway & o'hare, chicago midway, detroit, youngstown, dayton, las vegas, sanford/orlando, columbus, dayton, detroit metro, lima, st. louis, chicago o'hare, cleveland, denver, fort wayne, peori, pittsburgh, dayton, indianapolis, pittsburgh, myrtle beach
Airline Destination(s) Aircraft Scheduled Service Date(s) Comments
what are the destination cities?
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
New York JFK, Tampa, Washington National Atlanta, Dayton, Orlando Akron-Canton, Chicago O'Hare, Cleveland Las Vegas Columbus, Flint Dallas/Fort Worth Cincinnati Atlanta, Cincinnati Beaver Falls (PA), Detroit City, Youngstown Akron, Chicago, Cleveland, Detroit, Flint, Grand Rapids Chicago Midway, South Bend Deroit, Fort Wayne Atlanta, Cincinnati, Columbus, Indianapolis Cleveland Atlanta, Cincinnati, Dayton, Detroit, Fort Wayne Columbus Denver, Detroit Chicago Midway & O'Hare Chicago Midway Detroit, Youngstown Dayton Las Vegas, Sanford/Orlando Columbus, Dayton, Detroit Metro, Lima St. Louis Chicago O'Hare, Cleveland, Denver, Fort Wayne, Peori Pittsburgh Dayton, Indianapolis, Pittsburgh Myrtle Beach
what are the destination cities? || 