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.

N7089CPiper PA-34-200T · S/N 34-7670087Cancelled Dec 2, 2014 · Revoked, canceled · Built 1975 · Triple Three Flyers IncN97909Stinson 108-1 · S/N 108-909Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1946 · Taylor Don GN410JPTest TST-10 M · S/N 10010503Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 2003 · Patton Joseph DN1814Vanvoorhees John L JEANNIES TEENY TWO · S/N 001Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Van Voorhees JohnN9008EMaule M-5-235C · S/N 7058CCancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1976 · Robert E JonesN9043FHughes 369HS · S/N 990121SCancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1969 · Olympic Helicopter Leasing CorpN756LUCessna U206G · S/N U20604183Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1977 · Ongaro Michael AndN736TBoeing 720-027 · S/N 18064Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1961 · Eisenberg Ian KarlN738HUCessna 172N · S/N 17269997Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · Lee Stephen WN6922RCessna T210H · S/N T210-0322Cancelled Nov 14, 2014 · Registration expired, pending cancellation · Ravens LimitedN6395GCessna 150K · S/N 15071895Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1970 · Fancher ChrisN66811Beech A36TC · S/N EA-42Cancelled Nov 5, 2014 · Registration expired, pending cancellation · Built 1979 · F W A CompanyN57396Bellanca 7GCBC · S/N 489-73Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1973 · Ryan ElaineN5584ECessna 150 · S/N 17084Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1958 · O Neal DouglasN4940VSorrell PEER GYNT · S/N 1Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1954 · Bowers Peter MN4458EPiper PA-38-112 · S/N 38-78A0613Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1978 · Kluherz Robert KN619HAHispano Aviacion HA-200 SAETA · S/N A.10A-19Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Avstar IncN3526VCessna 150M · S/N 15076535Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1975 · Jones JuliannaN37684Mathes KR-2 · S/N 527048243Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1979 · Nowak Donald RN27ANBeech 95 · S/N TD-194Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1959 · Air Adventures InN28192Piper J-3 · S/N 4641Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1940 · Kurtzer Lana RN1969UCessna TU206F · S/N U20602314Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1974 · Lead Company IncN1053RSaurwein Albert C HIGH FLIER-1 · S/N 001Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Saurwein A CN1478JRockwell International 112TC · S/N 478Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1976 · Sullivan George PN1294ZBeech 95-55 · S/N TC-112Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1961 · Smith Harriette GN69966Frenard EXPERIMENTAL · S/N 8001Cancelled Sep 3, 2014 · Revoked, canceled · Built 1948 · Glenn Richard LN20RSRaven S-50A · S/N S50A-251Cancelled Aug 27, 2014 · Revoked, canceled · San Juan Pool CorporationN9502NSpectrum Beaver RX-550 · S/N SB 22 66Cancelled Jun 4, 2014 · Third renewal notice · Atkinson Raymond SN928MEBoeing 717-200 · S/N 55194Cancelled Apr 16, 2014 · Exported to Australia · Bcc Equipment Leasing CorpN444JFFoy John P DURAND MARK-V · S/N 5Cancelled Apr 1, 2014 · Third renewal notice · Built 1984 · Museum Of Flight FoundationN927MEBoeing 717-200 · S/N 55193Cancelled Mar 5, 2014 · Exported to Australia · Bcc Equipment Leasing CorpN356BJBoeing 737-7ES · S/N 33962Cancelled Feb 3, 2014 · Exported to Turkey · Built 2004 · Boeing CoN774BABoeing 747-8B5F · S/N 37655Cancelled Jan 27, 2014 · Exported to South Korea · Boeing CoN736DSBoeing 737-8FV · S/N 42250Cancelled Dec 27, 2013 · Boeing CoN957BABoeing 747-8B5 · S/N 37656Cancelled Dec 9, 2013 · Exported to South Korea · Boeing CoN942BABoeing 747-8KZF · S/N 36139Cancelled Dec 5, 2013 · Exported to Japan · Built 2013 · Boeing CoN959BABoeing 747-8HVF · S/N 37670Cancelled Dec 5, 2013 · Exported to Bermuda · Built 2013 · Boeing CompanyN52970Cessna 172P · S/N 17274647Cancelled Dec 4, 2013 · Exported to Guatemala · Built 1981 · Aeroflight Executive Services IncN800CECirrus Design SR22 · S/N 1812Cancelled Nov 25, 2013 · Exported to Canada · Built 2006 · Bright J TobiasN393DSBoeing 737-8FV · S/N 40610Cancelled Nov 21, 2013 · Exported to India · Built 2011 · Boeing CompanyN761ELCessna A152 · S/N A1520945Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1980 · Thompson Robet O JrN772BABoeing 747-8KZF · S/N 37394Cancelled Nov 7, 2013 · Exported to Japan · Built 2013 · Boeing CompanyN917MEBoeing 717-200 · S/N 55179Cancelled Nov 1, 2013 · Exported to Australia · Built 2004 · Bcc Equipment Leasing CorpN7543RPiper PA-28-140 · S/N 28-22105Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1966 · Garrett Jim RN1373Bowers Fly Baby 1-A · S/N 64-41Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1968 · Enochs Don E JrN4275NCessna 140 · S/N 13746Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1947 · Conover Mark AN406BCBoeing 717-200 · S/N 55178Cancelled Sep 27, 2013 · Exported to Australia · Bcc Equipment Leasing CorpN775BABoeing 747-8R7F · S/N 35822Cancelled Sep 23, 2013 · Exported to Luxembourg · Built 2013 · Boeing CoN7963Robinson Helicopter R22 BETA · S/N 3204Cancelled Sep 19, 2013 · Exported to Japan · Classic Helicopter CorpN88VVVan Valkenburgh R E DRAGONFLY · S/N 765Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Van Valkenburgh R E
Back to Seattle, WA