University Of Alaska Fairbanks

Registered aircraft · 42

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

N235UAAeromao AEROMAPPER · S/N 0406Fairbanks, AKN236UAAeromao AEROMAPPER · S/N 0407Fairbanks, AKN239UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 001Fairbanks, AKN240UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 002Fairbanks, AKN241UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 003Fairbanks, AKN242UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 004Fairbanks, AKN243UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 005Fairbanks, AKN244UAInsitu SCANEAGLE · S/N 09-875Fairbanks, AKN245UAInsitu SCANEAGLE · S/N 09-876Fairbanks, AKN246UAInsitu SCANEAGLE · S/N 09-912Fairbanks, AKN248UAING Robotic RESPONDER · S/N R-004Fairbanks, AKN249UAING Robotic RESPONDER · S/N R-008Fairbanks, AKN251MHDJI MATRICE 100 · S/N M02DCF16010174Fairbanks, AKN252MHDJI INSPIRE 1 · S/N W13DC105040390Fairbanks, AKN253MHDJI S900 · S/N S900-1Fairbanks, AKN254MHDJI S1000 · S/N S1000-1Fairbanks, AKN255MHDJI S1000 · S/N S1000-2Fairbanks, AKN260MHDJI S1000 · S/N S1000-3Fairbanks, AKN268UAXag V40 · S/N 8102227311LJFairbanks, AKN270UADJI MATRICE 30T · S/N 1581F5BKD236500DT784Fairbanks, AKN271UAFreefly Systems ALTA X · S/N AXA427808Fairbanks, AKN272UAFreefly Systems ALTA X · S/N AX383482Fairbanks, AKN301UADRS Technologies SENTRY HP · S/N HP-27Fairbanks, AKN302UADRS Technologies SENTRY HP · S/N HP-28Fairbanks, AKN303UADRS Technologies SENTRY HP · S/N HP-30Fairbanks, AKN304UADRS Technologies SENTRY HP · S/N HP-31Fairbanks, AKN306UADRS Technologies SENTRY HP · S/N HP-33Fairbanks, AKN307UADRS Technologies SENTRY HP · S/N HP-35Fairbanks, AKN309UAAlaska CTR For Unmanned Acft X6A · S/N 21-342-1Fairbanks, AKN311UASpektreworks COBALT-CR · S/N CBCR-2B-0823-GVTOL-511Fairbanks, AKN351UAHybrid Project SUPERVOLO GEN 4 · S/N SV4-00-034Fairbanks, AKN352UAHybrid Project SUPERVOLO GEN 4 · S/N SV4-00-036Fairbanks, AKN353UAHybrid Project SUPERVOLO GEN 4 · S/N SV4-00-037Fairbanks, AKN361UAWindracers ULTRA UAS · S/N MK1-021Fairbanks, AKN362UAWindracers ULTRA UAS · S/N MK1-023Fairbanks, AKN507WDSkydio X2E · S/N 1668BE10JA006395Fairbanks, AKN701UAAlaska CTR For Unmanned Acft TAROT X6 · S/N HEX-HL-001Fairbanks, AKN702UAAlaska CTR For Unmanned Acft TAROT X4 · S/N QUAD-HL-001Fairbanks, AKN890RRDJI PHANTOM 4 · S/N 07DDD790B10808Fairbanks, AKN972UASkyfront PERIMETER · S/N SKFP011913Fairbanks, AKN980UAAutel EVO II · S/N HV6920141601Fairbanks, AKN981UASkyfront PERIMETER 8 · S/N S080100332006Fairbanks, AK
Back to University Of Alaska Fairbanks