OpenAirDocs.org
Utah Valley University

Registered aircraft · 23

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

N103UVDiamond Aircraft Ind DA 40 · S/N 40.683Built 2006 · Orem, UTN104UVDiamond Aircraft Ind DA 40 · S/N 40.684Built 2006 · Orem, UTN105UVDiamond Aircraft Ind DA 40 · S/N 40.685Built 2006 · Orem, UTN106UVDiamond Aircraft Ind DA 40 · S/N 40.686Built 2006 · Orem, UTN107UVDiamond Aircraft Ind DA 40 · S/N 40.1030Built 2009 · Orem, UTN108UVDiamond Aircraft Ind DA 40 · S/N 40.342Built 2003 · Orem, UTN109UVDiamond Aircraft Ind DA 40 · S/N 40.1214Built 2020 · Orem, UTN110UVDiamond Aircraft Ind DA 40 · S/N 40.1216Built 2020 · Orem, UTN112UVDiamond Aircraft Ind DA 40 · S/N 40.1217Built 2020 · Orem, UTN113UVDiamond Aircraft Ind DA 40 · S/N 40.1218Built 2020 · Orem, UTN115UVDiamond Aircraft Ind DA 40 · S/N 40.1222Built 2020 · Orem, UTN116UVDiamond Aircraft Ind DA 40 · S/N 40.1223Built 2020 · Orem, UTN118UVDiamond Aircraft Ind DA 40 · S/N 40.1224Built 2020 · Orem, UTN119UVDiamond Aircraft Ind DA 40 · S/N 40.1225Built 2020 · Orem, UTN4012XDiamond Aircraft Ind DA 40 · S/N 40.790Built 2007 · Orem, UTN477UVPiper PA-44-180 · S/N 4496450Built 2018 · Orem, UTN488UVPiper PA-44-180 · S/N 4496451Built 2018 · Orem, UTN499UVPiper PA-44-180 · S/N 4496454Built 2019 · Orem, UTN749DSDiamond Aircraft Ind DA 40 · S/N 40.749Built 2007 · Orem, UTN779USDiamond Aircraft Ind DA 40 · S/N 40.779Built 2007 · Orem, UTN793USDiamond Aircraft Ind DA 40 · S/N 40.793Orem, UTN957CTDiamond Aircraft Ind DA20-C1 · S/N C0072Built 1999 · Orem, UTN974CTDiamond Aircraft Ind DA20-C1 · S/N C0074Built 1999 · Orem, UT
Back to Utah Valley University