OpenAirDocs.org
London, OH

Registered aircraft · 31

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

N107AWBellanca 8KCAB · S/N 474-79Built 1978 · Dust Donald EN127RLCessna 182P · S/N 18262910Skylane Of Ohio LLCN1432KCessna 177RG · S/N 177RG0665Built 1975 · Covenant Physician Services LtdN15DGHannaford Bee D-1 · S/N 1-GFBoggs Ricky LN21250Taylorcraft BF · S/N 1043Boggs Ricky LN219AGDJI AGRAS T50 · S/N 1581F6BUB249T0017C64Krebs CalebN230AGDJI AGRAS T50 · S/N 1581F6BUB249F0019425Krebs CalebN23869Taylorcraft BL-65 · S/N 1505Built 1939 · Boggs Ricky LN26802Piper J4A · S/N 4-909Powers Harry R IIN28986Gulfstream American AA-5B · S/N AA5B0922Built 1978 · Recreation Plus IncN2950FCessna 182J · S/N 18257050Built 1966 · Spring Ronald LN371EADJI AGRAS T40 · S/N 64TBKB800200A7Elevation Ag LLCN372EADJI AGRAS T40 · S/N 64TBKB80020080Elevation Ag LLCN377VRVashon RANGER R7 · S/N 10233Built 2024 · Blaho JosephN4135VJames D P JAMES-POBER PIXIE · S/N DPJ-2Built 1996 · Dellinger Lyman DN447HCDJI AGRAS T50 · S/N 1581F6BUB246J0014BS7Cromer Justin WilliamN45RDDJI AGRAS T40 · S/N 64TBK8U00100CER D Snyder Farms IncN5457RCessna 172F · S/N 17253013Built 1965 · Farrand David VN549RTGteex Revolution INDEPENDENCE 19 · S/N 212985300C6C4Registration pendingN6170HPiper J3C-65 · S/N 19339Built 1946 · Eakins Christian LN627ABCirrus Design SR20 · S/N 10712Built 2025 · Yost Aviation LLCN6667HPiper J3C-65 · S/N 19872Built 1946 · Tyson Stephen BruceN7105ACessna 172 · S/N 29205Dunkley Judith AN729EADJI AGRAS T40 · S/N 5X5BLMP0030JLEElevation Ag LLCN75FHFrancis H Smith VANS RV-7 · S/N 005Built 2009 · Dust DonaldN8437SCessna 182H · S/N 18256537Built 1965 · F & S FarmsN8615GBuckeye DREAM MACHINE · S/N 3602Built 1997 · Yoder David LN9175JPiper PA-28-180 · S/N 28-3241Built 1966 · Sommer Eric MN95074Taylorcraft BC12-D · S/N 9474Built 1946 · Boggs Ronald LN9566RDJI AGRAS T40 · S/N 1581F574B2396001GJR D Snyder Farms IncN96834Taylorcraft BC12-D · S/N 9134Built 1946 · Spring Ronald L
Back to London, OH