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.
N261SYEmbraer ERJ 170-200 LR · S/N 17000704N262SYEmbraer S A ERJ 170-200 LL · S/N 17000714N263SYEmbraer S A ERJ 170-200 LL · S/N 17000715N264SYEmbraer S A ERJ 170-200 LL · S/N 17000716N265SYEmbraer S A ERJ 170-200 LL · S/N 17000717N2664UCessna 182S · S/N 18280298N267SYEmbraer S A ERJ 170-200 LL · S/N 17000722N268SYEmbraer S A ERJ 170-200 LL · S/N 17000725N269SYEmbraer S A ERJ 170-200 LL · S/N 17000727N270SYEmbraer S A ERJ 170-200 LL · S/N 17000728N271SYEmbraer S A ERJ 170-200 LL · S/N 17000729N272SFHonda HA-420 · S/N 42000111N272SYEmbraer S A ERJ 170-200 LL · S/N 17000734N273SYEmbraer S A ERJ 170-200 LL · S/N 17000735N274SYEmbraer S A ERJ 170-200 LL · S/N 17000736N276AGPiper PA-28-181 · S/N 2881811N276SYEmbraer S A ERJ 170-200 LL · S/N 17000740N277SYEmbraer S A ERJ 170-200 LL · S/N 17000741N27808Cessna 172L · S/N 17260023N278SYEmbraer S A ERJ 170-200 LL · S/N 17000742N279SYEmbraer S A ERJ 170-200 LL · S/N 17000743N27WFCirrus Design SR20 · S/N 2598N280SYEmbraer S A ERJ 170-200 LL · S/N 17000745N281SYEmbraer S A ERJ 170-200 LL · S/N 17000746N281TWPiper PA-28-181 · S/N 2881091N282SYEmbraer S A ERJ 170-200 LL · S/N 17000747N2838APowrachute PEGASUS 912 · S/N A 136 PEGN283SYEmbraer S A ERJ 170-200 LL · S/N 17000748N284SYEmbraer S A ERJ 170-200 LL · S/N 17000750N285SYEmbraer S A ERJ 170-200 LL · S/N 17000751N286PAPiper PA-44-180 · S/N 4496109N286SYEmbraer S A ERJ 170-200 LL · S/N 17000752N287PAPiper PA-44-180 · S/N 4496110N287SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0595N287SYEmbraer S A ERJ 170-200 LL · S/N 17000753N288PAPiper PA-28-181 · S/N 2843502N288SYEmbraer S A ERJ 170-200 LL · S/N 17000754N289SYEmbraer S A ERJ 170-200 LL · S/N 17000756N290SYEmbraer S A ERJ 170-200 LL · S/N 17000758N291SYEmbraer S A ERJ 170-200 LL · S/N 17000759N292PAPiper PA-44-180 · S/N 4496116N294SYEmbraer S A ERJ 170-200 LR · S/N 17000792N295SYEmbraer S A ERJ 170-200 LR · S/N 17000793N296SYEmbraer S A ERJ 170-200 LR · S/N 17000797N299CFDouglas G Matthews VANS AIRCRAFT RV-4 · S/N 4030Registration pendingN299SYEmbraer S A ERJ 170-200 LL · S/N 17000833N300RGGrumman American Avn. AA-5A · S/N AA5A-0159N300SYEmbraer S A ERJ 170-200 LL · S/N 17000837N3013TArbc Inc DBA Lindstrand 180A · S/N 5453N301SYEmbraer S A ERJ 170-200 LL · S/N 17000838
Back to St George, UT