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.

N4200TAero Commander 500-A · S/N 1074Cancelled Jun 12, 2012 · Revoked, canceled · Powell Richard AN3476DCessna 170B · S/N 27019Cancelled Jun 11, 2012 · Exported to Canada · Built 1955 · Howard James EN1244MCessna T337E · S/N 33701244Cancelled Jun 7, 2012 · Sale reported, canceled · Built 1969N1277NConsolidated PBY-5A · S/N 1793Cancelled May 24, 2012 · Revoked, canceled · Intercoastal Aircraft IncN4052EAeronca S11BC · S/N 11BC-140Cancelled May 24, 2012 · Revoked, canceled · Built 1947 · Lake Union Air Service IncN747EXBoeing 747-8R7F · S/N 35808Cancelled May 23, 2012 · Exported to Luxembourg · Built 2010 · Boeing CoN977TKBoeing 737-9F2ER · S/N 40977Cancelled May 23, 2012 · Exported to Turkey · Built 2012 · Boeing CompanyN507DSBoeing 737-8FV · S/N 40811Cancelled May 22, 2012 · Boeing CoN364BJBoeing 737-7ES · S/N 33987Cancelled May 21, 2012 · Exported to Australia · Built 2006 · Boeing CoN413NSBoeing 737-7ES · S/N 35328Cancelled May 17, 2012 · Exported to South Korea · Built 2010 · Boeing CoN58ZCook Bob FLYBIKE · S/N 1Cancelled May 11, 2012 · Registration expired, pending cancellation · Cook Bob RN8069QVanvoohrees John 004 PITBULL · S/N 004Cancelled May 11, 2012 · Registration expired, pending cancellation · Vanvoorhees John LN902MEBoeing 717-200 · S/N 55166Cancelled May 10, 2012 · Exported to Australia · Built 2003 · Bcc Equipment Leasing CorpN1757NCessna 120 · S/N 12001Cancelled May 4, 2012 · Exported to Canada · Built 1946 · Maclachlan Gordon SN1155CPiper PA-18-135 · S/N 18-2457Cancelled May 2, 2012 · Built 1953 · 208 CorpN398DSBoeing 737-8FV · S/N 40810Cancelled Apr 27, 2012 · Boeing CoN904MEBoeing 717-200 · S/N 55168Cancelled Apr 9, 2012 · Exported to Australia · Built 2003 · Bcc Equipment Leasing CorpN418BCBoeing 737-400 · S/N 27004Cancelled Mar 28, 2012 · Exported to Pakistan · Bcc Equipment Leasing CorpN2864PConsolidated Aeronautics LAKE LA-4-200 · S/N 930Cancelled Mar 21, 2012 · Sale reported, pending cancellation · Built 1978N9012YNorth American SNJ-5 · S/N 85061Cancelled Mar 20, 2012 · Exported to United Kingdom · Built 1944 · Clapp William HN2843XPiper PA-34-200T · S/N 34-7970272Cancelled Mar 9, 2012 · Sale reported, pending cancellation · Built 1979N50ADBeech U-8F · S/N 60-5388Cancelled Feb 10, 2012 · Registration pending, pending cancellationN397DSBoeing 737-8FV · S/N 40809Cancelled Feb 8, 2012 · Built 2011 · Boeing CoN4659F6-Chuter SKR2 1994 · S/N 94-1181-2Cancelled Jan 27, 2012 · First renewal notice · Built 1994 · Polinsky GaryN65766Dirdala Dumitru Nelu NELUSKYCAR · S/N 002Cancelled Jan 24, 2012 · Built 2006 · Dirdala Dumitru NeluN764TTBoeing 767-2EY · S/N 33688Cancelled Dec 20, 2011 · Exported to Italy · Built 2006 · Boeing CoN341FSBoeing 737-7ES · S/N 35327Cancelled Dec 13, 2011 · Exported to South Korea · Built 2009 · Boeing CoN759BABoeing 737-8AS · S/N 34995Cancelled Dec 12, 2011 · Exported to Ireland · Boeing CoN973TKBoeing 737-9F2ER · S/N 40973Cancelled Dec 8, 2011 · Exported to Turkey · Boeing CoN760BABoeing 737-8AS · S/N 35043Cancelled Dec 7, 2011 · Exported to Ireland · Boeing CoN974TKBoeing 737-9F2ER · S/N 40974Cancelled Dec 7, 2011 · Exported to Turkey · Built 2011 · Boeing CoN838AMMcdonnell Douglas DC-9-83(MD-83) · S/N 49397Cancelled Nov 23, 2011 · Exported to Mexico · Built 1986 · Boeing Capital CorporationN72WAero Commander 680-F · S/N 680F-1104-70Cancelled Nov 17, 2011 · First renewal notice · Built 1961 · South Seattle Community CollegeN2697WMooney M20C · S/N 3326Cancelled Nov 3, 2011 · Sale reported, pending cancellation · Built 1966N736JSBoeing 737-7DM · S/N 40706Cancelled Nov 1, 2011 · Exported to South Korea · Built 2011 · Boeing CompanyN767TTBoeing 767-2EY · S/N 33686Cancelled Oct 27, 2011 · Exported to Italy · Built 2003 · Boeing CoN358BJBoeing 737-7ES · S/N 33542Cancelled Oct 3, 2011 · Exported to Australia · Built 2002 · Boeing CoN7649ACessna 180H · S/N 18051970Cancelled Oct 3, 2011 · Exported to Canada · Built 1968 · Bottles Derek KN282SCCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 06SC006Cancelled Sep 21, 2011 · Built 2006 · Highlight Sport LLCN735JSBoeing 737-7ES · S/N 34700Cancelled Sep 21, 2011 · Exported to South Korea · Built 2009 · Boeing CompanyN441BABoeing 737-8AS · S/N 34992Cancelled Sep 20, 2011 · Exported to Ireland · Boeing CoN7235CBoeing 737-8AS · S/N 34988Cancelled Sep 20, 2011 · Exported to Ireland · Boeing CoN742BABoeing 737-8AS · S/N 34991Cancelled Sep 20, 2011 · Exported to Ireland · Boeing CoN392DSBoeing 737-8FV · S/N 40808Cancelled Aug 18, 2011 · Boeing CompanyN412BCBoeing 737-3K2 · S/N 24326Cancelled Aug 15, 2011 · Exported to Tajikistan · Bcc Mafolie Hill CoN111JCCessna 310K · S/N 310K-0208Cancelled Jul 21, 2011 · Sale reported, canceled · Built 1966N9183FBeech E50 · S/N 59-4990Cancelled Jul 20, 2011 · Registration pending, canceledN115MEBeech C-45H · S/N AF-253Cancelled Jun 29, 2011 · Registration pending, pending cancellationN124AHDiamond Aircraft Ind DA20-C1 · S/N C0436Cancelled Jun 8, 2011 · Exported to Turkey · Built 2007 · Flight Training Options LLCN2016Boswell EASY TWO · S/N EZIICancelled Jun 7, 2011 · Sale reported, pending cancellation · Built 1977
Back to Seattle, WA