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

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

N11CYGrumman American Avn. AA-1C · S/N AA1C-0011Odonnell Justin M N1531ZBeech 95-A55 · S/N TC-205Built 1961 · Shenandoah Whalen N200EHEnstrom F-28A · S/N 200Built 1974 · D & M Aviation Inc N247JHLearjet 45 · S/N 344Built 2007 · Wair Next LLC N253DCEnstrom 280FX · S/N 2053D & M Aviation Inc N2620CRobinson Helicopter R22 BETA · S/N 0725Built 1987 · Whalen Shenandoah N2TBRepublic RC-3 · S/N 819Built 1947 · Whalen Shenandoah N3925TPiper PA-28R-180 · S/N 28R-30263Built 1967 · Elevation Air LLC N4225HHaley Bernard H H-2-E · S/N H01EHaley Bernard H N4225JHaley Bernard H H-1 E · S/N H01EHaley Bernard H N48752Ryan Aeronautical ST3KR · S/N 1427Built 1941 · Durkee Michael S N4933LPiper PA-28-180 · S/N 28-4301Southall Charles B N51122Ryan Aeronautical ST3KR · S/N 2204Built 1942 · Durkee Michael S N56UEnstrom F-28A · S/N 139D&M Aviation Inc N6158DDirr Donald W CHALLENGER II · S/N CH2-0294-1089Built 1994 · Haley Bernard H N74533Mooney M20B · S/N 1844Built 1961 · Whalen Shenandoah N754MHEnstrom 280 · S/N 1024D&M Aviation Inc N8583MBeech 35-B33 · S/N CD-652Whalen Shenandoah N87564Republic RC-3 · S/N 126Built 1946 · Whalen Shenandoah N9818RBeech M35 · S/N D-6323Built 1960 · Durkee Michael S

Back to Amelia, OH