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.

N4382SSikorsky S-58J · S/N 581627Cancelled Sep 12, 1978 · Exported to Canada · Chopot Edward J (Lor)N8342WPiper PA-28-180 · S/N 28-2526Cancelled Jan 24, 1978 · Smith Howard GN924TBeech 35-33 · S/N CD-126Cancelled Nov 1, 1977 · Western Aircraft CorpN7075TCessna 172 · S/N 46675Cancelled Jul 21, 1977 · Larsen Richard EN3423JCessna 150G · S/N 15066123Cancelled Jul 11, 1977 · Four Winds Flying ClubN8803LPiper PA-25-260 · S/N 25-5296Cancelled May 20, 1977 · Exported to Canada · Built 1971 · Loranger Aviation IncN92JDCessna TU206F · S/N U20602479Cancelled Mar 25, 1977 · Built 1974 · Alexander John DN44HMSchweizer SGS 1-26B · S/N 258Cancelled Mar 18, 1977 · Exported to Canada · Munro Herbert BN7738PPiper PA-24-250 · S/N 24-2952Cancelled Aug 20, 1976 · Exported to Canada · Loranger Aviation IncN1078JAero Commander 112 · S/N 78Cancelled May 12, 1976 · Machen IncN42338Cessna 182L · S/N 18258974Cancelled Feb 2, 1976 · Exported to Canada · Built 1968 · Price Piper Inc DBA Price AirmotiveN5SPitts S-1C · S/N BBC-1Cancelled Jan 6, 1976 · Built 1970 · Southwell Robert AN6478RPiper PA-28-140 · S/N 28-21667Cancelled Dec 2, 1975 · Loranger Aviation IncN5455SPiper PA-28 · S/N 287125122Cancelled Oct 14, 1975 · Exported to Canada · Grubbs RobertN14542Semco Balloon TC-4A · S/N SEM133Cancelled May 6, 1975 · Flying Z IncN6983ACessna 172 · S/N 29083Cancelled Apr 18, 1975 · Exported to Canada · Schroder Kalvin DN1458HAeronca 15AC · S/N 15AC-531Cancelled Jun 26, 1974 · Exported to Canada · Ray A PellowN66798Piper PA-31P · S/N 31P-7300158Cancelled Mar 8, 1974 · American Sign And Indicator CorpN9944RBeech M35 · S/N D-6470Cancelled Jan 7, 1974 · Exported to Canada · Opportunity Flying Club IncN3181FCessna 170B · S/N 25825Cancelled Dec 7, 1973 · Lynn Clark WN15587Piper PA-28-235 · S/N 28-7310057Cancelled Nov 15, 1973 · Loranger Aviation IncN6693ACessna 172 · S/N 28793Cancelled Sep 12, 1973 · Exported to Canada · Flying Fourteen Flying ClubN9539FHughes 269B · S/N 1080392Cancelled Aug 28, 1973 · Exported to New Zealand · Empire Air Service IncN7228FPiper PA-28-140 · S/N 28-25141Cancelled Jul 11, 1973 · Exported to Canada · Mifflin Aircraft Co IncN2218EAeronca 7AC · S/N 7AC-5792Cancelled Jun 14, 1973 · Economy Flying Club IncN4320UCessna 150D · S/N 15060320Cancelled Aug 25, 1972 · Exported to Canada · Guider Brendan CN7676KPiper PA-20 · S/N 20-497Cancelled Jun 16, 1972 · Exported to Canada · Stanton D JN4010MPiper PA-12 · S/N 12-2890Cancelled Oct 15, 1971 · Exported to Canada · Gutshall Irvin EN2117HErcoupe 415-C · S/N 2740Cancelled Aug 18, 1971 · Vaughn A SandersN1315CPiper PA-22-135 · S/N 22-1106Cancelled Jun 7, 1971 · Lazy 8 Flying ClubN8473CAero Commander 500 · S/N 500-801Cancelled Apr 30, 1971 · Mission Drywall Co IncN93864Forney F-1 · S/N 1187Cancelled Apr 5, 1971 · Spalding WreckingN3815RCessna 172H · S/N 17255315Cancelled Mar 19, 1971 · Exported to Canada · Dearden Dale CN57070Fairchild M-62 · S/N T43-5748Cancelled Feb 8, 1971 · Built 1943 · Powell Raymond BN3996FCessna 172 · S/N 36896Cancelled Nov 17, 1970 · Exported to Canada · Thiefault Kenneth RN4497DBeech G35 · S/N D-4628Cancelled Jul 29, 1970 · H E PryN7839CCherokee II HOMEBUILT · S/N JCM-1Cancelled Jun 29, 1970 · Burnham DickN50598Cessna 150J · S/N 15069424Cancelled Jun 23, 1970 · Built 1968 · Mifflin Aircraft Co IncN30397Cessna 177A · S/N 17701234Cancelled Jun 22, 1970 · Built 1968 · Mifflin Aircraft Co IncN1307CPiper PA-22 · S/N 22-1120Cancelled Jun 20, 1970 · Built 1953 · Mclean Donald N & Bailey R LN3633CCessna 180 · S/N 31131Cancelled Jun 16, 1970 · Stanton Donald JN1413APiper PA-22 · S/N 22-324Cancelled Apr 20, 1970 · Exported to Canada · Price Piper IncN22740Cessna 150H · S/N 15068485Cancelled Nov 20, 1969 · Exported to Canada · Dolph SpaldingN6409WPiper PA-28-140 · S/N 28-20478Cancelled Sep 11, 1969 · Exported to Canada · Gresham Robert HN5153ZPiper PA-22-108 · S/N 22-8803Cancelled May 6, 1969 · Exported to Canada · Peek Kenneth RN1701ZCessna 336 · S/N 336-0001Cancelled Oct 9, 1968 · Exported to Canada · Mifflin Aircraft Co IncN501MGrumman G-21A · S/N B138Cancelled Feb 2, 1968 · Exported to Canada · Walters Charles EN6186CBeech A45 (T-34A) · S/N 53-4096ACancelled Jul 12, 1965 · U S Air Force (Owner)N5470HPiper PA-18 · S/N 18-61Cancelled May 20, 1965 · Lamb Flying Service IncN2334KLuscombe 8E · S/N 5061Cancelled May 19, 1965 · Exported to Canada · Robert A Southwell
Back to Spokane, WA