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.

N985AMBoeing 737-823 · S/N 30901Cancelled Dec 12, 2001 · Exported to Australia · Boeing CompanyN379BJBoeing 737-8DR · S/N 32777Cancelled Nov 28, 2001 · Exported to United Kingdom · Built 2001 · Boeing CoN2062DBell 206B · S/N 3334Cancelled Oct 9, 2001 · Exported to New Zealand · Built 1981 · Aero Copters IncN9179TPiper PA-31 · S/N 31-782Cancelled Jul 16, 2001 · Exported to South Africa · Beswick Anthony JN8283GCessna 177RG · S/N 177RG0183Cancelled Jul 2, 2001 · Pailthorp Aaron CN373BJBoeing 737-7ED · S/N 32627Cancelled Jun 21, 2001 · Exported to South Africa · Boeing CoN5767VBeech A23-19 · S/N MB-51Cancelled Jun 19, 2001 · Triennial form not returned · Wilkens Henry CN788BABoeing 737-85F · S/N 30476Cancelled May 23, 2001 · Exported to South Africa · Boeing CoN235LPTriple S Aero LANCAIR IV P · S/N 235Cancelled Jan 10, 2001 · Triennial form not returned · Triple S Aero IncN4879BCessna 310 · S/N 35179Cancelled Dec 19, 2000 · Triennial form not returned · Kogle Roy GN7771Boeing 777-200 · S/N 27116Cancelled Dec 6, 2000 · Exported to China · Boeing CompanyN305BHMooney M20K · S/N 25-0260Cancelled Jul 20, 2000 · Triennial form not returned · Law Offices Of Bruce W Hilyer PsN817LDehavilland DHC-6-300 · S/N 817Cancelled Jul 20, 2000 · Exported to Angola · Flight Center Aircraft Sales LLCN821LDehavilland DHC-6-300 · S/N 821Cancelled Jul 14, 2000 · Exported to Angola · Flight Center Aircraft Sales LLCN29YLSchempp-Hirth DISCUS B · S/N 67Cancelled Apr 21, 2000 · Exported to Japan · Kreyche Thomas HN757XBoeing 757-330 · S/N 29016Cancelled Jun 22, 1999 · Exported to Germany · Boeing CompanyN30ADAero Commander 1121B · S/N 143Cancelled Jun 9, 1999 · Triennial form not returned · Washington State Dept Of TranspN92MKConsolidated Vultee LB-30 · S/N 55Cancelled May 13, 1999 · Morrison-Knudsen Co IncN257NWPiper PA-31-350 · S/N 317952014Cancelled Nov 9, 1998 · Triennial form not returned · Airpac Airlines IncN22654Lau Alvin F STOLP STARLIT · S/N 01A28Cancelled Oct 26, 1998 · Triennial form not returned · Lau Alvin FN903LEEmbraer EMB-110P1 · S/N 110397Cancelled Sep 2, 1998 · Exported to Canada · Kenn Borek Air IncN902LEEmbraer EMB-110P1 · S/N 110400Cancelled Aug 28, 1998 · Exported to Canada · Kenn Borek Air IncN8336QCessna TU206F · S/N U20603197Cancelled Mar 3, 1998 · Exported to Mexico · Cosgrave Ronald FN521DJDel Duca Dan J GOLDWING/STARFIRE · S/N 186Cancelled Feb 12, 1998 · Triennial form not returned · Del Duca Dan JN51816Cessna 402B · S/N 402B0816Cancelled Feb 4, 1998 · Triennial form not returned · Aeroflight Executive Services IncN644KStapleton William T RV-6 · S/N 217SSCancelled Jan 16, 1998 · Stapleton William TN852MADehavilland DHC-8-102 · S/N 349Cancelled Dec 3, 1997 · Exported to Canada · Rainier Aircraft Leasing IncN14MKLet BLANIK L-13 · S/N 175213Cancelled Oct 14, 1997 · Triennial form not returned · Evergreen SoaringN1456WBell 206A · S/N 388Cancelled Sep 26, 1997 · Exported to Mexico · Queen City HelicoptersN666HLPiper PA-34-200T · S/N 347770235Cancelled Sep 11, 1997 · Triennial form not returned · Airpac Airlines IncN6226MConvair 580 · S/N 477Cancelled May 23, 1997 · Department Of The NavyN81PHOmac OMAC I · S/N 002Cancelled Mar 14, 1997 · Triennial form not returned · Museum Of Flight FoundationN1253EBoeing 727-2L5 · S/N 21539Cancelled Jan 8, 1997 · Exported to Libya · Boeing Intl Sales CorpN1261EBoeing 727-2L5 · S/N 21540Cancelled Jan 8, 1997 · Exported to Libya · Boeing Intl Sales CorpN3736JCessna 150G · S/N 15065036Cancelled Aug 21, 1996 · Triennial form not returned · Towle SallyN67759Cessna 152 · S/N 15282001Cancelled May 31, 1996 · Exported to New Zealand · Howard Clifford E DBAN77779Boeing 777-236 · S/N 27105Cancelled May 13, 1996 · Exported to United Kingdom · Boeing CompanyN877UMBoeing 727-230 · S/N 20525Cancelled May 6, 1996 · Exported to Slovak Republic · Atasco Leasing IncN4878XRaugust John A XTC · S/N 39Cancelled Feb 8, 1996 · Triennial form not returned · Raugust John AN157JCAero L-39 ALBATROS · S/N 3549Cancelled Nov 16, 1995 · Exported to United Kingdom · Avstar IncorpN161JCAero L-39 ALBATROS · S/N 8212Cancelled Nov 16, 1995 · Exported to United Kingdom · Avstar IncorpN747BKBoeing 747-SP70 · S/N 21604Cancelled Jun 21, 1995 · Exported to Qatar · Boeing Equipment Holding CoN747BLBoeing 747-SP70 · S/N 21605Cancelled Jun 21, 1995 · Exported to Qatar · Boeing Equipment Holding CompanyN2357DRobinson Helicopter R22 MARINER · S/N 2294MCancelled Jun 5, 1995 · Exported to South Africa · Southern Tuna CorporationN9290Enstrom F-28A · S/N 270Cancelled Jun 1, 1995 · Exported to Canada · Puget Sound Helicopters IncN874UMUnknown model · S/N 20014Cancelled Mar 17, 1995 · Exported to Iceland · Atasco Leasing IncN2784RFairchild FH-227D · S/N 573Cancelled Mar 14, 1995 · Exported to Ecuador · South Seattle Community CollegeN6188ABeech C24R · S/N MC770Cancelled Oct 5, 1994 · Exported to Germany · Long IngridN9190UCessna 150M · S/N 15078141Cancelled Sep 15, 1994 · Triennial form not returned · Galvin Flying ServiceN9124GCessna 182N · S/N 18260664Cancelled Jul 27, 1994 · Triennial form not returned · Hedegard Peter L DBA
Back to Seattle, WA