OpenAirDocs.org
Puyallup, WA

Cancelled registrations · 51

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

N5397YPiper PA-23-250 · S/N 27-2472Cancelled Mar 22, 2025 · Sale reported, canceled · Built 1963N9702ACessna 170A · S/N 19163Cancelled May 4, 2024 · Revoked, canceled · Built 1949 · Farrington Geoffrey AN721NPDJI INSPIRE 1 · S/N W21ACI16011003Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Azure Green Consultants LLCN598JVDJI PHANTOM 3 PROFESSION · S/N P76DCG18066601Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Arrow Aerial Precision LLCN666FCDJI PHANTOM 3 PROFESSION · S/N P76DCG18066870Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Arrow Aerial Precision LLCN1151MCessna 172L · S/N 17259451Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1970 · Raw Racing IncN58195Hughes 269C · S/N 480687Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1978 · Raw Heli LLCN780HR3D Robotics SOLO · S/N S111A5804184Cancelled Jun 3, 2020 · Registration expired, pending cancellation · Ed Beck Photography LLCN627US3D Robotics SOLO · S/N S111A5605087Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Ed Beck Photography LLCN554VADJI INSPIRE 1 · S/N W13DBL26020975Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Access Design IncN545UTDJI PHANTOM 2 VISION + · S/N PH645241847Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Access Design IncN3972SCessna 172E · S/N 17251172Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1964N7313PPiper PA-24-250 · S/N 24-2489Cancelled Feb 4, 2017 · Revoked, canceled · Built 1961 · Lawton Maurice JN1322PPiper PA-23 · S/N 23-364Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1955 · Sandefur Richard LN877RAAllred Robert H RANS S 9 · S/N 687008Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Allred Robert HN7422PPiper PA-24-250 · S/N 24-2610Cancelled Sep 10, 2014 · Revoked, pending cancellation · Built 1961 · Puget Sound Flyers IncN9506FHughes 269B · S/N 870335Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1968 · Schell John JN2934SCessna 150G · S/N 15066834Cancelled Sep 30, 2013 · Sale reported, canceled · Built 1967N773TTheinert R L/Sproule P J AVID MARK IV · S/N 302Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Theinert Randell LN520SEAero Commander 520 · S/N 520-25Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1952N51REVandersheldon A D RALLY 3 · S/N 25007Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Van Derschelden Albert DN80061Cessna 152 · S/N 15285351Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1981 · Reid Richard LN6878TCessna 310D · S/N 39178Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1960 · Halbert William CN5649SBeech 35-C33A · S/N CE-55Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1966 · Herlofson Colin JayN34NHHoskins Joseph L ZENITH CH-701 · S/N 7-6680Cancelled Feb 22, 2013 · Built 2010 · Hoskins Joseph LN1224BJodway Nelson L REV MINI 500 · S/N 241Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Karlin JohnN66PKHunting PEMBROKE MK 51 · S/N K66B-4002Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1954N18295Allen Marshall T SR ZODIAC CH 601 HDS · S/N 3159Cancelled Sep 5, 2012 · Registration pending, canceled · Built 1999N18JJJoyce DRAKE · S/N 4Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Joyce John JN32829Piper PA-28-151 · S/N 28-7515254Cancelled Feb 3, 2011 · Exported to Canada · Built 1974 · Krahn David AN449KMorris Keith S KR-2 · S/N 4237Cancelled Apr 18, 2005 · Triennial form undeliverable · Built 1982 · Morris Keith SN686SBeech A35 · S/N D-1876Cancelled Nov 19, 2004 · Sale reported · Built 1948N8533YPiper PA-30 · S/N 30-1694Cancelled Nov 5, 2004 · Exported to Australia · Built 1968 · Sargeant Francis LN3305EAeronca 11AC · S/N 11AC-1676Cancelled Nov 4, 2004 · Built 1947 · Schell John JN6942FCessna 150F · S/N 150-63542Cancelled Jan 7, 1984 · Cearley Philip JN9180CCessna 180 · S/N 31279Cancelled May 12, 1977 · Exported to Canada · Shipuleski Edward JN9280TCessna 180C · S/N 50780Cancelled May 27, 1976 · Thun Field Skydivers IncN9123Vancraft 2 · S/N 848-1622Cancelled Jun 5, 1975 · Wilkerson DickN5156UCessna 206 · S/N 2060156Cancelled Aug 15, 1974 · Exported to Canada · Valley Aricraft IncN1525Turner T-40A · S/N 54Cancelled Jul 18, 1974 · Built 1973 · Thuotte Gerald FN6699XCessna 210A · S/N 21057699Cancelled Jun 25, 1973 · Quirie Kenneth MN6507BMooney M20 · S/N 1174Cancelled May 23, 1973 · Exported to Canada · Johnston Harold E Or Irene L JohnstonN8322XCessna 172C · S/N 17248822Cancelled Apr 17, 1972 · Exported to Canada · Latham Robert J & Latham Chriss EN1944DBeech C35 · S/N D-3222Cancelled Feb 3, 1972 · Built 1952 · Sloan CalN6543SCessna 150H · S/N 15067343Cancelled Sep 24, 1970 · Built 1967 · Puyallup Valley Development Co InN6069ACessna 172 · S/N 28669Cancelled Jan 20, 1970 · Opp Edward AN6524NBellanca 14-13-3 · S/N 1645Cancelled Nov 9, 1967 · Built 1949 · Soloman James SN5724ACessna 172 · S/N 28324Cancelled Nov 24, 1965 · Built 1956 · Marcelle James RN9447ACessna 140A · S/N 15268Cancelled May 20, 1965 · Blancher Howard S JrN49265Fairchild M-62A · S/N T41-874Cancelled Jan 3, 1952 · Pettit Virgil V
Back to Puyallup, WA