OpenAirDocs.org
Fairfield, OH

Registered aircraft · 39

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

N100MBDassault FALCON 2000EX · S/N 60Built 2005 · Mb Aviation CorpN14052Waco UKC · S/N 3927Built 1934 · Hogan Thomas AN1728JPiper PA-28-140 · S/N 28-24140Hogan Thomas AN1768QCessna 150L · S/N 15073068Built 1971 · Harper John TN2059ECessna 172N · S/N 17271137Built 1978 · H & H Aviation Enterprises LLCN220JACessna 172P · S/N 172-76157Built 1984 · Hogan Field Hangars LLCN24832Miller WM-2 · S/N 002Built 1972 · Morris Timothy JN25SKCessna 172N · S/N 17273152Built 1979 · H & H Aviation Enteprises LLCN2819ZBellanca 7ECA · S/N 1236-78Hogan Thomas AN2951KLuscombe 8E · S/N 5678Jacobs John HenryN299ACessna 320B · S/N 320B-0057Built 1964 · Overman Robert WN3080BBeech F33A · S/N CE-1096Built 1986 · Lamermayer Amy EN30AVCessna 550 · S/N 550-0026Extraordinaire Aviation LLCN31116Waco UPF-7 · S/N 5735Hogan Thomas AN32472Waco UPF-7 · S/N 5782Built 1947 · Hogan Thomas AN325KWright Jesse M KIS · S/N 102Built 2009 · Morris Timothy JN3340BPiper PA-22-135 · S/N 22-2155Hao Hangar Rats LLCN34783Culver LFA · S/N 239Built 1941 · M3x Hangar Rats LLCN39700Waco UPF-7 · S/N 5832Built 1942 · Hogan Thomas AN411JVGregory P Bricking BEARHAWK · S/N 411Hogan Thomas AN41705Culver LFA · S/N 398Built 1942 · Mx3 Hangar Rats LLCN4315TPiper PA-32-260 · S/N 32-7200016Built 1971 · Community Health AllianceN45AGCessna 172P · S/N 17275652Hogan Thomas AN492MVMorris Timothy J AVID FLYER · S/N 1492DBuilt 1996 · Morris Timothy JN5118Waco GXE · S/N 1219Hogan Thomas AN6252DCessna 172N · S/N 17272667Built 1979 · H & H Aviation Enterprises LLCN6337HPiper J3C-65 · S/N 19517Built 1946 · Hogan Thomas AN6349JCessna 172N · S/N 17273866Built 1980 · H & H Aviation Enterprises LLCN6507Waco 10 · S/N 1598Hogan Thomas AN670DCBeech 35-A33 · S/N CD-343Hogan Thomas AN67527Cessna 152 · S/N 15281892Built 1978 · H & H Aviation Enterprises LLCN737AACessna 172N · S/N 17269258Built 1977 · Hogan Thomas AN737KCCessna 172N · S/N 17269468Built 1977 · H & H Aviation Enterprises LLCN763EWaco ASO · S/N A-114Built 1929 · Hogan Thomas AN767EWaco ATO · S/N A-124Built 1929 · Hogan Thomas AN823CALearjet 45 · S/N 221Extraordinaire Aviation II LLCN8538XWaco DSO · S/N 3002Hogan Thomas AN93154Cessna 152 · S/N 15285422Built 1981 · H & H Aviation Enterprises LLCN9438ACessna 140A · S/N 15259Built 1949 · Corder Charles W
Back to Fairfield, OH