Pleasant Grove, UT
Registered aircraft · 24
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 = 'PLEASANT GROVE' 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 = 'PLEASANT GROVE' 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.
N11GExtra Flugzeugproduktions UND EXTRA NG · S/N NG030N125CDTextron 525B · S/N 525B0710N125DGCessna 525B · S/N 525B0060N13KAAshby Kenny GLASAIR-SHA · S/N 413RN1637CCessna 180 · S/N 30337N23KAAshby Kenny GLASAIR III · S/N 3121N25FTextron T182T · S/N T18209165N262JSStevens Brian W HELICYCLE · S/N 2-11N28890Piper PA-28-181 · S/N 28-7990433N321PFDiamond Aircraft Ind DA 40 · S/N 40.375N35519Cessna 172I · S/N 17256810N3715VCessna 150M · S/N 15076597N3840NMooney M20F · S/N 680127N4514PStayton Barnes HELICYCLE · S/N 1-10DN484RSStevens Brian RANS S7S · S/N 1008516N506DCCombs Dale B RV-4 · S/N 001N558BBeech B-55 · S/N TC-2341N6921FCessna 150F · S/N 15063521N6RVTextron 208B · S/N 208B5929N729FLPiper PA-28-140 · S/N 28-7225488N7482LPiper PA-18-150 · S/N 18-7509083N798SBBombardier BD-100-1A10 · S/N 20679N850USocata TBM 700 · S/N 380N95BCAirbus Helicopters EC 130 T2 · S/N 8453
Back to Pleasant Grove, UT