Wasilla, AK
Registered aircraft · 1,274
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 = 'WASILLA' 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 = 'WASILLA' 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.
N1009HAeronca 15AC · S/N 15AC-11N101AWAviat A-1A · S/N 1445N101LGGrover Lloyd E CLOUD NINE · S/N LG-01N101THBellanca 8GCBC · S/N 293-79N1020VCessna U206F · S/N U20602404N10293Ellis Wendell Kirk PA-18-150 · S/N 2002N1031HAeronca 15AC · S/N 15AC-34N1043CNorth American SNJ-5 · S/N 8815726N104LHHood Lloyd A AIR CREATION GTE · S/N 98AK001N10572Piper PA-18-125 · S/N 18-933N105JHPiper PA-12 · S/N 12-3240N1067HAeronca 15AC · S/N 15AC-86N106GSMario R Maccarone JA30 SUPER STOL · S/N JA355-02-14N1070HAeronca 15AC · S/N 15AC-89N1078FCessna A185F · S/N 18502734N107EXCubcrafters CC11-160 · S/N CC11-00409N108RMStinson 108-3 · S/N 108-5257N1096HAeronca 15AC · S/N 15AC-116Registration pendingN10MKRussell R Elliott BUSHMASTER · S/N 001N11101Maule M-5-235C · S/N 7478CN112SSCessna 180J · S/N 18052510N1135YCessna 150B · S/N 15059535N113THHishon Thomas FOKKER D7 · S/N 031411N11405Cessna 150L · S/N 15075394N1158LLake LA-4 · S/N 320N116AKCessna 180H · S/N 18051469N116WKWilliam V Kingston CCK-1865 · S/N CCK-1865-1075N117AMMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7140N1185TCessna A185E · S/N 18501971N11AYWilliam D Konte CCK-1865 · S/N CCK-1865-1041N1204HAeronca 15AC · S/N 15AC-216N1210APiper PA-18-125 · S/N 18-823N1231FCessna A185F · S/N 18502793Registration pendingN123NTPatsch THORP T-18 · S/N 1042N123SHMesserschmitt-Bolkow-Blohm MBB-BK 117 B-2 · S/N 7183N1253APiper PA-18-125 · S/N 18-1049N1257Piper PA-18-150 · S/N 18-7907N125VTCaffrey Michael CHALLENGER II · S/N CH2-0684B0125N1264APiper PA-18 · S/N 18-1060N1266HAeronca 15AC · S/N 15AC279N1270APiper PA-18 · S/N 18-1065N1283APiper PA-18-125 · S/N 18-1087N128LBPiper PA-30 · S/N 30-1132N12BEMaule M-5-235C · S/N 7082CN12DZPilatus PC-12/45 · S/N 390N1325APiper PA-18 · S/N 18-1139N1325XSteven Joseph Baldwin PA18X · S/N 0001N135KAPiper PA-18-150 · S/N 18-7309021N135MAAviat A-1C-180 · S/N 3034N135WMPiper PA-18-135 · S/N 18-3599
Back to Wasilla, AK