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.
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
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.
N235UAAeromao AEROMAPPER · S/N 0406N236UAAeromao AEROMAPPER · S/N 0407N239UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 001N240UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 002N241UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 003N242UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 004N243UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 005N244UAInsitu SCANEAGLE · S/N 09-875N245UAInsitu SCANEAGLE · S/N 09-876N246UAInsitu SCANEAGLE · S/N 09-912N248UAING Robotic RESPONDER · S/N R-004N249UAING Robotic RESPONDER · S/N R-008N251MHDJI MATRICE 100 · S/N M02DCF16010174N252MHDJI INSPIRE 1 · S/N W13DC105040390N253MHDJI S900 · S/N S900-1N254MHDJI S1000 · S/N S1000-1N255MHDJI S1000 · S/N S1000-2N260MHDJI S1000 · S/N S1000-3N268UAXag V40 · S/N 8102227311LJN270UADJI MATRICE 30T · S/N 1581F5BKD236500DT784N271UAFreefly Systems ALTA X · S/N AXA427808N272UAFreefly Systems ALTA X · S/N AX383482N301UADRS Technologies SENTRY HP · S/N HP-27N302UADRS Technologies SENTRY HP · S/N HP-28N303UADRS Technologies SENTRY HP · S/N HP-30N304UADRS Technologies SENTRY HP · S/N HP-31N306UADRS Technologies SENTRY HP · S/N HP-33N307UADRS Technologies SENTRY HP · S/N HP-35N309UAAlaska CTR For Unmanned Acft X6A · S/N 21-342-1N311UASpektreworks COBALT-CR · S/N CBCR-2B-0823-GVTOL-511N351UAHybrid Project SUPERVOLO GEN 4 · S/N SV4-00-034N352UAHybrid Project SUPERVOLO GEN 4 · S/N SV4-00-036N353UAHybrid Project SUPERVOLO GEN 4 · S/N SV4-00-037N361UAWindracers ULTRA UAS · S/N MK1-021N362UAWindracers ULTRA UAS · S/N MK1-023N507WDSkydio X2E · S/N 1668BE10JA006395N701UAAlaska CTR For Unmanned Acft TAROT X6 · S/N HEX-HL-001N702UAAlaska CTR For Unmanned Acft TAROT X4 · S/N QUAD-HL-001N890RRDJI PHANTOM 4 · S/N 07DDD790B10808N972UASkyfront PERIMETER · S/N SKFP011913N980UAAutel EVO II · S/N HV6920141601N981UASkyfront PERIMETER 8 · S/N S080100332006
Back to University Of Alaska Fairbanks