Registered aircraft · 20

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'MOUNTAIN GREEN' ORDER BY g.n_number

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 = 'MOUNTAIN GREEN'
  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 = 'MOUNTAIN GREEN'
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.

N124MKKamber Michael SPORTSMAN GS-2 · S/N 7345Built 2011 · Franklin Ronald Jeffrey N28EMCirrus Design SR22T · S/N 93929line LLC N3407CCessna 340 · S/N 340-0506Built 1974 · K&L Leasing And Investment LLC N3459SCessna 182H · S/N 18255859Built 1965 · Stg LLC N416BWWardropper Byron VANS RV-7A · S/N 73452Built 2010 · Kestrel Flying LLC N428JTRugg Ranches CCK-1865 · S/N CCK-1865-1018Built 2017 · Stolitude Adventures LLC N504TMMandorin Matthew Lowell RV-6 · S/N 23312Built 1999 · Madorin Matthew L N528JSFlight Design General Avn F2-LSA · S/N T-23-09-01Built 2025 · Jas Real Estate LLC N536CPCirrus Design SR22 · S/N 3036Registration pending, pending cancellation N562GTGeorge A Sousa RANS S-7S · S/N 0112572Built 2014 · Sousa George A N701GXEpic E1000 · S/N K047Built 2023 · 9line LLC N800JFFray Jerry D F1 ROCKET · S/N 100Built 2005 · Hawkes Darin M N8293RCessna TR182 · S/N R18200933Built 1979 · Panterra Aviation LLC N903BFGrandbear Air AIRCAM · S/N AC-312-3Grandbear Air LLC N904BFRamsdell Willis RV4 · S/N 3630Grandbear Air LLC N91245Cessna 180J · S/N 18052464Built 1974 · Delmonte Paul R N914BFPaul J Kanaly RV-14 · S/N 140166Built 2020 · Grandbear Air LLC N937MPipistrel VIRUS SW · S/N 376 VSW100Built 2011 · Supersonic LLC N9727TCessna 172A · S/N 47527Built 1960 · Rogers Bob N976BDStolitude Adventures CCK-2000 · S/N CCK-2000-0014Built 2023 · Stolitude Adventures LLC

Back to Mountain Green, UT