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 = 'KY' AND g.registrant_city = 'MARION' 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 = 'KY' AND g.registrant_city = 'MARION'
  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 = 'KY' AND g.registrant_city = 'MARION'
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.

N1720FFrye Oren JR SPACEWALKER · S/N SW6041BGillies Paul A N27461Taylorcraft BL-65 · S/N 2103Topp William J N28678Grumman American Avn. AA-5B · S/N AA5B0679Built 1977 · Rubino Daniel A N302SWDJI AGRAS T40 · S/N 1581F574B2398001002BSuperior Whitetail Habitats LLC N321ACPiper PA-23-250 · S/N 27-7405334Built 1974 · B & H Aviation LLC N3943NBeech 35 · S/N D-1290Built 1948 · Hunt John A N46538Aeronca 0-58B · S/N 058B-8573Built 1943 · Johnson James C N48000Nord STAMPE SV4C · S/N 393Gillies Paul A N57AUAuster J5P · S/N 3155Built 1955 · Gillies Paul A N6775QGrumman Acft ENG Cor-Schweizer G-164B · S/N 285BBuilt 1977 · Baker Ralph T N7110SDehavilland TIGER MOTH DH 82A · S/N 83015Built 1940 · Gillies Paul A N72299Beech F33A · S/N CE-1061Built 1985 · Johnson James C N731BMCessna A188B · S/N 18802768TBenaiah Holdings Corp N7966NPiper PA-28-180 · S/N 28-5382Built 1969 · West Timothy A N798VBrewster FLEET 7 · S/N 378Gillies Paul A N94984Taylorcraft BC12-D · S/N 9384Built 1946 · Topp William

Back to Marion, KY