OpenAirDocs.org
Alaska Aviation Museum

Registered aircraft · 20

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 = 'ALASKA AVIATION MUSEUM' OR list_contains(g.other_registrant_names, 'ALASKA AVIATION MUSEUM')
  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.

N1047BBeech C18S · S/N 7728Anchorage, AKN124AKRonda Donald E CIRCA NIEUPORT II · S/N 00560Built 1992 · Anchorage, AKN13122Grumman G-44 · S/N 1312Built 1943 · Anchorage, AKN14066Waco YKC-S · S/N 3991Built 1934 · Anchorage, AKN19906Douglas DC3 · S/N 4747Anchorage, AKN1ZSStinson L-1F · S/N 41-18915Built 1941 · Anchorage, AKN2869PPiper PA-18A · S/N 18-4459Anchorage, AKN30023Cessna T-50 · S/N 4629Built 1942 · Anchorage, AKN43606Taylorcraft BC12-D · S/N 7265Built 1946 · Anchorage, AKN43872Douglas DC-6 · S/N 53-3294Anchorage, AKN5028MTaylorcraft BC12-D · S/N 7617Built 1946 · Anchorage, AKN5415Stearman C3-B · S/N 121Built 1928 · Anchorage, AKN6319VHelio H-295 · S/N 1216Anchorage, AKN66CBRepublic RC-3 · S/N 774Built 1947 · Anchorage, AKN709YAmerican Airplane & Engine PILGRIM 100B · S/N 6605Built 1931 · Anchorage, AKN725ENoorduyn UC-64A · S/N 507Anchorage, AKN740ASBoeing 737-290C · S/N 22578Built 1981 · Anchorage, AKN789Grumman G-21A · S/N B-102Built 1943 · Anchorage, AKN79458Stinson VULTEE V-77 · S/N 77-36Built 1944 · Anchorage, AKN8159Curtiss Wright TRAVEL AIR S-6000-B · S/N 967Built 1929 · Anchorage, AK
Back to Alaska Aviation Museum