Kiln, MS
Registered aircraft · 20
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'MS' AND g.registrant_city = 'KILN' 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 = 'MS' AND g.registrant_city = 'KILN' 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.
N105GTVashon RANGER R7 · S/N 10213Registration pendingN1086UCessna 172M · S/N 17266835N123KTCessna 210C · S/N 21058218N13DWDehavilland DHC-1 · S/N FA460N188BAIcon A5 · S/N 00098N2366MCessna 182S · S/N 18280447N237MECessna 182S · S/N 18280756N2382HCessna 182S · S/N 18280473N240DCCessna 182T · S/N 18281099N2449ACessna 182S · S/N 18280632N2474NCessna 182T · S/N 18280980N326CFCessna 182T · S/N 18281045N3556VCessna 182T · S/N 18281009N53214Cessna 182T · S/N 18281171N577TZCessna 182T · S/N 18281123N7229WPiper PA-28-180 · S/N 28-1046N79932Cessna 172K · S/N 17258259N801ALCessna 182S · S/N 18280767N868SPCessna 172S · S/N 172S8128N905PCLancair LC42-550FG · S/N 42026
Back to Kiln, MS