Southern Utah University
Registered aircraft · 66
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 = 'SOUTHERN UTAH UNIVERSITY' OR list_contains(g.other_registrant_names, 'SOUTHERN UTAH 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 = 'SOUTHERN UTAH UNIVERSITY' OR list_contains(g.other_registrant_names, 'SOUTHERN UTAH 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.
N101SURobinson Helicopter R44 II · S/N 14728N118SUAmerican Champion 7GCAA · S/N 522-2018N119SUAmerican Champion 7GCAA · S/N 523-2018N11SUCirrus Design SR20 · S/N 2359N123SURobinson Helicopter R44 II · S/N 14727N1298RBellanca 17-30A · S/N 30479N144BVRobinson Helicopter R44 II · S/N 13737N14SUCirrus Design SR20 · S/N 2360N1521STeledyne Flir SIRAS · S/N 1836FF1E01L230500037N1532SDJI MATRICE M30T · S/N 1581F5BKD226S00BC 7KKN153KSDJI MAVIC M3T · S/N 1581F5FJD233V00D659QN153USDJI MAVIC M3T · S/N 1581F5FJD233V00DTH67N15SUCirrus Design SR20 · S/N 2361N161SURobinson Helicopter R44 II · S/N 14731N162SURobinson Helicopter R44 II · S/N 14729N163SURobinson Helicopter R44 II · S/N 14730N164SURobinson Helicopter R44 II · S/N 14713N165SPBell 407 · S/N 53458N166SURobinson Helicopter R44 II · S/N 14379N167SURobinson Helicopter R44 · S/N 30064N169SURobinson Helicopter R44 II · S/N 13146N197SURobinson Helicopter R44 II · S/N 14091N19SUCirrus Design SR20 · S/N 2364N202MHBell 206-L4 · S/N 52057N2178BLuscombe 8F · S/N 6605N21SUCirrus Design SR20 · S/N 2365N229RBBeech 95-B55 (T42A) · S/N TC-2100N23SUCirrus Design SR20 · S/N 2366N2550BRobinson Helicopter R22 BETA · S/N 0611N299KDDabbs Kenneth Irven STARDUSTER II · S/N 760N32SUCirrus Design SR20 · S/N 2367N339EVEurocopter France SA330J · S/N 1285N33SUCirrus Design SR20 · S/N 2368N34SUCirrus Design SR20 · S/N 9504N397SURobinson Helicopter R44 II · S/N 10063N442HHRobinson Helicopter R44 II · S/N 10156N4499Robinson Helicopter R44 II · S/N 14430N455QBeech 95-B55 · S/N TC-1441N4760LPiper PA-28-180 · S/N 28-4091N497SURobinson Helicopter R44 II · S/N 11441N505SUBell Textron Canada 505 · S/N 65302N637LNRobinson Helicopter R44 II · S/N 11637N638SUSkydio SKYDIO 2 · S/N S2.OF.B.00EV2SN680SHRobinson Helicopter R22 BETA · S/N 3153N683SHRobinson Helicopter R22 BETA · S/N 3905N697SURobinson Helicopter R44 II · S/N 10736First renewal noticeN7086URobinson Helicopter R22 BETA · S/N 3702N74369Robinson Helicopter R44 II · S/N 10996N758FSDJI PHANTOM 2 · S/N PH646024963 V2.0N758KSDJI PHANTOM 2 · S/N PH646026135 V2.0
Back to Southern Utah University