OpenAirDocs.org
Port Orchard, WA

Cancelled registrations · 33

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 = 'PORT ORCHARD'
  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.

N205TJN205tj BERKUT · S/N 50Cancelled Mar 28, 2026 · Sale reported, canceled · Built 2010N6077MStinson 108-3 · S/N 108-4077Cancelled Oct 7, 2023 · Sale reported, canceledN100WCWhittier Kevin M WHITTIER AVID · S/N 101Cancelled Feb 24, 2022 · Registration expired, pending cancellation · Built 2001 · Simons Terence JN95SDShort And Difficult SHORT AND DIFFICULT · S/N 0001Cancelled Jan 20, 2022 · Sale reported, canceled · Built 1996N6143MStinson 108-3 · S/N 108-4143Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Boughner TimN15PWCessna 310Q · S/N 310Q0208Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Hubbard Ben LN2823LPiper PA-28-181 · S/N 28-7990476Cancelled Sep 26, 2019 · Exported to Mexico · Built 1979 · Kelly Timothy PN142WSRamphos AMPHIB TRIKE · S/N 12 USACancelled Mar 23, 2019 · Registration expired, pending cancellation · Built 2003 · Petrowske Michael AN212SHRobinson Helicopter R22 BETA · S/N 3995Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 2005 · Emerald City Aircraft Leasing IncN456LWWoodward Leith J STD-HMLTN GLASAIR I · S/N LW1Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Woodward Leith JN378JSLukehart Larry L CJ1 · S/N 479Cancelled Feb 27, 2018 · Registration pending, canceled · Built 2009N522SARobinson Helicopter R22 BETA · S/N 3788Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 2005 · Carter Richard K DBAN8098UGrice Standford D VP-2 · S/N SG001Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1997 · Grice Standford DN8331HHallett Thomas E HALLETT-1 · S/N SN-101Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 2000 · Hallett Thomas EN31582Stinson 10A · S/N 7831Cancelled May 5, 2015 · Registration expired, pending cancellation · Eckard Leander JN3189PPiper PA-23-150 · S/N 23-1126Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1957N76LLLudwig PITTS SPECIAL S-1 · S/N 1976Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1976 · Grice Standford DN274JKKennel Jerry 532 ELITE · S/N 001Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1987N14518Ricks BENSEN GYROCOPTER · S/N 385Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1974N8768ABeech A35 · S/N D-2190Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1949 · Baker Barbara L DBAN7530FRobinson Helicopter R44 II · S/N 10313Cancelled May 13, 2013 · Built 2004 · Emerald City Aircraft Leasing IncN7144BPiper PA-22-150 · S/N 22-4365Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1956 · Brothers ConstructionN6658ECessna 175 · S/N 56158Cancelled Nov 7, 2012 · Built 1959 · Armstrong BruceN8912CP Z L -Warszawa-Cnpsl PZL-104 WILGA 35A · S/N 19840810Cancelled Nov 5, 2012 · Third renewal notice · Armstrong BruceN110FFChampion Ken FREEDOM FALCON FF1 · S/N 001Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1982 · Harman Richard DN7277MCessna 206H · S/N 20608054Cancelled Mar 18, 2005 · Exported to Philippines · Waddling Eagle Aviation IncN94282Cessna 152 · S/N 15285637Cancelled Dec 11, 1984 · Administratively canceled · Tops IncN9650RBeech B95 · S/N TD-344Cancelled Apr 24, 1974 · Freeburg James MN99273Ercoupe 415-C · S/N 1896Cancelled Apr 2, 1970 · Exported to Canada · Built 1946 · Stolairco IncN5949ACessna 172 · S/N 28549Cancelled Jul 26, 1966 · Retzlaff MelvinN6372KRepublic RC-3 · S/N 601Cancelled Jan 29, 1954 · Davis Delmer PN9426ACessna 140A · S/N 15247Cancelled Jan 25, 1952 · D & D Flying ServiceN2165NCessna 140 · S/N 12401Cancelled Aug 5, 1949 · D & D Flying Service
Back to Port Orchard, WA