Orem, UT
Registered aircraft · 65
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 = 'OREM' 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 = 'OREM' 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.
N717CLEurocopter EC 130 B4 · S/N 3720N732QCCessna T210M · S/N 21061681N7440QCessna 182P · S/N 18261080N749DSDiamond Aircraft Ind DA 40 · S/N 40.749N779USDiamond Aircraft Ind DA 40 · S/N 40.779N793USDiamond Aircraft Ind DA 40 · S/N 40.793N801CBCessna 560 · S/N 560-0584N8088ZPiper PA-28-201T · S/N 28-7921054N80993Globe GC-1B · S/N 1186N908MCCessna 182T · S/N 18281900N911RCCameron Balloons US Z-77 · S/N 6618N957CTDiamond Aircraft Ind DA20-C1 · S/N C0072N974CTDiamond Aircraft Ind DA20-C1 · S/N C0074N9891WPiper PA-28-235 · S/N 28-10698Registration pendingN9918QCessna 172M · S/N 17265862
Back to Orem, UT