Provo, UT
Registered aircraft · 145
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
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.
N60MJBeech 1900D · S/N UE-60N60UCBeech 1900C · S/N UC-60N6121ECessna 172 · S/N 46221N61UCBeech 1900C · S/N UC61N6202UMooney M20C · S/N 2041N626TTCirrus Design SR22T · S/N 2018N640AXBeech 1900C · S/N UC-1N64UCBeech 1900C · S/N UC-64N667QBeech 95 · S/N TD-260N6876JPiper PA-28-181 · S/N 28-7690417N68UBBeech 1900C · S/N UB-68N691CBTextron G36 · S/N E-4079N713CSCessna 525C · S/N 525C0120N7157BCessna 182S · S/N 18280555N716MJBeech 1900D · S/N UE-16N719GLBeech 1900C · S/N UB-19N7341TCessna 172A · S/N 46941N7407WPiper PA-28-180 · S/N 28-1294N75248Piper PA-28-140 · S/N 28-7625209N7EMMccombs BABY ACE C · S/N MC-2N800PRRobinson Helicopter R44 II · S/N 10504N8066ZCessna U206A · S/N U206-0466N821SFBeech 1900C · S/N UC-121N838WCPilatus PC-12/47E · S/N 2089N84EETharon Judd HIGHLANDER · S/N JA 555 6-19N854JWMaule M-5-210C · S/N 6037CN855SAEurocopter AS 350 B2 · S/N 3474N8593WPiper PA-28-235 · S/N 28-10105N8624VBellanca 7GCBC · S/N 810-75N877EMCirrus Design SR22T · S/N 1217First renewal noticeN89021Cessna 152 · S/N 15282598N8908NPiper PA-32-300 · S/N 32-40695N899CABeech 99A · S/N U-104N9138VMooney M20C · S/N 690023N917YDouglas B-26B · S/N 28053N9227QBalony Kubicek Spol Sro BB26Z · S/N 1608N950AABeech B-99 · S/N U-159N95225Piper PA-28-140 · S/N 28-25851N9583JPiper PA-28-180 · S/N 28-3722N95WABeech 99 · S/N U-6N9629KPiper PA-28-181 · S/N 28-7690267N969BSCirrus Design SR22T · S/N 0969N9963YCessna T210N · S/N 21064649N999DZBeech 99 · S/N U70N99GHBeech 99A · S/N U-112
Back to Provo, UT