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

N1006WMooney M20J · S/N 24-1069Built 1980 · Fadem Justin Andrew N10357Schweizer SGU 2-22CK · S/N 85Built 1960 · Niagara Soaring Club N142JHDeloach Harry RV-10 · S/N 40454Built 2008 · Paroaria LLC N2390YAeronca 7BCM · S/N 7BCM-477Strong James R N2441WSchweizer SGS 2-33 · S/N 9Built 1967 · Niagara Soaring Club Inc N300WZRobinson Helicopter R44 II · S/N 11622Built 2007 · Nicholas Christopher N41927Piper PA-28-151 · S/N 28-7415360Built 1974 · Budziejko David C N4549RPiper PA-28-140 · S/N 28-21255Built 1965 · Hamburg Airport 1 LLC N4KCSchweizer SGS 1-26C · S/N 295Built 1965 · Niagara Soaring Club N520CTCirrus Design SR22T · S/N 0924Built 2014 · 85 Galileo Aviation LLC N815BLuscombe 8F · S/N 6745Built 1950 · Strong James R N8510HNorth American NAVION · S/N NAV-4-510Built 1947 · Wobschall Eric D DBA Buffalo Skyline N8548LPiper PA-25-235 · S/N 25-4968Built 1969 · Niagara Soaring Club Inc N8677RSchweizer SGS 1-26B · S/N 211Built 1963 · Niagara Soaring Club Inc N9109ZPiper PA-28-236 · S/N 2811002Built 1986 · O'Neill Erik M N9617CPiper PA-32RT-300 · S/N 32R-7885060Built 1978 · Pete And Pete Sales Inc N99LBPiper PA-24 · S/N 24-2265Built 1960 · Volz Laura M Trustee

Back to Williamsville, NY