Registered aircraft · 17

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 = 'NY' AND g.registrant_city = 'PLATTSBURGH' 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 = 'NY' AND g.registrant_city = 'PLATTSBURGH'
  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 = 'NY' AND g.registrant_city = 'PLATTSBURGH'
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.

N1722JPiper PA-28-140 · S/N 28-24134Built 1968 · Donah Thomas J N23553Beech B-60 · S/N P-453Built 1977 · Uandmycar.Com Inc N23CVLodwick Charles V CHRISTEN EAGLE II · S/N LODWICK-0001Kiroy Bradley R N23KNEvolution Aero LANCAIR EVOLUTION · S/N EVO-0041Built 2012 · Church Oil Co Inc N2460FCessna 180H · S/N 18051662Built 1966 · Read Colin L N322LSAeroprakt Manufacturing SP Zoo A22LS · S/N 246Built 2015 · Hanley Gary L N36481Taylorcraft BF12-65 · S/N 3303Built 1941 · Barker Geoffrey B N452AFJohnson Richard H SPIRIT · S/N SPIRIT XL2342Built 2005 · Johnson Richard H N531CCCirrus Design SR22 · S/N 3681Built 2010 · N Wilson Holdings LLC N555CBCirrus Design SR22 · S/N 3729Built 2011 · Enyedi Alexander Joseph N66226Cessna 180K · S/N 18052928St Cyr Shane N758EMCessna R172K · S/N R1723037Built 1978 · Kiroy Bradley R N801TPFaulkner Thomas A ZENITH CH 801 · S/N 4827Read Colin L N81507Aeronca 7AC · S/N 7AC-125Built 1945 · Kiroy Bradley R N89809Cessna 120 · S/N 8858St Cyr Shane R N9852TCessna 172A · S/N 47652Built 1960 · Read Colin L N9908CSilvaire 8F · S/N S-11Built 1959 · Barker Geoffrey B

Back to Plattsburgh, NY