Big Lake, AK
Registered aircraft · 110
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 = 'BIG LAKE' 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 = 'BIG LAKE' 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.
N1089FCessna A185F · S/N 18502744N109ZXTierra-T Bird II Goldencircle T-BIRD II · S/N 574321646N1200SSchweizer SGS 2-33A · S/N 200N1251APiper PA-18 · S/N 18-1047N1267HAeronca 15AC · S/N 15AC-278N1320DCessna 170A · S/N 19896N150GRCessna 150G · S/N 15066875N1617CCessna 180 · S/N 30317N1689ZCessna 185A · S/N 1850489N1752CCessna 180 · S/N 30452N1763PPiper PA-18-150 · S/N 18-4087N2005KTaylorcraft F21 · S/N F-1016N202AKBradshaw S/Mccauley J G202 · S/N 54N206RBCessna U206C · S/N U206-1068N2072YConover Dale L TUNDRA PUP · S/N 89-2001N20861Grumman HU-16D · S/N 141278N2439LCessna 172H · S/N 17255639N2453CCessna 180 · S/N 30753N246LDPiper PA-18-135 · S/N 18-1945N24846Piper J3C-65 · S/N 3486N2527DCessna 170B · S/N 20679N252LGHiller OH-23C · S/N 55-4096N2740CCessna 170B · S/N 26284N2800UCessna 172D · S/N 17250400N2897ZPiper PA-18 · S/N 18-7083N2947DCessna 170B · S/N 26890N3007ACessna 170B · S/N 25651N3022VCessna 150M · S/N 15076354N3042JCessna 150E · S/N 15061142N3058BCessna 195 · S/N 7941N3135CCessna 180 · S/N 30934N3143ACessna 170B · S/N 25787N332SQWilson Lucky H SQ2 · S/N SQ002 (TC0809053)N3357ZPiper PA-22-150 · S/N 22-7297N3417CCessna 170B · S/N 26460N35523Piper J3C-65 · S/N 6428N3563TTaylorcraft F19 · S/N F-023N3597PPiper PA-18-150 · S/N 18-4555N3678TTaylorcraft F19 · S/N F-086N375UMPiper PA-18S-150 · S/N 18-5447N3876VCessna A185F · S/N 18504167N3967EAeronca 11BC · S/N 11BC-52N3982ZPiper PA-18S-150 · S/N 18-7925N3EHCessna 180D · S/N 18051020N4036ZPiper PA-18-150 · S/N 18-7996N42782Piper J3C-85 · S/N 15096N42DBeech E18S · S/N BA-117N4323ZPiper PA-18-150 · S/N 18-8638N4440LPiper PA-18-150 · S/N 187909169N4761QCessna A185E · S/N 185-1226
Back to Big Lake, AK