OpenAirDocs.org
University Of Alaska Anchorage

Registered aircraft · 18

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

N17274Cessna 172R · S/N 17280353Built 1998 · Anchorage, AKN20541Cessna 172M · S/N 17261378Anchorage, AKN3389WPiper PA-32-260 · S/N 32-247Built 1965 · Anchorage, AKN35339Cessna 172S · S/N 172S8891Anchorage, AKN424PETextron 172S · S/N 172S12058Built 2017 · Anchorage, AKN439ADiamond Aircraft Ind DA20-C1 · S/N C0204Built 2003 · Anchorage, AKN604TTCessna 172S · S/N 172S10735Built 2008 · Anchorage, AKN7114RRobinson Helicopter R44 · S/N 0623Built 1999 · Anchorage, AKN792SPCessna 172S · S/N 172S8717Built 2001 · Anchorage, AKN8136ZCessna 310E · S/N 31010004Anchorage, AKN816SWCessna 172S · S/N 172S10576Built 2007 · Anchorage, AKN8615YPiper PA-30 · S/N 30-1755Built 1968 · Anchorage, AKN863PACessna 172S · S/N 172S9062Built 2002 · Anchorage, AKN8938YPiper PA-39 · S/N 39-99Built 1971 · Anchorage, AKN89601Cessna 140 · S/N 8648Built 1946 · Anchorage, AKN9508WCessna 172R · S/N 17280377Built 1998 · Anchorage, AKN959UACessna 172S · S/N 172S10526Built 2007 · Anchorage, AKN9752BCessna 172RG · S/N 172RG1012Built 1981 · Anchorage, AK
Back to University Of Alaska Anchorage