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.
N1482BTextron 525 · S/N 525-0888N148SYEmbraer S A ERJ 170-200 LR · S/N 17000492N149BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0633N149SYEmbraer S A ERJ 170-200 LR · S/N 17000495N150RWCessna 150E · S/N 15060875N150SYEmbraer S A ERJ 170-200 LR · S/N 17000499N151JAeropro CZ A220 · S/N 37513N151SYEmbraer S A ERJ 170-200 LR · S/N 17000503N152SYEmbraer S A ERJ 170-200 LR · S/N 17000549N153SYEmbraer S A ERJ 170-200 LR · S/N 17000553N1541HCessna 177RG · S/N 177RG0715N154BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0634N154STSkytrails Lsa PREDATOR · S/N P582E40515N154SYEmbraer S A ERJ 170-200 LR · S/N 17000556N156PSDiamond Aircraft Ind DA 40 · S/N 40.492N156SYEmbraer ERJ 170-200 LR · S/N 17000557N157SYEmbraer S A ERJ 170-200 LR · S/N 17000558N15UTPzl-Mielec SB-LIM2 (MIG 15 UTI) · S/N 522546N160SYEmbraer ERJ 170-200 LR · S/N 17000568N161STSkytrails Lsa PREDATOR · S/N P582E40520N161SYEmbraer ERJ 170-200 LR · S/N 17000569N162SYEmbraer S A ERJ 170-200 LR · S/N 17000576N163SYEmbraer S A ERJ 170-200 LR · S/N 17000577N164SYEmbraer ERJ 170-200 LR · S/N 17000603N165SYEmbraer S A ERJ 170-200 LR · S/N 17000613N166SYEmbraer S A ERJ 170-200 LR · S/N 17000615N167SYEmbraer S A ERJ 170-200 LR · S/N 17000616N168SYEmbraer S A ERJ 170-200 LR · S/N 17000617N169AGPiper PA-28-181 · S/N 2881810N170SYEmbraer S A ERJ 170-200 LR · S/N 17000483N172KSCessna 172S · S/N 172S9481N173SYEmbraer S A ERJ 170-200 LR · S/N 17000486N174SYEmbraer S A ERJ 170-200 LR · S/N 17000517N175AGPiper PA-28-181 · S/N 2881753N175SYEmbraer S A ERJ 170-200 LR · S/N 17000527N176SYEmbraer S A ERJ 170-200 LR · S/N 17000533N177SYEmbraer S A ERJ 170-200 LR · S/N 17000535N178SYEmbraer S A ERJ 170-200 LR · S/N 17000555N181SYEmbraer S A ERJ 170-200 LR · S/N 17000574N182SYEmbraer S A ERJ 170-200 LR · S/N 17000579N183SYEmbraer S A ERJ 170-200 LR · S/N 17000589N184SYEmbraer S A ERJ 170-200 LR · S/N 17000590N187SYEmbraer S A ERJ 170-200 LR · S/N 17000627N188SYEmbraer S A ERJ 170-200 LR · S/N 17000628N189SYEmbraer S A ERJ 170-200 LR · S/N 17000631N191SYEmbraer S A ERJ 170-200 LR · S/N 17000632N192SYEmbraer S A ERJ 170-200 LR · S/N 17000638N195MAPiper PA-28-181 · S/N 2881029N195SYEmbraer S A ERJ 170-200 LR · S/N 17000698N196SYEmbraer S A ERJ 170-200 LR · S/N 17000706
Back to St George, UT