St George, UT
Registered aircraft · 677
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 = 'ST GEORGE' 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 = 'ST GEORGE' 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.
N406SYEmbraer S A ERJ 170-200 LR · S/N 17000900N408SYEmbraer S A ERJ 170-200 LR · S/N 17000902N409SYEmbraer S A ERJ 170-200 LR · S/N 17000903N411SYEmbraer S A ERJ 170-200 LR · S/N 17000907N412SYEmbraer S A ERJ 170-200 LR · S/N 17000908N4131TPiper PA-28-181 · S/N 2843216N413SYEmbraer S A ERJ 170-200 LR · S/N 17000909N413VRVashon RANGER R7 · S/N 10262N4143APiper PA-28-181 · S/N 2843217N4144XPiper PA-28-181 · S/N 2843267N41487Piper PA-28-181 · S/N 2843179N4148DPiper PA-28-181 · S/N 2843170N414SYEmbraer S A ERJ 170-200 LR · S/N 17000910N4167KPiper PA-28-181 · S/N 2843342N416PAPiper PA-28-181 · S/N 2843438N418PAPiper PA-28-181 · S/N 2843414N419PAPiper PA-28-181 · S/N 2843413N42124Cessna 182L · S/N 18258864N424PAPiper PA-28-181 · S/N 2843468N427KCNanchang China CJ-6A · S/N 4332003N429TPDiamond Aircraft Ind DA 42 · S/N 42.090N430SWBombardier CL-600-2B19 · S/N 7523N430SYEmbraer S A ERJ 170-200 LR · S/N 17000911N431SYEmbraer S A ERJ 170-200 LR · S/N 17001025N433MAPiper PA-28-181 · S/N 28-43362N434AHCessna 172S · S/N 172S11456N435GGEpic E1000 · S/N K116N435KFPeter-Jonathan Christian Moore KITFOX 7 STI · S/N KA20331471N436AGCessna 172S · S/N 172S11457N441SWBombardier CL-600-2B19 · S/N 7602N4421BBac Jet Provost P84 T3A · S/N PACW11803N4427QHunting Percival P84 JET PROVOST T3 · S/N PACW 6328N442SWBombardier CL-600-2B19 · S/N 7609N445PAPiper PA-28-181 · S/N 2843500N447SWBombardier CL-600-2B19 · S/N 7677N448SWBombardier CL-600-2B19 · S/N 7678N449SWBombardier CL-600-2B19 · S/N 7699N450EZBassen/Acheson RUTAN VARIEZE · S/N 2165N452SWBombardier CL-600-2B19 · S/N 7716N453SWBombardier CL-600-2B19 · S/N 7743N454SWBombardier CL-600-2B19 · S/N 7749N455SWBombardier CL-600-2B19 · S/N 7760N457AGPiper PA-28-181 · S/N 2881757N457SWBombardier CL-600-2B19 · S/N 7773N457TLDiamond Aircraft Ind DA 40 · S/N 40.572N461SWBombardier CL-600-2B19 · S/N 7811N463SWBombardier CL-600-2B19 · S/N 7820N464SWBombardier CL-600-2B19 · S/N 7827N4658JJorgensen Max CCK-2000 · S/N CCK-2000-0132N465SWBombardier CL-600-2B19 · S/N 7845
Back to St George, UT