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.
N302PAPiper PA-44-180 · S/N 4496121N302SYEmbraer S A ERJ 170-200 LL · S/N 17000839N3036PCessna 162 · S/N 16200112N303SYYabora Industria Aeronautica S ERJ 170-200 LL · S/N 17000846N3044UPiper PA-28-181 · S/N 2843572N305SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000866N307SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000871N308SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000872N3107FCessna 182E · S/N 18253715N3108FCessna 172B · S/N 17248297N310LECessna 310 · S/N 35425N310SYEmbraer S A ERJ 170-200 LR · S/N 17000913N311SYEmbraer S A ERJ 170-200 LR · S/N 17000914N312SYEmbraer S A ERJ 170-200 LR · S/N 17000915N313JHCessna 310Q · S/N 310Q1011N3154FBeech B36TC · S/N EA-564N315SYEmbraer S A ERJ 170-200 LR · S/N 17000917N316SYEmbraer S A ERJ 170-200 LR · S/N 17000918N3177VCessna 150M · S/N 15076409N317PAPiper PA-44-180 · S/N 4496133N317SYEmbraer S A ERJ 170-200 LR · S/N 17000919N319SYEmbraer S A ERJ 170-200 LR · S/N 17000920N320SYEmbraer S A ERJ 170-200 LR · S/N 17000921N3216CBeech E35 · S/N D-3880N322SYEmbraer S A ERJ 170-200 LR · S/N 17000922N323SYEmbraer S A ERJ 170-200 LR · S/N 17000923N323WTRobinson Helicopter R44 II · S/N 14640N325SYEmbraer S A ERJ 170-200 LR · S/N 17000959N326MSBombardier CL-600-2D24 · S/N 15124N326SYEmbraer S A ERJ 170-200 LR · S/N 17000960N327SYEmbraer S A ERJ 170-200 LR · S/N 17000973N3284SPowrachute SKY RASCAL · S/N SR083N329MSBombardier CL-600-2D24 · S/N 15126N345AGPiper PA-28-181 · S/N 2881812N34949Cessna 177RG · S/N 177RG1030N3589YCessna 182F · S/N 18254489N35KCCouillard Kenneth A ZENAIR CH-300 · S/N 3-608N35KLPiper PA 46-350P · S/N 4636808N370SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0597N3950SCessna 172E · S/N 17251150N3961PPiper PA-22-150 · S/N 22-3639N396AGNew Piper PA-28-181 · S/N 28-43163N400SYEmbraer S A ERJ 170-200 LR · S/N 17000732N401PAPiper PA-28-181 · S/N 2843444N402SYEmbraer S A ERJ 170-200 LR · S/N 17000733N403SYEmbraer S A ERJ 170-200 LR · S/N 17000738N404AGPiper PA-28-181 · S/N 2881813N404EPCessna 172S · S/N 172S11436N404SYEmbraer S A ERJ 170-200 LR · S/N 17000739N405SYEmbraer S A ERJ 170-200 LR · S/N 17000744
Back to St George, UT