Morgan, 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 = 'MORGAN' 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 = 'MORGAN' 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.
N121VCSchempp-Hirth VENTUS-2C · S/N 17N12MVVallender Merrill J RV-4 · S/N 3671N13ULArizona Backcountry Avn CCX-1865 · S/N CCX-1865-1013N14299Piper PA-18-150 · S/N 18-7409064N1450WWood J Ralph KITFOX IV · S/N 1450N164SKKranik Ken J S6ES · S/N 01081858N17621Beech A36 · S/N E-992N1878JMatthew L Madorin/Robert L Bag RV-6 · S/N 24759N1916XCessna 182 · S/N 18256016N220AWDJI AGRAS T40 · S/N 1581F574B234C00100MMN23HGAviat A-1 · S/N 1269N2874ADJI AGRAS T40 · S/N 1581F574B234C00100UMN2922FCessna 182J · S/N 18257022N3321DCessna 180 · S/N 32119N3505MPiper PA-12 · S/N 12-2353N3551NPiper J3C-65 · S/N 22784N365DRRyan Pace ALASKAN 4X4 · S/N 002N393JTJohn R Lewis QUICKIE Q2 · S/N 2164N41MLRoyall Michael B F1 ROCKET · S/N 001N423DWDuffy Jim/Wagner Phil VANS RV-4 · S/N 3621N4399MPiper PA-12 · S/N 12-3339N4703MPiper PA-11 · S/N 11211N481SADiamond Aircraft Ind DA20-C1 · S/N C0786N482SADiamond Aircraft Ind DA20-C1 · S/N C0787N4884APiper PA-18A · S/N 18-4985N5066VVarga 2150A · S/N VAC5476N5070NBellanca 8KCAB · S/N 614-80N520DKKearsley Douglas EXEC 162 F · S/N 6776N569LZLyon Richard P LONG-EZ · S/N 1254N6144DPiper PA-22-150 · S/N 22-4788N614HHall Larry/Jed HEADWIND JD HW 17 · S/N 20A-614N616JWChristen Industries PITTS S-2B · S/N 5091N6273HPiper J3C-65 · S/N 19451N6382MStinson 108-3 · S/N 108-4382N644DCJoe Dory JR VANS RV-8 · S/N 80790N655XHall Larry D PAZMANY PL-9 · S/N 54N65RBRolladen-Schneider LS-4 · S/N 4208N66GRBanducci Gary RV-4 · S/N 102N6994KPiper PA-20 · S/N 20-102N6FDAmerican Champion 8KCAB · S/N 649-91N727GHCirrus Design SR22T · S/N 0509N7415VMooney M20C · S/N 20-1149N741DWTubbs S/Performance Air PA18WB225 · S/N PA0205N7519TCessna 172A · S/N 47119N75619Zenair CH-701 · S/N 117-9701ZN7600HCessna 182P · S/N 18261288N7718APiper PA-23-250 · S/N 27-7554040N77RJBeech M35 · S/N D-6533N8609WPiper PA-28-235 · S/N 28-10125N8636Scheibe L SPATZ III · S/N 821
Back to Morgan, UT