OpenAirDocs.org
Fremont, OH

Registered aircraft · 43

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

N1247CPiper PA-20 · S/N 20-968Built 1953 · Smith Paul JN1632PPiper PA-22 · S/N 22-2446Built 1954 · Willey Larry EN182NACessna 182Q · S/N 18266612Built 1978 · Bishop Trent AlanN21370Cessna 182P · S/N 18261591Built 1972 · Garner Jan LN2145KLuscombe 8A · S/N 4872Nc2145k LLCN228DTAir Tractor AT-602 · S/N 602-1315Built 2021 · Gibbs Aviation IncN2386NPiper PA-38-112 · S/N 38-79A0820Hoelzle Paul RN2447KPiper PA-38-112 · S/N 38-79A0640Built 1979 · Damschroder Rex AN260LAAir Tractor AT-602 · S/N 602-1268Built 2016 · Gibbs Aviation IncN275JAAir Tractor AT-502B · S/N 502B-2755Built 2011 · Gibbs Aviation IncN3012ECessna 172N · S/N 17271402Built 1978 · Damschroder Rex AN3025FCessna 182J · S/N 18257125Built 1966 · Warner Daniel MN327BEAmerican Champion 7GCBC · S/N 1296-2000Built 2000 · Black Swamp Flyers LLCN337RDCessna 337C · S/N 337-0847Built 1968 · Damschroder Rex AN3427WPiper PA-32-260 · S/N 32-313Built 1965 · Hurricane Air LLCN347SHHonsperger Karl J HATZ BANTAM · S/N 015Built 2022 · Honsperger Karl JN3654KPiper PA-28-140 · S/N 28-23673Built 1967 · Beaber Michael JN36577Aeronca 65-CA · S/N C-17101Built 1941 · Cobb Douglas JN3992HErcoupe 415-D · S/N 4693Built 1947 · Haynes Roger MN42875Cessna 182L · S/N 18259228Built 1968 · Bowes Tyler DN4321HPiper PA-15 · S/N 15-103Cobb Douglas JN44478Piper PA-28-180 · S/N 28-7405247Built 1974 · Richard J Farmer IIN455JSShaffer John Thomas KR-2 · S/N 8009Built 1984 · Shaffer John ThomasN4648ECessna 182R · S/N 18268254Built 1982 · Randall John KellyN4777Waco GXE · S/N 1211Built 1928 · Damschroder Alexander RN50471Cessna 150J · S/N 15069327Built 1968 · Honsperger Karl J TrusteeN5386RCessna 172F · S/N 17252921Built 1965 · Vargo Michael DN60HZMoskwa David A VARIEZE · S/N 1389Damschroder Rex AN621SDarrin J Szymanowski M24 ORION · S/N 24202636Built 2020 · Szymanowski Darrin JN714TUCessna 152 · S/N 15279427Built 1977 · Damschroder Rex AN73131Cessna 172M · S/N 17267280Built 1976 · Fremont Flight Academy LLCN7718WPiper PA-28-180 · S/N 28-1724Built 1964 · Clyde Fliers IncN7756PPiper PA-24-250 · S/N 24-2972Built 1962 · 56pop LLCN78582Piper PA-12 · S/N 12-3968Built 1947 · Gibbs Luther AN80536Cessna 172M · S/N 17266643Built 1976 · Fremont Flight Academy LLCN85439Aeronca 7AC · S/N 7AC-4179Built 1946 · Kupka John JN85SADouglas DC3A · S/N 11637Built 1943 · Saving Lulu Belle IncN88398Bellanca 7GCBC · S/N 776-75Built 1974 · 88398 LLCN900EDCessna 182M · S/N 18259731Built 1969 · Spradling JamesN9107BCessna 172 · S/N 36607Grace Community ChurchN964ACCessna 206H · S/N 20608073Built 1999 · 63 Victor LLCN9699HCessna 337A · S/N 337-0395Damschroder Rex AN975SFAir Tractor AT-502A · S/N 502A-3139Built 2018 · Gibbs Aviation Inc
Back to Fremont, OH