Registered aircraft · 21

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 = 'SD' AND g.registrant_city = 'BUFFALO' 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 = 'SD' AND g.registrant_city = 'BUFFALO'
  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 = 'SD' AND g.registrant_city = 'BUFFALO'
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.

N1660PPiper PA-18-150 · S/N 18-3782Built 1954 · Janvrin Jerry M N1712DCessna 170A · S/N 20155Built 1951 · Richter Ty G N175CBCessna 175 · S/N 56147Built 1959 · Pr Aeronautics LLC N1857PPiper PA-18-135 · S/N 18-4124Built 1955 · Janvrin Jerry M N2264UBrantly B-2B · S/N 426Janvrin Jerry M N2438GCessna 182B · S/N 51738Built 1959 · Wk Aviation LLC N3879ZPiper PA-18-150 · S/N 18-7677Built 1961 · Nelson Chad A N4247ZPiper PA-18-150 · S/N 18-8476Built 1966 · Janvrin Jerry M N4359ZPiper PA-18-150 · S/N 18-8677Built 1968 · Britton Kelly D N4627MPiper PA-11 · S/N 11-131Built 1947 · Nelson Larry J N7236SCessna 150H · S/N 15067936Built 1967 · Janvrin Jerry M N7313YPiper PA-30 · S/N 30-356Built 1964 · Pr Aeronautics LLC N8082CPiper PA-18-135 · S/N 18-3486Built 1954 · Gilbert Ray E N8272DBeech J35 · S/N D-5370Built 1957 · Henderson Will N87888Piper J3C-65 · S/N 15506Built 1946 · Janvrin Jerry M N8789CPiper PA-18-135 · S/N 18-2885Built 1953 · Painter Joe S N884WHHunnicutt W H HOBO · S/N 001Pr Aeronautics LLC N9032LChampion 7GCBC · S/N 259-70Built 1970 · Johnson Robert W N9507PPiper PA-24-260 · S/N 24-5024Built 1972 · W K Aviation LLC N96277Taylorcraft BC12-D · S/N 8577Built 1946 · Stenerson Trae L N98033Piper J3C-65 · S/N 18179Built 1946 · Painter Joe S

Back to Buffalo, SD