Sun Country Inc
Registered aircraft · 36
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
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_name = 'SUN COUNTRY INC' OR list_contains(g.other_registrant_names, 'SUN COUNTRY INC') 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_name = 'SUN COUNTRY INC' OR list_contains(g.other_registrant_names, 'SUN COUNTRY INC') 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.
N801SYBoeing 737-8Q8 · S/N 30332N804SYBoeing 737-8Q8 · S/N 30689N805SYBoeing 737-8Q8 · S/N 30032N808SYBoeing 737-8BK · S/N 33021N809SYBoeing 737-8Q8 · S/N 30683N813SYBoeing 737-8Q8 · S/N 28237N814SYBoeing 737-8BK · S/N 30620First renewal noticeN816SYBoeing 737-8Q8 · S/N 30637N819SYBoeing 737-86N · S/N 34254N822SYBoeing 737-8BK · S/N 33017N823SYBoeing 737-800 · S/N 33971N824SYBoeing 737-800 · S/N 33976N825SYBoeing 737-8F2 · S/N 34410N826SYBoeing 737-8F2 · S/N 34411N827SYBoeing 737-8F2 · S/N 34412N828SYBoeing 737-8F2 · S/N 34413N829SYBoeing 737-8F2 · S/N 34414N830SYBoeing 737-83N · S/N 30706N831SYBoeing 737-83N · S/N 28249N835SYBoeing 737-8KN · S/N 40250N836SYBoeing 737-8KN · S/N 40251N837SYBoeing 737-8KN · S/N 40252First renewal noticeN838SYBoeing 737-86N · S/N 32733N841SYBoeing 737-8JP · S/N 40865N842SYBoeing 737-8K5 · S/N 37244N844SYBoeing 737-8K5 · S/N 37240N845SYBoeing 737-82R · S/N 40727N846SYBoeing 737-8JP · S/N 39025N847SYBoeing 737-8JP · S/N 39028N848SYBoeing 737-8JP · S/N 41128N849SYBoeing 737-8JP · S/N 41131N851SYBoeing 737-8K5 · S/N 37256N852SYBoeing 737-89M · S/N 40910N901SYBoeing 737-91MER · S/N 40069N903SYBoeing 737-91MER · S/N 40070N904SYBoeing 737-91MER · S/N 44425
Back to Sun Country Inc