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.
N466SWBombardier CL-600-2B19 · S/N 7856N468CABombardier CL-600-2B19 · S/N 7649N471CABombardier CL-600-2B19 · S/N 7655N4729CCessna T210N · S/N 21063604N472TWTextron 172S · S/N 172S12517N479CABombardier CL-600-2B19 · S/N 7675N487CABombardier CL-600-2B19 · S/N 7729N492DSDiamond Aircraft Ind DA 40 · S/N 40.504N494CABombardier CL-600-2B19 · S/N 7765N498CABombardier CL-600-2B19 · S/N 7792N5006QAerostar International S-57S · S/N S57S-3009N501SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000882N502SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000883N5047QCessna 310N · S/N 310N-0147N504SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000885N506CABombardier CL-600-2B19 · S/N 7793N506SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000887N508SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000889N509Poland MIG 17 (LIM-5) · S/N 1C01509N509GJBombardier CL-600-2C11 · S/N 10153N509SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000890N510SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000891N511GJBombardier CL-600-2C11 · S/N 10128N511SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000892N512SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000893N513SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000894N5144XPiper PA-28-181 · S/N 2843430N515GJBombardier CL-600-2C10 · S/N 10089N515SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000896N516GJBombardier CL-600-2C11 · S/N 10245N516SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000897N517SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000898N5194DCessna 182A · S/N 51294N519SYYabora Industria Aeronautica S ERJ 170-200 LR · S/N 17000899N520SYEmbraer S A ERJ 170-200 LR · S/N 17000905N521GJBombardier CL-600-2C11 · S/N 10282N522GJBombardier CL-600-2C11 · S/N 10079N523GJBombardier CL-600-2C11 · S/N 10125N524GJBombardier CL-600-2C11 · S/N 10097N525STDiamond Aircraft Ind DA 40 · S/N 40.477N529GJBombardier CL-600-2C11 · S/N 10198N53339Piper PA-28-181 · S/N 2843469N534GJBombardier CL-600-2C11 · S/N 10225N5356XPiper PA-28-181 · S/N 2843521N5357NPiper PA-28-181 · S/N 2843519N536GJBombardier CL-600-2C11 · S/N 10224N537GJBombardier CL-600-2C11 · S/N 10237N539GJBombardier CL-600-2C11 · S/N 10230N5404NBoeing B75N1 · S/N 75-7247N540GJBombardier CL-600-2C11 · S/N 10253
Back to St George, UT