OpenAirDocs.org
State Of Alaska

Registered aircraft · 50

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'STATE OF ALASKA' OR list_contains(g.other_registrant_names, 'STATE OF ALASKA')
  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.

N1086BRobinson Helicopter R44 II · S/N 14698Built 2024 · Anchorage, AKN1155WKurt Lepping PA-18-150 · S/N AC101Dillingham, AKN125FGPiper PA-18-125 · S/N 18-1046Built 1951 · Kodiak, AKN1323YCessna 208 · S/N 20800352Built 2001 · Anchorage, AKN1386APiper PA-18-125 · S/N 18-1219Built 1951 · Anchorage, AKN145PLCessna U206G · S/N U20606141Built 1981 · Anchorage, AKN1867Hawker Beechcraft B300 · S/N FL-815Anchorage, AKN20786Cessna A185F · S/N 18503042Built 1976 · Anchorage, AKN2400SPiper PA-18-150 · S/N 18-7909144Anchorage, AKN303GVCessna 208B · S/N 208B0581Built 1996 · Palmer, AKN326CLRobinson Helicopter R44 II · S/N 14573Built 2022 · Anchorage, AKN3330DCessna 180 · S/N 32128Built 1955 · Kodiak, AKN34FGPiper PA-18-150 · S/N 18-7809041Built 1978 · Fairbanks, AKN4151TPiper PA-18-150 · S/N 1809016Built 1989 · Anchorage, AKN42033Cessna 172M · S/N 17264154Built 1974 · Anchorage, AKN4730ECessna A185F · S/N 18503848Built 1979 · Kodiak, AKN5461XCessna U206G · S/N U20605775Built 1980 · Anchorage, AKN54741Piper PA-18-150 · S/N 18-7609052Built 1976 · Anchorage, AKN574STCessna U206G · S/N U20606116Built 1981 · Anchorage, AKN607TCTextron 208 · S/N 20800607Built 2018 · Anchorage, AKN6987BPiper PA-18-150 · S/N 18-5109Built 1956 · Kodiak, AKN7040Piper PA-18-150 · S/N 183498Anchorage, AKN7041Piper PA-18-150 · S/N 18-7767Built 1961 · Anchorage, AKN7046Alaska Dept Of Public Safety PA-18 150 · S/N AK-DPS-01Built 1999 · Anchorage, AKN7049Piper PA-18-150 · S/N 18-8709Built 1968 · Anchorage, AKN7051Piper PA-18-150 · S/N 18-2932Built 1953 · Anchorage, AKN7052Piper PA-18-150 · S/N 18-8729Built 1968 · Anchorage, AKN7054Piper PA-18-150 · S/N 18-8915Built 1971 · Anchorage, AKN7055Piper PA-18 · S/N 18-8916Built 1971 · Anchorage, AKN7056Piper PA-18 · S/N 18-8917Built 1971 · Anchorage, AKN7063JPiper PA-18-150 · S/N 18-8807Built 1969 · Nome, AKN7067Dehavilland DHC-2-L-20 · S/N 1152Built 1956 · Kodiak, AKN70714Piper PA-18-150 · S/N 18-7909114Built 1979 · Anchorage, AKN70715Cessna 208 · S/N 20800182Built 1990 · Anchorage, AKN7085Piper PA-18-150 · S/N 18-8069Built 1963 · Anchorage, AKN714NKCessna A185F · S/N 18504405Built 1983 · Anchorage, AKN7183CRobinson Helicopter R44 · S/N 0995Built 2001 · Anchorage, AKN7196HRobinson Helicopter R44 · S/N 0994Built 2001 · Anchorage, AKN7695SBellanca 8GCBC · S/N 225-76Built 1976 · Fairbanks, AKN7761DPiper PA-18A 150 · S/N 18-5940Fairbanks, AKN82732Piper PA-18-150 · S/N 18-7709182Built 1977 · Anchorage, AKN82735Piper PA-18-150 · S/N 18-7709183Built 1977 · Anchorage, AKN82736Piper PA-18-150 · S/N 18-7709184Built 1977 · Anchorage, AKN840AKRockwell International 690C · S/N 11643Built 1980 · Palmer, AKN8717QCessna A185F · S/N 18503757Built 1979 · Nome, AKN88AKPiper PA-18-150 · S/N 18-8311Built 1965 · Anchorage, AKN905AKGulfstream Aerospace 695B · S/N 96063Palmer, AKN911AAAmerican Eurocopter AS350B3 · S/N 7536Built 2013 · Anchorage, AKN911NTAmerican Eurocopter AS350B3 · S/N 7665Built 2013 · Anchorage, AKN981AKCessna TU206G · S/N U20606248Built 1981 · Anchorage, AK
Back to State Of Alaska