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.

N57612Hiller OH-23B · S/N 5116245Cancelled May 11, 1994 · Triennial form not returned · Aviation Maintenance TechnologyN45QGulfstream AM Corp Comm Div 690C · S/N 11623Cancelled Apr 26, 1994 · Triennial form not returned · Bowhead Equipment CompanyN1406YCessna 172C · S/N 17249106Cancelled Mar 15, 1994 · Triennial form not returned · Roulier Brent L DBAN458TMBoeing 737-200 · S/N 21355Cancelled Feb 14, 1994 · Exported to Oman · Boeing CoN8016UDouglas DC-8-21 · S/N 45590Cancelled Feb 2, 1994N8023UDouglas DC-8-21 · S/N 45292Cancelled Feb 2, 1994N7584FChampion 7ECA · S/N 74070Cancelled Jan 31, 1994 · Triennial form not returned · Aviators Acft Ownership Program IncN115FRCessna 172P · S/N 17275261Cancelled Jan 19, 1994 · Triennial form not returned · Van Pelt WilberN202EBEmbraer EMB-110P1 · S/N 110403Cancelled Jan 3, 1994 · Exported to Venezuela · Pacific Coast Lease CorporationN7036LLau Alvin F EVANS VP-1 · S/N V2477Cancelled Oct 26, 1993 · Lau Alvin FN9148WPiper PA-28-235 · S/N 28-10772Cancelled Oct 18, 1993 · Hartley Daniel BN501RPAerospatiale AS350B1 ECUREUIL · S/N 2212Cancelled Sep 16, 1993 · Exported to Norway · Finning IncN6291KRepublic RC-3 · S/N 504Cancelled Mar 23, 1993 · Back Forty IncN9715KStinson 108-2 · S/N 1082715Cancelled Mar 8, 1993 · Triennial form not returned · King Floyd W JrN734EHCessna TU206G · S/N U20604827Cancelled Feb 19, 1993 · Triennial form not returned · Mendel Robert AN62036Cessna 172P · S/N 17275200Cancelled Jan 28, 1993 · Puget Sound Helicopters IncN901AEmbraer EMB-110P1 · S/N 110293Cancelled Jan 15, 1993 · Exported to Venezuela · Pacific Coast Lease CorporationN2859MPiper PA-34-200T · S/N 347870097Cancelled Nov 10, 1992 · Triennial form not returned · Pioneer LeasingN2631VRobinson Helicopter R22 BETA · S/N 0776Cancelled Oct 26, 1992 · Triennial form not returned · Walling KarenN267QEnstrom 280 · S/N 1008Cancelled Oct 23, 1992 · Triennial form not returned · Puget Sound Helicopters IncN63496Cessna 172P · S/N 17275443Cancelled Sep 24, 1992 · Triennial form not returned · Flight Tech IncN9015SBeech S35 · S/N D7947Cancelled Sep 14, 1992 · Henry John M DBAN182PKCessna TR182 · S/N R18201330Cancelled Apr 16, 1992 · Exported to Canada · Steele Larry RN177GMBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1723Cancelled Apr 3, 1992 · Exported to Canada · Gerada David JN5317GDehavilland BEAVER DHC-2 MK.1 · S/N 617Cancelled Mar 31, 1992 · Lake Union Air IncN8415LRobinson Helicopter R22 · S/N 0316Cancelled Mar 27, 1992 · Exported to Switzerland · Kenn Borek Air IncN8032MRobinson Helicopter R22 BETA · S/N 1021Cancelled Mar 26, 1992 · Exported to Switzerland · Kenn Borek Air IncN55921Dehavilland DHC-6-300 · S/N 650Cancelled Feb 21, 1992 · Exported to Canada · Kenn Borek Air IncN8034JRobinson Helicopter R22 BETA · S/N 1051Cancelled Jan 14, 1992 · Exported to Australia · Walling Karen LN348PKKing Peter B TIERRA II · S/N 3488509Cancelled Dec 31, 1991 · Triennial form not returned · King Peter BN455CACannon B/Lewis D G RV 4 180 · S/N 1869Cancelled Dec 23, 1991 · Triennial form not returned · Cannon Boyce DN55841Piper PA-28-140 · S/N 287325501Cancelled Nov 26, 1991 · Triennial form not returned · Robinette Thomas AN1537PBalloon Works FIREFLY 7 · S/N 10184Cancelled Nov 13, 1991 · Triennial form not returned · Rickert Allen EN500KBBeech 200 · S/N BB29Cancelled Nov 7, 1991 · Exported to Canada · Kenn Borek Air IncN26263Robinson Helicopter R22 BETA · S/N 0741Cancelled Oct 28, 1991 · Exported to CanadaN2460PRobinson Helicopter R22 BETA · S/N 0586Cancelled Oct 1, 1991 · Triennial form not returned · Classic Helicopter CorporationN17795Beech 58P · S/N TJ95Cancelled Aug 29, 1991 · Second triennial mailing, no response · Martin Kenneth LN3768XAero Commander 100 · S/N 260Cancelled Aug 21, 1991 · Triennial form not returned · Hubert David LN3625THughes 269C · S/N S1181Cancelled Jun 19, 1991 · Exported to Spain · Mitsui And Co USA IncN4364Stits SA7D · S/N P481Cancelled May 13, 1991 · Triennial form not returned · Barth Ervin JN11HHCessna U206 · S/N U2060440Cancelled Apr 25, 1991 · Exported to Canada · Tuller Rollan EN29ZHess Richard W RUTAN VARI-EZE · S/N 1241Cancelled Mar 28, 1991 · Triennial form not returned · Terry Daniel HN329ALLau Alvin F TENNIE TWO · S/N 151743Cancelled Mar 28, 1991 · Triennial form not returned · Lau Alvin FN9473LAmerican AA-1A · S/N AA1A0273Cancelled Nov 21, 1990 · Triennial form not returned · Barth Ervin JN874UMBoeing 727-228 · S/N 19863Cancelled May 19, 1989 · Exported to Turkey · Sbg Overseas Leasing IncN775BEBoeing 727-200 · S/N 20727Cancelled Nov 2, 1987 · Exported to Venezuela · Boeing Equipment Holding CoN774BEBoeing 727-200 · S/N 20878Cancelled Oct 8, 1987 · Exported to Venezuela · Boeing Equipment Holding CoN773BEBoeing 727-281 · S/N 20877Cancelled Jul 2, 1987 · Exported to Venezuela · Boeing Equipment Holding CoN772BEBoeing 727-200 · S/N 20876Cancelled Jun 4, 1987 · Exported to Venezuela · Boeing Equipment Holding CoN771BEBoeing 727-200 · S/N 20724Cancelled Dec 5, 1986 · Exported to Venezuela · Boeing Equipment Holding Co
Back to Seattle, WA