OpenAirDocs.org
Spanaway, WA

Cancelled registrations · 55

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 = 'SPANAWAY'
  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.

N4218BBeech F35 · S/N D-4178Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1955 · Abernathy Michael RN582PConvair 440 · S/N 475Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1957 · R&R Holdings IncN134UUlfeldt John KITFOX IV-1200 · S/N 1727Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1996 · Sheldon Joseph AN590XGeneral Dynamics CV-580 · S/N 130Cancelled May 8, 2021 · Registration expired, pending cancellation · N590x IncN585PConvair 340/580 · S/N 163Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1954 · Air Tahoma IncN52442Cessna R182 · S/N R18201646Cancelled Apr 6, 2020 · Registration pending, canceled · Built 1980N3460HEngineering & Research ERCOUPE 415-E · S/N 4085Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1948 · Mowry Richard DN4314ZPhantom PHANTOM 1 · S/N PH00171Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1984 · Hall James NN138MYTest Spol. Sr.O TST-8 ALPIN DM · S/N 08010400Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 2000 · Beisler Robert CN9093YCarillon John C ZODIAC CH601HDS · S/N 63758Cancelled Jun 26, 2018 · Registration pending, canceled · Built 2005N14MJCessna 150C · S/N 15059836Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1963 · Wicklander Richard ON1296DCessna 170B · S/N 25424Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1958 · Johnson James WN85UConsolidated Vultee PBY-6A · S/N 64041Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1945 · Flying Fireman IncN587XConvair 340/580 · S/N 361Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1956 · Air Tahoma IncN6155HCessna 180 · S/N 30169Cancelled May 6, 2015 · Registration expired, pending cancellation · Loete Steven DN99380Convair 240 · S/N 249Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Cool Air IncN9888TCessna 172A · S/N 47688Cancelled Nov 3, 2014 · Third renewal notice · Built 1960 · Rothschild America LtdN147DMMcmahon Donald G RANS S 9 EXP · S/N 687009Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1988 · Blatt Raymond KN882PConvair 240-53 · S/N 5323Cancelled Jun 10, 2013 · Registration expired, pending cancellation · Condor Aviation IncN43JWPitts Special S-1 · S/N JW-1Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1971 · Gruber Carl SN20401Dart G · S/N G-5Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1938 · Sowle Richard AN7961VCessna 180H · S/N 18051861Cancelled Jan 8, 2013 · Third renewal notice · Built 1967 · Bombard Charles AN3912Breezy TG-BLU-1 · S/N 3Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1968 · Grout Tony NN42353Cessna 182L · S/N 18258979Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1968N1272CPiper PA-22-135 · S/N 22-1064Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1953 · Cannell John JN3221ZPiper PA-22-150 · S/N 22-7162Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1963 · Gruber Carl SN53BTTaylor Robert H SMITH MINI DSA-1 · S/N DSA53TCancelled Aug 6, 2012 · Registration pending, canceled · Built 1980N579CJBecktold James K SONERAI IIL · S/N 863Cancelled May 11, 2012 · Registration expired, pending cancellation · Built 1987 · Becktold James KN588XGeneral Dynamics CV-340/580 · S/N 52Cancelled Feb 10, 2012 · Exported to Mexico · Built 1953 · N580 IncN5WZWieland VARI-EZE · S/N 530Cancelled Jun 18, 2011 · Triennial form not returned · Built 1978 · Hall James N JrN584EConvair 340 · S/N 24Cancelled Mar 14, 2011 · Exported to Mexico · Built 1952 · Air Tahoma IncN73104Convair 340-31 · S/N 4Cancelled Dec 1, 2010 · First renewal notice · Built 1952 · R & R Holdings IncN73126Convair 340-31 · S/N 53Cancelled Dec 1, 2010 · First renewal notice · Built 1953 · R & R Holdings IncN6499YAerostar International RX-7 · S/N RX7-3119Cancelled May 6, 2009 · Triennial form not returned · Built 1988 · Breeden Timothy MN586PGeneral Dynamics CV-580 · S/N 68Cancelled Oct 2, 2007 · Triennial form not returned · N580 IncN968NConvair 440 · S/N 462Cancelled Apr 11, 2007 · Triennial form not returned · Built 1957 · R And R Holdings IncN75142Douglas DC3C · S/N 9173Cancelled Nov 15, 2001 · Triennial form not returned · Built 1944 · Rude Richard LN1296DCessna 170A · S/N 19872Cancelled Sep 17, 2001 · Triennial form not returned · Johnson James WN4805EDouglas A-26B · S/N 44-34121Cancelled Jan 3, 2001 · Exported to Canada · Grout Tony N DBAN4416QHardesty/Hays QUICKIE Q2 · S/N 2584Cancelled Mar 25, 1997 · Triennial form not returned · Hays Johnny MN8022BConvair 240-27 · S/N 513816Cancelled Sep 26, 1995 · Triennial form not returned · Cool Air IncN60850Cessna 150J · S/N 15070618Cancelled Jul 29, 1993 · Cool Air IncN2620VCessna 170 · S/N 18130Cancelled Mar 3, 1993 · Triennial form not returned · Scott William AN6361DCessna 172N · S/N 17272747Cancelled Nov 9, 1983 · Exported to Canada · Leonard Charles RN2963ECessna 172N · S/N 17271389Cancelled Mar 1, 1982 · Exported to Canada · Built 1978 · Summers Terry W & CharleneN7374CCessna TU206G · S/N U20603911Cancelled Apr 28, 1981 · Exported to France · Wicklander Richard ON2HLHiller UH-12E · S/N 2045Cancelled Aug 12, 1977 · Exported to Canada · High Life Helicopters IncN2641HEngineering & Research ERCOUPE 415-C · S/N 3266Cancelled Nov 22, 1976 · Exported to Canada · Cardwell David LN22939Cessna 150H · S/N 150-68631Cancelled Sep 20, 1973 · Exported to Canada · Tahoma Flying Service IncN22547Cessna 150H · S/N 15068353Cancelled Jul 2, 1973 · Exported to Canada · Tahoma Flying Service Inc
Back to Spanaway, WA