Chugiak, AK
Registered aircraft · 201
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 = 'CHUGIAK' 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 = 'CHUGIAK' 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.
N1005FCessna A185F · S/N 18502677N1036NMaule M-7-235B · S/N 23035CN1042APiper PA-18-125 · S/N 18-616N1045HAeronca S15AC · S/N 15AC51N107LCessna A185F · S/N 18503535N109SWCessna U206G · S/N U20603799N1127APiper PA-18A · S/N 18-720N1154CPiper PA-18A-135 · S/N 18-2212N1204FCessna A185F · S/N 18502767N1217EBellanca 8GCBC · S/N 255-77N1259CPiper PA-18 · S/N 18-2500N1311DCessna 170A · S/N 19887N1341TPiper PA-28R-200 · S/N 28R-7235264N135ESPiper PA-18-150 · S/N 18-8109074N1363APiper PA-18 · S/N 18-1189N13960Piper PA-18-150 · S/N 18-8984N1450HAeronca 15AC · S/N 15AC-519N1487LBeech A23 · S/N M-887N150HKCessna 150M · S/N 15076953N1576HCessna A185F · S/N 18503309N1597PPiper PA-18-135 · S/N 18-3762N15CSCessna R172E · S/N R172-GC-3N1651DCessna 170B · S/N 20293N170TTValentin TAIFUN 17E · S/N 1043N1715DCessna 170A · S/N 20158N171QCessna 172 · S/N 28197N180BSCessna 180C · S/N 624N180MBCessna 180 · S/N 30663N180RPCessna 180A · S/N 50201N1852RCessna A185F · S/N 18502567N185AHCessna A185F · S/N 18504263N1862YCessna 172C · S/N 17249462N18PXPiper PA-18-150 · S/N 18-7570N1962VCessna 140 · S/N 14173N19802Cessna 172M · S/N 17260765N208TCCessna 180J · S/N 18052749N208WSNavion NAVION H · S/N NAV-4-2528N21832Cessna A185F · S/N 18503069N2236TCessna A185E · S/N 185-1390N2373NCessna 140 · S/N 12622N2487HPiper PA-18-150 · S/N 18-7909195N2567DCessna 170B · S/N 20719N263EYSwartz Leslie G RV9-A · S/N 91582N264MCessna 180A · S/N 50236N2694PPiper PA-18A 150 · S/N 18-4382N2709XCessna 180H · S/N 18051509N2802KCessna 180K · S/N 18053073N2855TPiper PA-18-150 · S/N 18-7071N2886CCessna 170B · S/N 26429N2993ZPiper PA-18 · S/N 18-7112
Back to Chugiak, AK