OpenAirDocs.org
Columbus, OH

Registered aircraft · 279

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 = 'COLUMBUS'
  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.

N100SUTextron 172S · S/N 172S11739Ohio State UniversityN100WNGates Learjet 25D · S/N 288Built 1979 · Columbus State Community CollegeN103HCMitsubishi MU-300 · S/N A068 S.A.Estar Aerospace CorpN10FUMoyer Dallas E DYKE DELTA JD2 · S/N 1271Moyer Dallas EN1134FCessna 172G · S/N 17254729Built 1966 · Scialabba John EN113HPCessna 182T · S/N 18281159Built 2002 · State Of OhioN11786Cessna 150L · S/N 15075631Built 1974 · Barbee Donald LN120AJEurocopter EC120B · S/N 1642Built 2010 · Bydesign777 LLCN1220ZPiper PA-24 · S/N 24-800Built 1959 · Columbus State Community CollegeN122WETextron 172S · S/N 172S12396Built 2019 · Ohio State UniversityN123BJWhitanack James SONERAI II L · S/N 1054Sale reportedBuilt 1984N123MGMaule M-7-420AC · S/N 29003CBuilt 2001 · Hagedorn Aviation IncN1253WHawker Beechcraft B300 · S/N FL-790Built 2012 · Worthington Enterprises IncN125WETextron 172S · S/N 172S12303Built 2019 · Ohio State UniversityN1265QCessna 150L · S/N 15072565Built 1971 · Dumankskii Aviation LLCN12865Cessna 172M · S/N 17262324Built 1973 · Flyright Aviation LLCN12BCCessna 182P · S/N 18261895Built 1973 · Central Ohio Flyers AssnN12HPCessna 182T · S/N 18281158Built 2002 · State Of OhioN12PWCessna 210L · S/N 21059796Built 1972 · Ohio State University College Of EngineeringN130BUEurocopter EC 130 B4 · S/N 7132Built 2011 · Ohio Medical Transportation IncN130CLEurocopter EC 130 B4 · S/N 7499Built 2012 · Ohio Medical Transportation IncN130HBEurocopter EC 130 B4 · S/N 7167Built 2011 · Ohio Medical Transportation IncN130JVEurocopter EC 130 B4 · S/N 7490Built 2012 · Ohio Medical Transportation IncN130KHEurocopter EC 130 B4 · S/N 7142Built 2011 · Ohio Medical Transportation IncN130MUEurocopter EC 130 B4 · S/N 7103Built 2011 · Ohio Medical Transportation IncN130NWEurocopter EC 130 B4 · S/N 7182Built 2011 · Ohio Medical Transportation IncN13524Cessna 172M · S/N 17262820Built 1973 · Loomis Avaition LLCN135MGGrumman G-44 · S/N 1389Built 1944 · Old Crow LLCN140SUCessna 172S · S/N 172S11563Built 2015 · Ohio State UniversityN145NCEurocopter Deutschland MBB-BK 117 C-2 · S/N 9542Built 2012 · Pediatric Rotor Wing LLCN147CGBell 47G · S/N 1044Built 1956 · Magic Carpet Ride Aviation LLCN149WTDiamond Aircraft Ind DA 42 · S/N 42.AC046Built 2007 · Vectors To Final LLCN150SUCessna 172S · S/N 172S11565Built 2015 · Ohio State UniversityN15624Piper PA-28-235 · S/N 28-7310061Built 1972 · Ultimax IncN168DJCirrus Design SR20 · S/N 9347Built 2023 · Warren Patrick SN1791VCessna 172M · S/N 17263752Built 1974 · Omargows AliN17HPCessna 182T · S/N 18281436Built 2004 · State Of Ohio Dept Of Public SafetyN17SWBeech D17S · S/N 4850Built 1955 · Head IncN180SUTextron 172S · S/N 172S12161Built 2018 · Ohio State UniversityN18BRPiper PA-32-260 · S/N 32-371Built 1966 · Fly Ohio IncN18HPCessna 182T · S/N 18281071Built 2001 · State Of OhioN19644Cessna 172L · S/N 17260632Hyde Shawn MN19HPCessna 182T · S/N 18281266Built 2003 · State Of Ohio Dept Of Public SafetyN1MGTextron 525C · S/N 525C-0246Built 2017 · Hagedorn Aviation IncN200CHDassault FALCON 2000EX · S/N 319Built 2015 · Allegiance I LLCN201BWMooney M20J · S/N 24-0431Built 1978 · Hatton David TrusteeN20542Cessna 172M · S/N 17261379Built 1973 · Roberge Patrick RN2075RPiper PA-28-180 · S/N 28-5454Built 1969 · Buchart Cole ScottN20SUTextron 172S · S/N 172S11623Built 2015 · Ohio State UniversityN210GSCessna 210L · S/N 21061283Built 1976 · Retail Online Solutions Inc
Back to Columbus, OH