OpenAirDocs.org
Napoleon, OH

Registered aircraft · 20

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

N1446YCessna 172C · S/N 17249146Built 1962 · Wise RonN2217EPiper PA-32RT-300 · S/N 32R-7985039Built 1978 · Baughman ThomasN23513Aeronca 65-C · S/N C-4619Built 1939 · Birkhold Craig AN243FBDJI AGRAS T40 · S/N 64TBK8L00100KPVertical Ag LLCN248ARDJI AGRAS T40 · S/N 1581F574B234U00100PSRobo Ag Drones IncN261XADJI AGRAS T40 · S/N 1581F574B228A00100N1Vertical Ag LLCN3053FCessna 182J · S/N 18257153Built 1966 · Birkhold Craig AlanN31193Piper J4 · S/N 4-1279Built 1940 · Birkhold Craig AN3305WPiper PA-32-260 · S/N 32-141Salisch JurgenN37996Piper J4E · S/N 4-1489Built 1941 · Birkhold Craig AN549DJDJI AGRAS T40 · S/N 52LBK6M00101CHVertical Ag LLCN5599CCessna 170A · S/N 19653Built 1950 · Benien Dennis AN5852RCessna 172G · S/N 17253521Built 1965 · Benien Dennis AN638TDBeech A45 · S/N G-286Built 1953 · Mentair IncN773NNaval Aircraft Factory N3N-3 · S/N 2865Built 1941 · Behnfeldt Barry WN785JFDJI AGRAS T100 · S/N 1581F8ZLC258Q0028SZ4Robo Ag Drones IncN81716Aeronca 7AC · S/N 7AC-335Built 1945 · Benien Dennis AN8313TPiper PA-32R-301 · S/N 32R-8113026Built 1980 · Behnfeldt Barry WN9504SDJI AGRAS T40 · S/N 64TBK780010059Vertical Ag LLCN9711EAeronca 11AC · S/N 11AC-1281Built 1946 · Benien Dennis A
Back to Napoleon, OH