St George, UT
Registered aircraft · 675
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.
N104DGBrunner Donald G KITFOX · S/N LCS146N105RGCessna T240 · S/N T24002013N105SYEmbraer S A ERJ 170-200 LL · S/N 17000395N106SYEmbraer S A ERJ 170-200 LR · S/N 17000399N107SYEmbraer S A ERJ 170-200 LR · S/N 17000400N108SYEmbraer S A ERJ 170-200 LL · S/N 17000401N109SYEmbraer S A ERJ 170-200 LR · S/N 17000404N10URCessna 180 · S/N 32184N110SYEmbraer S A ERJ 170-200 LL · S/N 17000405N113SYEmbraer S A ERJ 170-200 LL · S/N 17000407N114SYEmbraer ERJ 170-200 LR · S/N 17000410N115MJMikoyan/Hansen Albert C MIG 15 BIS · S/N 03274N116SYEmbraer S A ERJ 170-200 LL · S/N 17000411N117BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0614N117SYEmbraer S A ERJ 170-200 LR · S/N 17000416N117VAVulcanair S P A VULCANAIR V1.0 · S/N 1006N118BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0615N118SYEmbraer S A ERJ 170-200 LR · S/N 17000420N1192TAmerican General Acft AG5B · S/N 10034N120HBVans RV-12 · S/N 120794N120SYEmbraer S A ERJ 170-200 LR · S/N 17000425N121REPiper PA 46-350P · S/N 4636718N121SYEmbraer S A ERJ 170-200 LR · S/N 17000430N124BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0617N124SYEmbraer S A ERJ 170-200 LR · S/N 17000439N125SYEmbraer S A ERJ 170-200 LR · S/N 17000440N127SYEmbraer S A ERJ 170-200 LR · S/N 17000441N128SYEmbraer S A ERJ 170-200 LR · S/N 17000445N129UAero Vodochody L-29C · S/N 294897N130BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0619N131SYEmbraer S A ERJ 170-200 LR · S/N 17000450N132SYEmbraer S A ERJ 170-200 LR · S/N 17000451N133SYEmbraer S A ERJ 170-200 LR · S/N 17000452N134BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0620N134SYEmbraer S A ERJ 170-200 LR · S/N 17000458N135BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0621N135RCCocozzoli Kevin A GLASAIR 3 · S/N 3335N135SYEmbraer S A ERJ 170-200 LR · S/N 17000460N136SYEmbraer S A ERJ 170-200 LR · S/N 17000462N138SYEmbraer S A ERJ 170-200 LR · S/N 17000466N139DADiamond Aircraft Ind DA20-C1 · S/N C0619N139SYEmbraer S A ERJ 170-200 LR · S/N 17000468N13TMMooney M20D · S/N 115N140BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0624N142SYEmbraer S A ERJ 170-200 LR · S/N 17000475N143SYEmbraer S A ERJ 170-200 LR · S/N 17000476N144SYEmbraer S A ERJ 170-200 LR · S/N 17000482N145SYEmbraer S A ERJ 170-200 LR · S/N 17000484N146SYEmbraer S A ERJ 170-200 LR · S/N 17000491N147BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0631
Back to St George, UT