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.
N100DADiamond Aircraft Industries GM DA 62 · S/N 62.078N103UVDiamond Aircraft Ind DA 40 · S/N 40.683N104UVDiamond Aircraft Ind DA 40 · S/N 40.684N105UVDiamond Aircraft Ind DA 40 · S/N 40.685N106UVDiamond Aircraft Ind DA 40 · S/N 40.686N107UVDiamond Aircraft Ind DA 40 · S/N 40.1030N108UVDiamond Aircraft Ind DA 40 · S/N 40.342N109UVDiamond Aircraft Ind DA 40 · S/N 40.1214N110UVDiamond Aircraft Ind DA 40 · S/N 40.1216N112UVDiamond Aircraft Ind DA 40 · S/N 40.1217N113UVDiamond Aircraft Ind DA 40 · S/N 40.1218N114UVDiamond Aircraft Ind DA 40 · S/N 40.1221N115UVDiamond Aircraft Ind DA 40 · S/N 40.1222N116UVDiamond Aircraft Ind DA 40 · S/N 40.1223N118UVDiamond Aircraft Ind DA 40 · S/N 40.1224N119PJDale M Jarvis WAIEX · S/N W0133N119UVDiamond Aircraft Ind DA 40 · S/N 40.1225N170SBCessna 170B · S/N 25140N195EAPipistrel D O O VIRUS SW 121A · S/N VSWX121A0140Registration pendingN1998CBombardier BD-100-1A10 · S/N 20996N21BPAerostar International RX 8 · S/N RX8-3136N222BJCessna 414 · S/N 414-0264N2554UCessna 172D · S/N 17250154N2572VCessna 177RG · S/N 177RG0620N258EBRaytheon 400A · S/N RK-129N264QBeech 95-B55 (T42A) · S/N TC-987N2880RCessna 182K · S/N 18258480N313VBombardier BD-100-1A10 · S/N 20365N31EETharon Judd AIRCAM · S/N AC-215N3412QCessna 320E · S/N 320E0012N3427TCessna 177 · S/N 17700727N36352Bellanca 8KCAB · S/N 108-73N4012XDiamond Aircraft Ind DA 40 · S/N 40.790N423DAPowrachute PEGASUS · S/N A484PEGN45MTPiper PA-34-200T · S/N 347770233N477UVPiper PA-44-180 · S/N 4496450N488UVPiper PA-44-180 · S/N 4496451N4918SCessna TR182 · S/N R18201457N499UVPiper PA-44-180 · S/N 4496454N5099LLund Larry L TITAN TORNADO II · S/N D96618S0HK0227Registration pendingN524SJJohnson Steven K RV-9A · S/N 90730N527CPCirrus Design SR22 · S/N 3029N551RVRyan D Brown RV-9A · S/N 92185N5692YEnstrom F-28C · S/N 494-2N582WCCallahan William O PA 1 · S/N 1554DN5904LAmerican AA-1 · S/N AA1-0204Registration pending, pending cancellationN597RBIsrael Aircraft Industries GULFSTREAM 200 · S/N 068N611VBVans RV-12 · S/N 120087N66TJTharon Judd ZENITH CH701 · S/N 7-11686N7100ACessna 172 · S/N 29200
Back to Orem, UT