West Jordan, UT
Registered aircraft · 39
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 = 'WEST JORDAN' 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 = 'WEST JORDAN' 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.
N11050Champion 7ECA · S/N 52N1168SMooney M20K · S/N 25-0694N15984Piper PA-28-140 · S/N 28-7325218N16070Douglas DC-3A-S1C3G · S/N 1910First renewal noticeN17WLSchweitzer Thomas E WHITE LIGHTNING · S/N 72N1840NCessna 120 · S/N 12084N184SXGraber Benjamin SONEX · S/N 0184N1866JRockwell International 112TC · S/N 13032N2393HErcoupe 415-C · S/N 3018N249SBConsolidated Vultee PBY-5A · S/N CV 249First renewal noticeN251MBMooney M20M · S/N 27-0353N331BGPiper PA-28-181 · S/N 2843373N3449YCessna 180H · S/N 18051949N385MMEpic LT #45-N399my EPIC LT · S/N 045N392HSEurocopter AS 350 B3 · S/N 3252N399MAPiper PA-28-181 · S/N 2843599N4318NCessna 190 · S/N 7092N444EECessna 172M · S/N 17263906N4533VBeech 35 · S/N D-1359N4763SCessna TR182 · S/N R18201419N4971GCessna 172N · S/N 17273518N49PXCirrus Design SR22 · S/N 3570N5818MCessna 310P · S/N 310P0118N59YYCessna 175A · S/N 56429N6266ECessna 182R · S/N 18268355N635KCNew Piper PA-28-181 · S/N 2843635N70HFPiper PA-28-181 · S/N 28-7890248N723AJPiper PA-28-181 · S/N 2843613N80391Cessna A185F · S/N 18503117N803TThille Michael P HORNET · S/N 0011N8179DCessna 177RG · S/N 177RG0009N8515PPiper PA-24-400 · S/N 26-52N85400Aeronca 7AC · S/N 7AC-4140N8708XCessna 182D · S/N 18253108N90216Cintron Orlando CH-650 · S/N 65-10672N9039TCessna 182C · S/N 52939N9176BAerostar International RAVEN S52A · S/N S52A-3013N920CCWilson Christopher R WILSON-MONARCH · S/N 003N966FSAerospatiale AS350BA · S/N 2301
Back to West Jordan, UT