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.
N541GJBombardier CL-600-2C11 · S/N 10238N542GJBombardier CL-600-2C11 · S/N 10266N543GJBombardier CL-600-2C11 · S/N 10256N544GJBombardier CL-600-2C11 · S/N 10257N545GJBombardier CL-600-2C11 · S/N 10255N545MAPiper PA-28-181 · S/N 2843865N547GJBombardier CL-600-2C11 · S/N 10272N548GJBombardier CL-600-2C11 · S/N 10273N549GJBombardier CL-600-2C11 · S/N 10280N551GJBombardier CL-600-2C11 · S/N 10283N552GJBombardier CL-600-2C11 · S/N 10287N553GJBombardier CL-600-2C11 · S/N 10296N554GJBombardier CL-600-2C11 · S/N 10297N55791Cessna T337G · S/N P337-0085N557KFJoel Brett Taylor KITFOX SS7 · S/N KA14278300N5595ECessna 172N · S/N 17271897N562AGPiper PA-28-181 · S/N 2881814N5699PPiper PA-24-250 · S/N 24-772N56SYSD Young INV ZENITH 750 STOL · S/N 75-12030N582WLLewis William R AIR COMMND COM ELITE · S/N WRL001N58CVVans RV-12 · S/N 121028N5943WPiper PA-28-150 · S/N 28-3482N597AGPiper PA-28-181 · S/N 2881756N5YVCirrus Design SR22T · S/N 1491N600NMPiper PA-46-600TP · S/N 4698182N603SKBombardier CL-600-2C11 · S/N 10248N604SKBombardier CL-600-2C10 · S/N 10249N606ERBeech 19A · S/N MB-397N609SKBombardier CL-600-2C10 · S/N 10020N611SKBombardier CL-600-2C10 · S/N 10035N612QXBombardier CL-600-2C10 · S/N 10042N613SKBombardier CL-600-2C10 · S/N 10038N614QXBombardier CL-600-2C10 · S/N 10049N614SKBombardier CL-600-2C10 · S/N 10051N625CABombardier CL-600-2C10 · S/N 10113N626SYEmbraer S A ERJ 170-200 LL · S/N 17000974N627SYEmbraer S A ERJ 170-200 LL · S/N 17000980N630SKBombardier CL-600-2C10 · S/N 10328N630SYEmbraer S A ERJ 170-200 LL · S/N 17000996N631SKBombardier CL-600-2C10 · S/N 10329N631SYEmbraer S A ERJ 170-200 LL · S/N 17000999N632SKBombardier CL-600-2C10 · S/N 10330N632SYEmbraer S A ERJ 170-200 LL · S/N 17001003N633SKBombardier CL-600-2C10 · S/N 10331N634SYEmbraer S A ERJ 170-200 LL · S/N 17001004N635SYEmbraer S A ERJ 170-200 LL · S/N 17001012N637SYEmbraer S A ERJ 170-200 LL · S/N 17001018N638AGCessna 172S · S/N 172S11464N638DSDiamond Aircraft Ind DA 40 · S/N 40.738N638SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0636
Back to St George, UT