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 = 'KS' AND g.registrant_city = 'BELOIT' 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 = 'KS' AND g.registrant_city = 'BELOIT'
  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 = 'KS' AND g.registrant_city = 'BELOIT'
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.

N117DECelier XENON RST · S/N CAB 02171SBuilt 2007 · Salguero Joel N12GZCessna 188B · S/N 18801619Built 1974 · Boettcher Aerial Co Inc N225NTTravis W Lattin F-1 · S/N 225Built 2024 · Lattin Travis W N32LDAvia Stroitel AC-4C · S/N 057Built 2001 · Dinkel Danny N424NTCessna 182A · S/N 34555Built 1957 · Lattin Travis N45196Air Tractor AT-402 · S/N 402-0755Boettcher Aerial Inc N502NLAir Tractor AT-502B · S/N 502B-2837Built 2012 · Boettcher Aerial Company Inc N5120VCessna 210L · S/N 21060839Built 1975 · Treaster Implement Co Inc N6081QAir Tractor AT-402B · S/N 402B-1001Built 1996 · Princ Aviation LLC N676DCCessna 182P · S/N 18261020Built 1972 · Princ Aviation LLC N813BWBruce A Wright STOL CH750 · S/N 75-11622Built 2022 · Wright Bruce A N83HNorth American AT-6D · S/N 42-44675Built 1942 · Boettcher Aerial Co Inc N891WTAir Tractor AT-502B · S/N 502B-2906Built 2013 · Boettcher Aerial Co N9060XCessna 182D · S/N 18253460Built 1960 · Lattin Travis W N928TNAir Tractor AT-502B · S/N 502B-2872Built 2013 · Boettcher Aerial Company Inc N93797Cessna A185F · S/N 18503247Built 1976 · Lattin Travis W N9519EAeronca 11AC · S/N 11AC-1155Goth Warren W

Back to Beloit, KS