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.

N801SYBoeing 737-8Q8 · S/N 30332Built 2001 · Minneapolis, MNN804SYBoeing 737-8Q8 · S/N 30689Built 2001 · Minneapolis, MNN805SYBoeing 737-8Q8 · S/N 30032Built 2001 · Minneapolis, MNN808SYBoeing 737-8BK · S/N 33021Built 2005 · Minneapolis, MNN809SYBoeing 737-8Q8 · S/N 30683Built 2005 · Minneapolis, MNN813SYBoeing 737-8Q8 · S/N 28237Built 2001 · Minneapolis, MNN814SYBoeing 737-8BK · S/N 30620First renewal noticeBuilt 2001 · Minneapolis, MNN816SYBoeing 737-8Q8 · S/N 30637Built 2001 · Minneapolis, MNN819SYBoeing 737-86N · S/N 34254Built 2006 · Minneapolis, MNN822SYBoeing 737-8BK · S/N 33017Built 2004 · Minneapolis, MNN823SYBoeing 737-800 · S/N 33971Minneapolis, MNN824SYBoeing 737-800 · S/N 33976Built 2005 · Minneapolis, MNN825SYBoeing 737-8F2 · S/N 34410Built 2006 · Minneapolis, MNN826SYBoeing 737-8F2 · S/N 34411Built 2006 · Minneapolis, MNN827SYBoeing 737-8F2 · S/N 34412Built 2006 · Minneapolis, MNN828SYBoeing 737-8F2 · S/N 34413Built 2006 · Minneapolis, MNN829SYBoeing 737-8F2 · S/N 34414Built 2006 · Minneapolis, MNN830SYBoeing 737-83N · S/N 30706Built 2001 · Minneapolis, MNN831SYBoeing 737-83N · S/N 28249Built 2002 · Minneapolis, MNN835SYBoeing 737-8KN · S/N 40250Built 2011 · Minneapolis, MNN836SYBoeing 737-8KN · S/N 40251Built 2012 · Minneapolis, MNN837SYBoeing 737-8KN · S/N 40252First renewal noticeBuilt 2012 · Minneapolis, MNN838SYBoeing 737-86N · S/N 32733Built 2002 · Minneapolis, MNN841SYBoeing 737-8JP · S/N 40865Built 2010 · Minneapolis, MNN842SYBoeing 737-8K5 · S/N 37244Built 2012 · Minneapolis, MNN844SYBoeing 737-8K5 · S/N 37240Built 2014 · Minneapolis, MNN845SYBoeing 737-82R · S/N 40727Built 2011 · Minneapolis, MNN846SYBoeing 737-8JP · S/N 39025Built 2013 · Minneapolis, MNN847SYBoeing 737-8JP · S/N 39028Built 2013 · Minneapolis, MNN848SYBoeing 737-8JP · S/N 41128Built 2015 · Minneapolis, MNN849SYBoeing 737-8JP · S/N 41131Built 2015 · Minneapolis, MNN851SYBoeing 737-8K5 · S/N 37256Built 2013 · Minneapolis, MNN852SYBoeing 737-89M · S/N 40910Built 2010 · Minneapolis, MNN901SYBoeing 737-91MER · S/N 40069Built 2014 · Minneapolis, MNN903SYBoeing 737-91MER · S/N 40070Built 2015 · Minneapolis, MNN904SYBoeing 737-91MER · S/N 44425Built 2015 · Minneapolis, MN
Back to Sun Country Inc