Skip to content

Utah State University

Registered aircraft · 57

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

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 = 'UTAH STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'UTAH STATE UNIVERSITY') ORDER BY g.n_number

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 = 'UTAH STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'UTAH STATE UNIVERSITY')
  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 = 'UTAH STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'UTAH STATE UNIVERSITY')
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.

N118GMDiamond Aircraft Ind DA 40 · S/N 40.521Built 2005 · Logan, UT N127KCDiamond Aircraft Ind DA 40 · S/N 40.1127Built 2011 · Logan, UT N132MHRobinson Helicopter R22 BETA · S/N 3648Built 2004 · Logan, UT N132TSDiamond Aircraft Ind DA 42 · S/N 42.AC018Built 2006 · Logan, UT N146ZBeech 58P · S/N TJ-426Built 1982 · Logan, UT N155UDiamond Aircraft Ind DA 40 · S/N 40.1251Built 2025 · Logan, UT N157UDiamond Aircraft Ind DA 40 · S/N 40.1253Built 2025 · Logan, UT N158UDiamond Aircraft Ind DA 40 · S/N 40.1254Built 2025 · Logan, UT N159UDiamond Aircraft Ind DA 40 · S/N 40.1255Built 2025 · Logan, UT N1707SDiamond Aircraft Ind DA 40 · S/N 40.509Built 2005 · Logan, UT N194TSDiamond Aircraft Ind DA 40 · S/N 40.972Built 2008 · Logan, UT N204LCRobinson Helicopter R44 II · S/N 10248Built 2004 · Logan, UT N230DCDiamond Aircraft Ind DA 40 · S/N 40.966Built 2008 · Logan, UT N239DCDiamond Aircraft Ind DA 40 · S/N 40.968Built 2008 · Logan, UT N240TSDiamond Aircraft Ind DA 42 · S/N 42.072Built 2005 · Logan, UT N3035FRobinson Helicopter R22 BETA · S/N 4169Built 2007 · Logan, UT N321FSDiamond Aircraft Ind DA 40 · S/N 40.384Built 2004 · Logan, UT N330DDRobinson Helicopter R22 BETA · S/N 3401Built 2002 · Logan, UT N344AFDiamond Aircraft Ind DA 40 · S/N 40.1044Built 2009 · Logan, UT N350TSDiamond Aircraft Ind DA 42 · S/N 42.061Built 2005 · Logan, UT N383PSDiamond Aircraft Ind DA40 F · S/N 40.FC021Built 2006 · Logan, UT N384CADiamond Aircraft Ind DA 40 · S/N 40.734Built 2006 · Logan, UT N4138GRobinson Helicopter R22 BETA · S/N 4275Built 2008 · Logan, UT N415AMDiamond Aircraft Ind DA 40 · S/N 40.517Built 2005 · Logan, UT N416FPDiamond Aircraft Ind DA40 F · S/N 40.FC016Built 2006 · Logan, UT N417FPDiamond Aircraft Ind DA40 F · S/N 40.FC017Built 2006 · Logan, UT N418FPDiamond Aircraft Ind DA40 F · S/N 40.FC018Built 2006 · Logan, UT N422FPDiamond Aircraft Ind DA40 F · S/N 40.FC022Built 2006 · Logan, UT N423FPDiamond Aircraft Ind DA40 F · S/N 40.FC023Built 2006 · Logan, UT N424FPDiamond Aircraft Ind DA40 F · S/N 40.FC024Built 2006 · Logan, UT N425FPDiamond Aircraft Ind DA40 F · S/N 40.FC025Built 2006 · Logan, UT N434DDRobinson Helicopter R22 BETA · S/N 3182Built 2001 · Logan, UT N442KPRobinson Helicopter R44 II · S/N 10862Built 2005 · Logan, UT N442THRobinson Helicopter R44 II · S/N 11619Built 2007 · Logan, UT N444CRRobinson Helicopter R22 · S/N 4578Built 2012 · Logan, UT N451DSDiamond Aircraft Ind DA 40 · S/N 40.1136Built 2012 · Logan, UT N459TSDiamond Aircraft Ind DA 42 · S/N 42.AC059Built 2007 · Logan, UT N543JWDiamond Aircraft Ind DA 40 · S/N 40.358Logan, UT N6006CCessna R182 · S/N R18200347Logan, UT N605CADiamond Aircraft Ind DA 40 · S/N 40.911Built 2008 · Logan, UT N616MLDiamond Aircraft Ind DA 40 · S/N 40.1067Built 2009 · Logan, UT N67508Cessna 152 · S/N 15281877Built 1978 · Logan, UT N704PADiamond Aircraft Ind DA 40 · S/N 40.704Built 2006 · Logan, UT N712PADiamond Aircraft Ind DA 40 · S/N 40.912Built 2008 · Logan, UT N72MZDiamond Aircraft Ind DA 40 · S/N 40.716Logan, UT N734MDiamond Aircraft Ind DA 40 · S/N 40.985Built 2008 · Logan, UT N74SWDiamond Aircraft Ind DA 40 · S/N 40.828Built 2007 · Logan, UT N753BXLancair Intl PROPJET · S/N LIV-585Built 2007 · Logan, UT N759PADiamond Aircraft Ind DA 40 · S/N 40.929Built 2008 · Logan, UT N78USDiamond Aircraft Ind DA 40 · S/N 40.1219Built 2020 · Logan, UT

Back to Utah State University