Iliamna, AK
Registered aircraft · 27
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 = 'AK' AND g.registrant_city = 'ILIAMNA' 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 = 'AK' AND g.registrant_city = 'ILIAMNA' 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.
N1748UCessna 207 · S/N 20700348N177AKAviat A-1B · S/N 2071N28830Luscombe 8C · S/N 1572N2905ECessna 172N · S/N 17271369N2971MPiper PA-12 · S/N 121363N333FUCessna U206G · S/N U20604126N3682ZBeech 58 · S/N TH-1159N4194QCessna TU206D · S/N U2061359N458LJDehavilland DHC-2 MK 1 · S/N 514N4831HPiper PA-17 · S/N 17-129Sale reportedN6483TCessna 150 · S/N 17883N67030Dehavilland DHC-2 · S/N 1372N67112Dehavilland BEAVER DHC-2 MK.1 · S/N 1046N68088Dehavilland BEAVER U-6A · S/N 1197N715HLPilatus PC-12/45 · S/N 292N715NLPilatus PC-12/45 · S/N 109N715SJPilatus PC-12/45 · S/N 341N715TLPilatus PC-12/45 · S/N 548N7379UCessna 207A · S/N 20700427N78463Piper PA-12 · S/N 12-1974N818TAPiper PA-18-150 · S/N 18-8818N8202HHedlund Thomas A 162F ROTORWAY · S/N 2781N82598Piper PA-18-150 · S/N 18-7909012N82962Piper PA-18-150 · S/N 18-7909037N85LZCessna A185F · S/N 18502777N9720MCessna 207A · S/N 20700720N98851Piper PA-18-150 · S/N 18-7188
Back to Iliamna, AK