South Jordan, UT
Registered aircraft · 53
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 = 'SOUTH 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 = 'SOUTH 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.
N121ECCessna 177 · S/N 17700036N12531Cessna 172M · S/N 17262046N13GZRaytheon C90A · S/N LJ-1590N1454UCessna 172M · S/N 17267121N1551VCessna 172M · S/N 17263656N1842TPiper PA-28-140 · S/N 28-7125273N211VMPiper PA-28R-201 · S/N 2837030N230SAndersen Brian AIRCAM · S/N AC-264N246AWRash Wesley RV-7A · S/N 72610N2486UPiper PA-34-200T · S/N 34-7970446N262SPBeech 300 · S/N FA-33N269WTCessna 340 · S/N 340-0104N272MCMitsubishi MU-2B-25 · S/N 272N273SMPilatus PC-12/45 · S/N 475N2860FCessna 182J · S/N 18256960N3061DCessna 310 · S/N 35261N3397QPiper PA-28R-201T · S/N 28R-7703106N339JSNoel Simmons RV-7A · S/N 72238N343WHaines Bradford GLASTAR · S/N 5621N39744Piper PA-32RT-300T · S/N 32R-7887159N40905Piper PA-28R-200 · S/N 28R-7435140N42XXSanger Ross A PITTS SPECIAL S-1S · S/N 7-0030N4349JPiper PA-28-180 · S/N 28-2749N46469Wengel Carl ODYSSEY · S/N 001N499PARaytheon HAWKER 800XP · S/N 258739N516CSCessna 172R · S/N 17280428N5182DCessna 182A · S/N 51282N53LSRolladen-Schneider OHG LS3-A · S/N 3332N542PJCanadian Car & Foundry HARVARD IV · S/N CCF-4-542N59294Cessna TU206F · S/N U20602645N5935VPiper PA-28R-201T · S/N 28R-7703169N60MTCessna 525C · S/N 525C0152N619MTCirrus Design SR22T · S/N 1119N694RSSnarr Randy L LANCAIR 235/320 · S/N 105N724LBuck Gary PULSAR III · S/N 007N734KSBurkhart Grob Flugzeugbau SPEED ASTIR II B · S/N 4073N740VPPeters Victor N MARK III XTRA · S/N M3X03100040N74101Grumman American Avn. AA-5B · S/N AA5B-0137N7457QCessna 182P · S/N 18261097N75931Cessna 172N · S/N 17268053N759APCessna 182Q · S/N 18265841N777VARice Knowlton P VOLANTE · S/N 1N8056MCessna 310I · S/N 310I0056N837KTBeech C23 · S/N M-2076N86763Bellanca 14-13 · S/N 1124N886GTAirbus Helicopters AS350B3 · S/N 8091N8888ABeech C35 · S/N D-3211N889GTAirbus Helicopters AS350B3 · S/N 8011N8934ZCessna 310G · S/N 310G-0034N9151YMooney M20J · S/N 24-3366Registration pending
Back to South Jordan, UT