Spokane, WA

Cancelled registrations · 389

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

N999VPPiper PA-32R-300 · S/N 32R7780385Cancelled Nov 13, 1997 · Second triennial mailing, no response · Webber William JN9248Enstrom F-28A · S/N 236Cancelled Nov 5, 1997 · Sebero James MN11MVMurray Donald H VARIVIGGEN · S/N 415Cancelled Oct 27, 1997 · Triennial form not returned · Murray Donald HN1217NAerospatiale SA315B ALOUETTE III · S/N 2472Cancelled Aug 18, 1997 · Exported to Papua New Guinea · Eagle Helicopters IncN357SAConvair 440 · S/N 484Cancelled May 14, 1997 · Exported to Portugal · Omni Air Group IncN25AKAvions Mudry ET Cie CAP 10B · S/N 56Cancelled Mar 21, 1997 · Second triennial mailing, no response · Heale Robert HN117ACCessna 401A · S/N 401A0040Cancelled Feb 19, 1997 · Second triennial mailing, no response · Rma Inc DBAN358SAConvair 340 · S/N 153Cancelled Apr 8, 1996 · Omni Air Group IncN6463VHelio H-295 · S/N 1423Cancelled Mar 28, 1996 · Exported to Canada · Tedesco Joseph AN52227Cessna 182P · S/N 18262468Cancelled Mar 19, 1996 · Exported to Namibia · Klaue Jim HN54BRRainey William H AERO PHAETON · S/N 8843080Cancelled Feb 9, 1996 · Triennial form not returned · Ross John AN3433YDouglas DC3C · S/N 43089Cancelled Nov 15, 1995 · Triennial form not returned · Salair IncorporatedN276FHughes 369HS · S/N 250711SCancelled Mar 29, 1995 · Exported to New Zealand · Pathfinder Helicopter IncN25AVAvian Balloon FALCON II · S/N 28Cancelled Mar 17, 1995 · Triennial form not returned · Szabo Carlotta SN5048DCessna 182A · S/N 51148Cancelled Feb 9, 1995 · Triennial form not returned · Idlof Ted GN5294QCessna 150L · S/N 15073194Cancelled Feb 2, 1995 · Triennial form not returned · Anderson ChristineN132SHS N I A S AS350D ASTAR · S/N 1335Cancelled Jul 18, 1994 · Triennial form not returned · Eagle Helicopters IncN1509BLuscombe 8F · S/N 6136Cancelled Jun 29, 1994 · Triennial form not returned · Sands Paul FN44AWWhitehouse Alan C MARQUART MA-5 · S/N 0307Cancelled Aug 24, 1993 · Triennial form not returned · Whitehouse Alan CN7381UCessna T210R · S/N 21064966Cancelled May 19, 1993 · Marble IncorporatedN102SSStebbins Scott A SMITH SUPER ACRO · S/N SS02Cancelled May 13, 1993 · Triennial form not returned · Stebbins Scott AN6CHBeech 65-88 · S/N LP43Cancelled May 5, 1993 · Triennial form not returned · Nelson Darrell CN32072Aerospatiale SA316B ALOUETTE III · S/N 2373Cancelled Apr 21, 1993 · Exported to Canada · Eagle Helicopters IncN42496Piper PA-28-180 · S/N 287405164Cancelled Mar 5, 1993 · Triennial form not returned · Ditton Robert SN7946YPiper PA-30 · S/N 301042Cancelled May 19, 1992 · Triennial form not returned · Melville Dan KN93054Cessna T210L · S/N 21060246Cancelled Feb 6, 1992 · Triennial form not returned · John L Habberstad Phd PsN66782Cessna 150M · S/N 15076275Cancelled Sep 26, 1991 · Exported to Germany · Moss James EN197RLLe Blanc Ronald L GLASAIR · S/N 197Cancelled Aug 30, 1991 · Triennial form not returned · Leblanc Ronald LN3987MMagnussen Fred ROTEC RALLY 3 · S/N 64591Cancelled Aug 1, 1991 · Triennial form not returned · Magnussen FredN44GRLet BLANIK L-13 · S/N 175221Cancelled Apr 17, 1991 · Triennial form not returned · Christilaw Glenn HN5156VGreen Larry D GYROPLANE · S/N LG1Cancelled Apr 8, 1991 · Triennial form not returned · Green Larry DN56541Piper PA-34-200 · S/N 347350348Cancelled Mar 25, 1991 · Triennial form not returned · Fairchild Federal Credit UnionN18933Beech C23 · S/N M1972Cancelled Mar 21, 1991 · Triennial form not returned · Nelson Ralph L JrN67323Cessna 152 · S/N 152-81754Cancelled May 9, 1985 · Spokane Airways IncN6GDCessna 340 · S/N 340-0049Cancelled Aug 29, 1984 · D & D Equipment Wholesalers IncN4550ZPiper PA-22-108 · S/N 22-8055Cancelled Aug 8, 1984 · Exported to Canada · Built 1961 · Harkins Franc CN511CStinson 108-3 · S/N 1083511Cancelled Dec 7, 1983 · Whiting V EN37CABeech 99 · S/N U-43Cancelled Nov 15, 1983 · Exported to Canada · Built 1968 · Cascade Airways IncN390CABeech B-99 · S/N U-101Cancelled Apr 14, 1983 · Built 1969 · Cascade Airways IncN3506HEngineering & Research 415-CD · S/N 4131Cancelled Jun 2, 1981 · Built 1947 · Osborne John WN1660FCessna 172H · S/N 17255055Cancelled Feb 17, 1981 · Exported to Canada · Built 1966 · Webster Elizabeth MN3431QCessna 320E · S/N 320E-0031Cancelled Jan 21, 1981 · Built 1967 · Boling Clarence AN2548HErcoupe 415-C · S/N 3173Cancelled Dec 24, 1980 · Built 1946 · Turcotte Milton J Et AlN735GLCessna TU206G · S/N U20604919Cancelled Oct 18, 1980 · Exported to Canada · Felts Field Aviation IncN32085Piper PA-28-151 · S/N 28-7515066Cancelled Jul 30, 1980 · Built 1974 · Mclean Donald T EtalN72UCessna A150M · S/N A1500659Cancelled Jul 28, 1980 · Exported to Canada · Robinson Donald WN6580BMooney M20A · S/N 1250Cancelled Apr 1, 1980 · Exported to Canada · Felts Field Aviation IncN201SHMooney M20J · S/N 24-0125Cancelled Mar 20, 1980 · Exported to Canada · Built 1977 · Farmers & Merchants Bank Of Rockford IncN94126Ercoupe 415-C · S/N 1449Cancelled Oct 22, 1979 · Built 1946 · Johanson Dave CN8448EBell 47G-2 · S/N 2477Cancelled Oct 5, 1978 · Exported to Canada · Pacific Crown Aviation Inc
Back to Spokane, WA