Provo, UT
Registered aircraft · 145
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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_state = 'UT' AND g.registrant_city = 'PROVO' 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_state = 'UT' AND g.registrant_city = 'PROVO' 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.
N100UXBeech 1900D · S/N UE-100N101UEBeech 1900C · S/N UC-101N103SFBeech 1900C · S/N UC-103N111APGulfstream Aerospace GVII-G500 · S/N 72030N114AXBeech 1900C · S/N UC-36N118MDBeech 99A · S/N U-118N120UCBeech 1900C · S/N UC120N122UXBeech 1900D · S/N UE-122N124GPBeech 1900C · S/N UB-23N125BABeech 1900 · S/N UB-6N125KSBeech B200C · S/N BL-125N125NGDiamond Aircraft Ind DA 40 NG · S/N 40.N261N127BABeech 1900 · S/N UB-7N12ZGCirrus Design SR20 · S/N 2600N132KCBeech 1900D · S/N UE-132N133BABeech 1900C · S/N UB54N149SFBeech 1900C · S/N UC-149N14MVBeech 99 · S/N U59N150KJBeech 1900C · S/N UC-150N153GABeech 1900C · S/N UB-34N153GLBeech 1900D · S/N UE-153N154GABeech 1900C · S/N UB-25N154GLBeech 1900D · S/N UE-154N1603LCameron Balloons US N-90 · S/N 5952N1657XCessna T210L · S/N 21060692N165YVBeech 1900D · S/N UE-165N169GLBeech 1900D · S/N UE-169N170GLBeech 1900D · S/N UE-170N172GABeech 1900C · S/N UB-11N1776GKubicek Factory S R O BB26Z · S/N 1950N1776HCameron Balloons US Z-90 · S/N 6882N1776NBalony Kubicek Spol Sro BB30Z · S/N 1361N178YVBeech 1900D · S/N UE-178N184UXBeech 1900D · S/N UE-184N190GABeech 1900C · S/N UB-1N192GABeech 1900 · S/N UB-17N194GABeech 1900C · S/N UB-8N195GLBeech 1900D · S/N UE-195N197GABeech 1900C · S/N UB-16N198GABeech 1900C · S/N UB-5N199JFBarney Robert J STARDUSTER · S/N 2N201GLBeech 1900D · S/N UE-201N202UXBeech 1900D · S/N UE-202N211GLBeech 1900D · S/N UE-211N216CSBeech C-99 · S/N U-216N218SLBeech 1900C · S/N UC113N219VPBeech 1900 · S/N UB-14N21RCBeech C35 · S/N D-2789N220GLBeech 1900D · S/N UE-220N231YVBeech 1900D · S/N UE-231
Back to Provo, UT