OpenAirDocs.org
Covington, OH

Registered aircraft · 22

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

N107XXHamblen Travis RV-7A · S/N 71879Built 2007 · Covington Holdings IncN27945Piper J3C-65 · S/N 4466Built 1940 · Kemp Jerry LN3402AHylio AG-130 · S/N 1787F04BM24010011435Apple Farm Service IncN377EHHylio HYL-150 · S/N 17906110270Apple Farm Service IncN377WHHylio HYL-150 · S/N 17906110278Apple Farm Service IncN378YHHylio HYL-150 · S/N 17906110284Apple Farm Service IncN378ZHHylio HYL-150 · S/N 17906110281Apple Farm Service IncN379FHHylio HYL-150 · S/N 17906110285Apple Farm Service IncN379UHHylio HYL-150 · S/N 17906110279Apple Farm Service IncN379YHHylio HYL-150 · S/N 17906110282Apple Farm Service IncN3806HHylio HYL-150 · S/N 17906110276Apple Farm Service IncN380DHHylio HYL-150 · S/N 17906110277Apple Farm Service IncN380PHHylio HYL-150 · S/N 17906110286Apple Farm Service IncN3810HHylio HYL-150 · S/N 17906110274Sale reported, canceledN381FHHylio HYL-150 · S/N 17906110275Sale reported, canceledN3820HHylio HYL-150 · S/N 17906110283Apple Farm Service IncN382DHHylio HYL-150 · S/N 17906110287Sale reported, canceledN386QHHylio HYL-150 · S/N 17906110280Apple Farm Service IncN40726Piper PA-28-235 · S/N 28-7410047Built 1973 · Miller Mark AN441MCessna 441 · S/N 441-0122Built 1979 · Covington Holdings IncN7291GCessna 172K · S/N 17258991Built 1970 · Kuntz Jeffrey AN876NWPowrachute AIRWOLF 912ULS · S/N A397ULSBuilt 2022 · Weldy Nicholas B
Back to Covington, OH