Registered aircraft · 16

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

N11028Champion 7ECA · S/N 7ECA-14Built 1964 · Rush Casey K N117RMDJI AGRAS T40 · S/N 1581F574B2363001012ERm Precision Ag LLC N199RWWright Richard Eugene EAA B1-PLANE P-1 · S/N REW-01Built 1991 · Rush Casey K N224FNCharles Martel SPORTSMAN 2 + 2 · S/N CM-1Rush Wayne A N34796Cessna 177B · S/N 17702007Built 1973 · Masters David R N50EFDJI AGRAS T40 · S/N 1581F574B23730010219Elevated Farming LLC N52EFDJI AGRAS T40 · S/N 1581F574B239800100A8Elevated Farming LLC N6101WPiper PA-28-140 · S/N 28-20115Built 1964 · Studer Joseph D N654QMDJI AGRAS T50 · S/N 1581F6BUB252B001648PRm Precision Ag LLC N654TMDJI AGRAS T50 · S/N 1581F6BUB252J00119G1Rm Precision Ag LLC N6924WPiper PA-28-140 · S/N 28-21098Built 1965 · Alpha 3 LLC N839JFXag P150 · S/N 18632FPEG8223508M74K5Rm Precision Ag LLC N840JFDJI AGRAS T40 · S/N 1581F574B237W0010174Rm Precision Ag LLC N9074GCessna 182N · S/N 18260614Built 1971 · Rush Wayne A N920XXDJI AGRAS T40 · S/N 1581F574B22850010237Grable Ryan A N9586WPiper PA-28-140 · S/N 28-23032Built 1967 · Alpha 3 LLC

Back to Troy, KS