OpenAirDocs.org
Cincinnati, OH

Registered aircraft · 296

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'OH' AND g.registrant_city = 'CINCINNATI'
  ORDER BY g.n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N100LFTextron 172S · S/N 172S13292Built 2025 · Lunken Flight Training Center LLCN101WFDassault MYSTERE FALCON 900 · S/N 197Built 2003 · Bl Custom Equipment LLCN1027BPiper PA-28-140 · S/N 28-7725246Built 1977 · Marshall LoraineN102JMBeech V35B · S/N D-10216Built 1979 · Held John SN10JKPiper PA-32RT-300T · S/N 32R-7887242Built 1978 · Zalan Aviation LLCN10JZAmerican Champion 7GCAA · S/N 467-2002Built 2002 · Dhz LLCN1107GCessna 172S · S/N 172S10303Built 2006 · Lunken Flight Training Center LLCN110DGGreen Richard T PITTS S-1 · S/N 1Built 1990 · Rawls Thomas RN113UDNewhouse George A VANS RV8 · S/N 80459Built 2002 · Rv8rs Anonymous LLCN114ADCommander 114TC · S/N 20020Built 1998 · Bailey Walter A IIIN118EGTextron T206H · S/N T20609542Built 2018 · Spring Hill Aviation LLCN119YWaco ASO · S/N 3220Built 1930 · Labarre John DN11ETTilton-Pitts S-1S · S/N EJ9-13-23TBuilt 1970 · Geygan Thomas JN11GGBeech M35 · S/N D-6184Built 1959 · Gallagher Aviation LLCN11VVMooney M20R · S/N 29-0010Built 1994 · Schmidt Milton WN11YDSocata TBM 700 · S/N 500Built 2009 · Speed Bird LLCN120GEHonda HA-420 · S/N 42000129Built 2018 · General Electric CoN120HFHonda HA-420 · S/N 42000050Built 2017 · General Electric CoN121TSTextron 525B · S/N 525B0692Built 2023 · Sky King Charters LLCN122ECessna 310Q · S/N 310Q0984Built 1973 · One Two Two Echo Aviation LLCN122RLBeech 95-B55 (T42A) · S/N TC-2177Built 1978 · Jenaero LLCN124BGCessna 525 · S/N 525-0345Built 1999 · Advance Jets LLCN1250VCessna 550 · S/N 550-0439Aquila Air LLCN127PRSchleicher ASW-27 · S/N 27004Cedar Richard DN1280YCessna 150B · S/N 15059680Autumn Crucus LLCN129XBeech V35 · S/N D-8586Built 1967 · Swarts RobertN132WMWilliam S Morris SONEX · S/N 0045Built 2015 · Morris William SN13CAPiper PA-31-350 · S/N 31-7405411Built 1974 · Aeroclub Management LLCN142HCessna 172A · S/N 47245Built 1960 · Bonser Thomas AN145UCEurocopter Deutschland MBB-BK 117 C-2 · S/N 9494Built 2011 · University Of Cincinnati Medical Center LLCN145WCEurocopter Deutschland MBB-BK 117 C-2 · S/N 9535Built 2012 · Uc Health LLCN150GWRaytheon C90A · S/N LJ-1531Built 1998 · Rocinante Air LLCN156RCBombardier CL-600-2B16 · S/N 5446Built 2000 · Warehouse Management IncN15RXCirrus Design SR22 · S/N 1164Built 2004 · Lingo Aviation LLCN160FUAerotek PITTS S-2B · S/N 5021Built 1983 · Extreme Attitude Recovery & Aerobatics LLCN1644NFunk B85C · S/N 424Built 1947 · Nafziger Brian L TrusteeN166SABeech 300 · S/N FA-166Built 1988 · Clear Skies LtdN167FTBombardier BD-100-1A10 · S/N 20559Built 2015 · Fifth Third Bank NaN16LCGrumman American Avn. AA-5B · S/N AA5B0385Built 1976 · Johnson Neil DN172WSCessna 172M · S/N 17261328Built 1973 · Woodstock Air LLCN178KSchleicher ASW-15 · S/N 15062Built 1970 · Lohre Charles RN181BCCirrus Design SR22T · S/N 11143Built 2026 · Blue Chip Aviation Services LLCN182PRCessna 182P · S/N 18261387Built 1972 · Weigle Gerald V Jr TrusteeN183BXLearjet 60 · S/N 285Meyer Tool IncN1890DBeech C35 · S/N D-3173Built 1952 · Brott Edwin TN1945LBeech C23 · S/N M-1821Built 1976 · N1945l LLCN195FCessna 195 · S/N 7493Built 1950 · Aerostream Services LLCN1975FCessna 172N · S/N 17273063Built 1979 · Ward Gary TN1983KLuscombe 8E · S/N 4710Autumn Crucus LLCN1PGGulfstream Aerospace GVI (G650ER) · S/N 6260Built 2017 · Procter & Gamble Leasing LLC
Back to Cincinnati, OH