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.
N197SYEmbraer S A ERJ 170-200 LR · S/N 17000709N1988GBurton James D RV-14A · S/N 140654N198SYEmbraer S A ERJ 170-200 LR · S/N 17000724N200SYEmbraer S A ERJ 170-200 LR · S/N 17000623N202LWPzl-Swidnik PW-5 · S/N 1706015N202SYEmbraer S A ERJ 170-200 LR · S/N 17000624N203SYEmbraer S A ERJ 170-200 LR · S/N 17000625N204SYEmbraer S A ERJ 170-200 LR · S/N 17000626N205SYEmbraer S A ERJ 170-200 LR · S/N 17000636N207SYEmbraer S A ERJ 170-200 LR · S/N 17000643N208SYEmbraer S A ERJ 170-200 LR · S/N 17000644N209SYEmbraer S A ERJ 170-200 LR · S/N 17000645N211SYEmbraer S A ERJ 170-200 LR · S/N 17000646N213SYEmbraer S A ERJ 170-200 LR · S/N 17000666N218PSBombardier CL-600-2B19 · S/N 7885N221VBSteven R Vanbatavia RV14A · S/N 140822N222LYBice Darrell W RV-9A · S/N 91629N223JSBombardier CL-600-2B19 · S/N 7892N224KPiper PA-24-250 · S/N 24-1609N225QTEmbraer Executive EMB-505 · S/N 50500878N228PSBombardier CL-600-2B19 · S/N 7897N22QQDiamond Aircraft Ind DA 40 · S/N 40.447N240SYEmbraer S A ERJ 170-200 LR · S/N 17000580N241CVMooney International M20V · S/N 33-0017N241SYEmbraer S A ERJ 170-200 LR · S/N 17000585N242SYEmbraer S A ERJ 170-200 LR · S/N 17000588N243SYEmbraer S A ERJ 170-200 LR · S/N 17000592N244LRBombardier CL-600-2D24 · S/N 15233N244SYEmbraer S A ERJ 170-200 LR · S/N 17000598N245LRBombardier CL-600-2D24 · S/N 15234N246LRBombardier CL-600-2D24 · S/N 15239N246PSBombardier CL-600-2B19 · S/N 7920N246SYEmbraer S A ERJ 170-200 LR · S/N 17000607N247SYEmbraer S A ERJ 170-200 LR · S/N 17000608N248LRBombardier CL-600-2D24 · S/N 15274N249LRBombardier CL-600-2D24 · S/N 15275N24TQBalony Kubicek Spol Sro BB30Z · S/N 871N250SYEmbraer S A ERJ 170-200 LR · S/N 17000610N251SYEmbraer S A ERJ 170-200 LR · S/N 17000611N253SYEmbraer S A ERJ 170-200 LR · S/N 17000620N254AGPiper PA-28-181 · S/N 2881754N254SYEmbraer S A ERJ 170-200 LR · S/N 17000621N2551LAtec Vos ATEC 322 FAETA · S/N F 340607 LSAN255SYEmbraer S A ERJ 170-200 LR · S/N 17000622N2567YDestiny XLT · S/N 3CO515N256SYEmbraer S A ERJ 170-200 LR · S/N 17000647N257SYEmbraer S A ERJ 170-200 LR · S/N 17000648N258SYEmbraer S A ERJ 170-200 LR · S/N 17000655N259SYEmbraer S A ERJ 170-200 LR · S/N 17000656N260SYEmbraer S A ERJ 170-200 LR · S/N 17000667
Back to St George, UT