OpenAirDocs.org
Pasco, 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 = 'PASCO'
  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.

N9571ACessna 170A · S/N 19132Cancelled Oct 16, 2023 · Revoked, canceled · Built 1949 · Smith Thomas EN450KARobinson Helicopter R44 · S/N 0479Cancelled Nov 16, 2022 · Exported to China · Calaway CourtneyN7236NBell OH-58A · S/N 44071Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1972 · J&D Aircraft Sales LLCN3614APiper PA-22-135 · S/N 22-1874Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1953 · Petty John WN226EEMatthias Paul LANCAIR 360 · S/N 508-320-246 FBCancelled Oct 30, 2021 · Registration expired, pending cancellation · Powell David MN718BBeech J35 · S/N D-5464Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Clark Lahn FN402AGCanadair CL41G · S/N 2202Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1967 · Pacific Northwest Aviation MuseumN817WFDJI PHANTOM 2 · S/N PH646079447Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Fritz Brian AN2593TMiddleton Keith R SS2 · S/N AUNW009Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 2003 · Middleton Keith RN2594TMiddleton Keith R T-2 · S/N AUNW002Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 2001 · Middleton Keith RN6973QBeech 19A · S/N MB-320Cancelled Nov 29, 2018 · Registration pending, canceled · Built 1968N43608Taylorcraft BC12-D · S/N 7267Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1946N9737EAeronca 11AC · S/N 11AC-1380Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1946N3265VBeech 35 · S/N D-713Cancelled May 2, 2018 · Sale reported, canceled · Built 1947N335CStinson 108-2 · S/N 108-3335Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1947 · Bitton CoreyN2930ARottinghaus Regis C SS2 · S/N AUNW008Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 2003 · Rottinghaus Regis CN71447Textron 208B · S/N 208B5318Cancelled Oct 16, 2017 · Exported to Indonesia · Built 2016 · Roberts Eric BN810CStinson 108-3 · S/N 108-3810Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1947 · Cooper Gerald WN68682Bensen B-8M · S/N RB-1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1963 · Burns Robert HN2595TMiddleton Keith R T-103 · S/N AUNW003Cancelled Jan 25, 2017 · Third renewal notice · Middleton Keith RN82237Aeronca 7AC · S/N 7AC865Cancelled Dec 27, 2016 · Revoked, pending cancellation · Built 1946 · Loney Aviation CoN733ECCessna 172N · S/N 17268229Cancelled Oct 27, 2016 · Built 1976 · Bergstrom Aircraft IncN3096DCessna 208B · S/N 208B5149Cancelled Apr 7, 2016 · Exported to Indonesia · Built 2014 · Roberts EricN8152FCessna 208B · S/N 208B5051Cancelled Apr 6, 2016 · Exported to Indonesia · Built 2013 · Roberts Eric BN3091Bensen B-8M · S/N LR-1Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1967 · Cooper Gerald WN92973Rearwin 185 · S/N 1706Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1946 · Johnson Rick LN66762Cessna 150M · S/N 15076258Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1974 · Stewart Flight CenterN3442QCessna 320E · S/N 320E0042Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1966N8720SCessna 150F · S/N 15062020Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1965N22670Cessna 150H · S/N 15068438Cancelled Aug 13, 2012 · Sale reported, canceled · Built 1968N48448Taylorcraft DCO-65 · S/N 5556Cancelled Aug 7, 2012 · Revoked, canceled · Built 1943 · Mcleod James NN4996XRockwell International S-2R · S/N 2138RCancelled Feb 7, 2012 · Built 1975 · Air-Trac IncN3849YBeech 77 · S/N WA-246Cancelled Jul 29, 2008 · Triennial form not returned · Built 1981 · Bergstrom Aircraft IncN9905PPiper PA-36-285 · S/N 36-7560009Cancelled Feb 18, 2004 · Exported to Swaziland · Pfister StevenN4195NCessna 140 · S/N 13666Cancelled Oct 25, 2003 · Built 1947 · Hone Ryan LN757AGCessna TR182 · S/N R18201211Cancelled May 20, 2003 · Exported to Canada · Built 1979 · J & D Aircraft Sales LLCN66WJPiper PA-31T · S/N 31T-7920041Cancelled May 23, 2002 · Exported to Mexico · Built 1979 · Machugh David LN2627XCessna P206 · S/N P206-0127Cancelled Aug 2, 2001 · Triennial form not returned · Lott JimN731PADacus Joel B ADVENTURER 333 AMPHI · S/N 180Cancelled Nov 15, 1999 · Dacus Joel BN584WACessna 172N · S/N 17271944Cancelled Sep 13, 1997 · Triennial form not returned · Webber C LN8818QAero Commander S2R · S/N 1518RCancelled Dec 11, 1996 · Triennial form not returned · Air Trac IncN1806CBeech 77 · S/N WA272Cancelled Sep 11, 1991 · Triennial form not returned · Bergstrom Aircraft IncN11633Cessna 150L · S/N 15075586Cancelled Nov 6, 1982 · Administratively canceled · Hoops AviationN6745SCessna 150H · S/N 15067545Cancelled Sep 11, 1980 · Buckley Mary SueN40035Piper PA-32R-300 · S/N 32R-7780510Cancelled Dec 4, 1978 · Exported to Libya · Food Development CorpN57863Piper PA-36-300 · S/N 36-7760030Cancelled Dec 4, 1978 · Exported to Libya · Food Development CorpN62889Aero Commander S2R · S/N 1529RCancelled Jun 8, 1978 · Exported to Canada · Carr Jack AN9960CCallair A-5 · S/N 215Cancelled Feb 28, 1975 · Ness RobertN8303UCessna 172F · S/N 17252203Cancelled Feb 9, 1972 · Exported to Canada · Tri City Airways IncN8911QAero Commander S2R · S/N 1581RCancelled Nov 29, 1971 · Carr Aviation Inc
Back to Pasco, WA