Registered aircraft · 25

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'CENTERVILLE' ORDER BY g.n_number

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

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 = 'CENTERVILLE'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N17750Aeronca K · S/N K-16Built 1937 · Bednarek Janet R N183VCirrus Design SR22 · S/N 3125Built 2008 · Griffiths Aero LLC N202SFMonckton/Akrotech G-202 · S/N 007Built 1997 · Crouch Jeremy N244MAPiper PA-32R-301 · S/N 3246218Dc Air LLC N2588NCessna 140 · S/N 12848Built 1947 · Schweller James O N2600Cirrus Design SR22 · S/N 1552Built 2005 · Klasson Human Capital Partners LLC N3829XBeech C23 · S/N M-2306Built 1981 · Ferrari Martin N382FKFrank Kurkowski MERLIN · S/N HV50Built 2025 · Abell Eric E N391MJBednarek Michael H WAGABOND · S/N 1Bednarek Michael H N3986Smith Miniplane DSA-1 · S/N OBT-1Built 1975 · Harter James A N44273Taylorcraft BC12-D1 · S/N 10073Built 1949 · Bednarek Michael H N475KGrumman American Avn. AA-5A · S/N AA5A0667Built 1978 · Kmt Aviation LLC N63RTGlaser Dirks DG 300 · S/N 3E66Zeis Joseph E Jr N65NXMark Swinford RV-7 · S/N 72732Built 2017 · Swinford Mark D N69723Cessna 310Q · S/N 310Q0942Built 1973 · O'Brien John P N7077JFrew John M THORP T-18 · S/N 524Built 2001 · Harter James A N7102WPiper PA-28-180 · S/N 28-889Built 1962 · Hower Nicholas J N7380JPiper PA-28-140 · S/N 28-24742Built 1968 · Bednarek Michael H N77405Cessna 140 · S/N 11846Built 1946 · Roach Daniel J N78040Globe GC-1B · S/N 2040Built 1946 · Bednarek Michael H N8053FCessna 150F · S/N 15064153Built 1966 · Curell Ken E N8575EChampion 7FC · S/N 7FC-363Built 1959 · Freire Roberto F N9063TSchleicher ASW-20 · S/N 20345Built 1980 · Holzwarth Richard C N9503MMooney M20F · S/N 670080Built 1966 · Curell Kenneth E N99936Ercoupe 415-C · S/N 2559Built 1946 · Abell Eric E

Back to Centerville, OH