Seattle, WA

Cancelled registrations · 1,563

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'WA' AND d.registrant_city = 'SEATTLE'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N39HBMoravan Z242L · S/N 0733Cancelled Sep 10, 2008 · Exported to Czech Republic · Galvin Flying Services IncN950ALAgusta A109E · S/N 11628Cancelled Sep 5, 2008 · Triennial form not returned · Built 2004 · Airlift NorthwestN371BJBoeing 737-7DM · S/N 29971Cancelled Aug 29, 2008 · Built 2000 · Boeing CompanyN190MFOMF OMF-100-160 · S/N 0019Cancelled Aug 14, 2008 · Exported to Taiwan · Built 2002 · Voyager Aircraft LLCN200MVOMF OMF-100-160 · S/N 0020Cancelled Aug 14, 2008 · Exported to Taiwan · Built 2002 · Voyager Aircraft LLCN763TTBoeing 767-2FK · S/N 33844Cancelled Aug 12, 2008 · Exported to Japan · Built 2005 · Boeing CoN768TTBoeing 767-2FK · S/N 33958Cancelled Aug 12, 2008 · Exported to Japan · Built 2006 · Boeing CoN372BJBoeing 737-7HI · S/N 36108Cancelled Aug 1, 2008 · Exported to India · Boeing CoN738GUCessna 172N · S/N 17269973Cancelled Jul 21, 2008 · Exported to Indonesia · Built 1977 · Classic Helicopter CorpN812SYBoeing 737-8Q8 · S/N 35278Cancelled Jun 5, 2008 · Exported to Germany · Boeing CompanyN719BABoeing 737-7HI · S/N 36107Cancelled Apr 14, 2008 · Exported to India · Built 2007 · Boeing CoN4175UCessna 150D · S/N 15060175Cancelled Apr 9, 2008 · Triennial form not returned · Built 1963 · Werth Thomas AN260RVBell 206B · S/N 3379Cancelled Mar 6, 2008 · Exported to Canada · Built 1982 · Pacific Institute Aviation CorpN8688KCessna 340A · S/N 340A0619Cancelled Feb 13, 2008 · Built 1978 · Posluszny SteveN6275Scofield STARDUSTER II SA-200 · S/N 615Cancelled Jan 10, 2008 · Exported to United Kingdom · Built 1975 · Boggs Richard SN180CLPiper PA-28-180 · S/N 28-7205175Cancelled Dec 12, 2007 · Exported to Canada · Built 1972N370BJBoeing 737-7HI · S/N 36106Cancelled Oct 18, 2007 · Exported to India · Built 2006 · Boeing CompanyN6110TCessna R182 · S/N R18201906Cancelled Oct 1, 2007 · Triennial form not returned · Built 1982 · Shields SueN408HKHoac-Austria HK 36R · S/N 36408Cancelled Sep 26, 2007 · Exported to Australia · Built 1995 · Pc-12 Lessor LLCN704CRCessna 150M · S/N 15078510Cancelled Sep 25, 2007 · Exported to Canada · Built 1976 · Hylton J DN55NHYakovlev YAK-55M · S/N 920307Cancelled Sep 18, 2007 · Triennial form not returned · Built 1992 · Hernandez Ernest NN101KCDouglas DC3C · S/N 11639Cancelled Sep 4, 2007 · Exported to Brazil · Built 1943 · Boeing CoN735KPCessna 182Q · S/N 18265487Cancelled Aug 28, 2007 · Triennial form not returned · Built 1977 · Kennedy Bruce RtrusteeN366BJBoeing 737-7DM · S/N 34808Cancelled Aug 1, 2007 · Built 2006 · Boeing CoN36107Piper PA-34-200T · S/N 34-7870294Cancelled Jun 25, 2007 · Triennial form not returned · Built 1978 · Airpac Airlines IncN101FWAerospatiale AS350B · S/N 1018Cancelled May 21, 2007 · Exported to Canada · Classic Helicopter CorpN900ERBoeing 737-9GP · S/N 35680Cancelled May 9, 2007 · Exported to Indonesia · Built 2006 · Boeing CoN8728QCessna TU206F · S/N U20603481Cancelled Apr 26, 2007 · Exported to Mexico · Built 1976 · Mpb Denali LLCN369BJBoeing 737-8Z6 · S/N 35478Cancelled Apr 16, 2007 · Exported to Thailand · Boeing CompanyN721BABoeing 737-781 · S/N 33889Cancelled Apr 13, 2007 · N-number assigned, not yet registeredN365BJBoeing 737-7DM · S/N 34807Cancelled Mar 28, 2007 · Built 2006 · Boeing CoN2751SCessna 150G · S/N 15066651Cancelled Mar 6, 2007 · Exported to Canada · Built 1967N716BABoeing 737-781 · S/N 33879Cancelled Feb 14, 2007 · Exported to Japan · Built 2007 · Boeing CoN6394QCessna 152 · S/N 15285242Cancelled Dec 21, 2006 · Exported to Canada · Built 1981 · Shields Sue CN67828Cessna 152 · S/N 15285311Cancelled Dec 21, 2006 · Exported to Canada · Built 1981 · Shields Sue CN93916Cessna 152 · S/N 15285571Cancelled Dec 21, 2006 · Exported to Canada · Built 1982 · Shields Sue CN53411Boeing A75N1(PT17) · S/N 75-678Cancelled Sep 22, 2006 · Exported to Australia · Built 1941 · Tuck David WilliamN357RWRoberts Thomas RV-4 · S/N 4458Cancelled Sep 18, 2006 · Roberts Thomas GN4377XPiper PA-34-200T · S/N 34-7670035Cancelled Aug 7, 2006 · Triennial form not returned · Built 1975 · Airpac Airlines IncN26AVSmuz Anthony F SR RAF 2000 GTX SE · S/N H2-97-8-297Cancelled Aug 3, 2006 · Triennial form not returned · Built 2000 · Latah IncN37030Boeing-Vertol CH-47(352) · S/N MA014Cancelled Jul 20, 2006 · Exported to United Kingdom · Boeing CompanyN40104Boeing 727-2M1 · S/N 21091Cancelled Jul 12, 2006 · Exported to Senegal · Built 1975 · Boeing International Sales CorpN5250RCessna 172M · S/N 17263464Cancelled Jul 12, 2006 · Exported to Russia · Built 1974 · Pick Kenneth HN6852GCessna 150L · S/N 15072352Cancelled May 3, 2006 · Exported to Canada · Built 1970 · Gablehouse John AN54301Schweizer SGS 2-8 · S/N 15Cancelled Apr 24, 2006 · Triennial form not returned · Built 1941 · Seattle Glider Council IncN5525RCessna 172F · S/N 17253103Cancelled Mar 9, 2006 · Exported to Canada · Built 1965 · Skeith Maurice DN230UABoeing 777-222 · S/N 30227Cancelled Sep 26, 2005 · Boeing CompanyN3921SCessna 172E · S/N 17251121Cancelled Aug 4, 2005 · Exported to Canada · Built 1963 · Walkling Willard Paul IIIN8313QCessna U206F · S/N U20603174Cancelled Jun 21, 2005 · Exported to Mexico · Built 1976 · Carlson Clyde EN9640ZCessna U206G · S/N U20606591Cancelled May 18, 2005 · Exported to Canada · Built 1982 · Galvin Flying Services Inc
Back to Seattle, WA