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.

N1445BLuscombe 8E · S/N 6072Cancelled May 13, 1965 · Exported to Canada · Built 1948 · Inland Empire Aviation AveN7331CBeech C-45 · S/N 43-35750Cancelled Dec 31, 1963 · Spokane School Dist No 61N6170MStinson 108-3 · S/N 108-4170Cancelled Sep 4, 1962 · Rainbow RanchesN5369ACessna 310B · S/N 35569Cancelled Aug 28, 1962 · Exported to Canada · Western Aircraft CorpN42305Piper J3C-65 · S/N 14555Cancelled Dec 4, 1961 · Exported to Canada · Ulowetz GeorgeN80517Globe GC-1B · S/N 20Cancelled Nov 15, 1961 · Exported to Germany · Franco Railroad Contractors IncN8084DPiper PA-18-150 · S/N 18-6075Cancelled Oct 9, 1961 · Exported to Canada · Built 1957 · N A Degerstram IncN28897Luscombe 8A · S/N 1639Cancelled Jul 18, 1961 · Exported to Canada · Brown Lynden PN7022KPiper PA-20 · S/N 20-128Cancelled Mar 8, 1961 · Exported to Canada · Switzer Walter HN5620HPiper PA-16 · S/N 16-231Cancelled Nov 17, 1960 · Exported to Canada · Built 1949 · Shriner Roy JN902APiper PA-22 · S/N 22-203Cancelled Nov 16, 1960 · Exported to Canada · Spalding DolphN1710NCessna 120 · S/N 11954Cancelled Jun 8, 1960 · Exported to Canada · Heine PhillipN6998DPiper PA-18A · S/N 18-5529Cancelled Jun 7, 1960 · Exported to Canada · Lamb R GN91690North American NAVION · S/N NAV-4-432Cancelled May 21, 1960 · Farwell D Hugh And Von Marbod A FN95780Taylorcraft BC12-D · S/N 8080Cancelled Nov 6, 1959 · Laney Harold AN49919Laister-Kauffman LK-10A · S/N 95Cancelled Jan 5, 1959 · Condor Soaring Club IncN35185Piper J5A · S/N 5574Cancelled Sep 2, 1958 · Exported to Canada · Gutshall Irvin EN3772MPiper PA-12 · S/N 12-2703Cancelled Aug 7, 1958 · Exported to Canada · Gutshall Irvin EN53621Laister-Kauffman TG-4A · S/N 50Cancelled Aug 7, 1958 · Exported to Canada · Gross HarryN3410APiper PA-22-135 · S/N 22-1681Cancelled Jul 11, 1958 · Exported to Canada · Lamb Flying Service IncN99053Engineering & Research 415-C · S/N 1676Cancelled Jun 23, 1958 · Spalding Auto WreckingN2052VCessna 120 · S/N 14622Cancelled Apr 2, 1958 · Exported to Canada · Nelson WilliamN1789VCessna 120 · S/N 13974Cancelled Mar 25, 1958 · Exported to Canada · Vander Vert Robert AN276CStinson 108-2 · S/N 108-3276Cancelled Aug 30, 1957 · Flying 14 ClubN77496Cessna 120 · S/N 11940Cancelled Jun 24, 1957 · Exported to Canada · Miller Robert WN89024Cessna 140 · S/N 8028Cancelled Apr 19, 1957 · Stiehl CarlN8929CPiper PA-22-135 · S/N 22-1525Cancelled Apr 16, 1957 · Exported to Canada · General Machinery CoN3777MPiper PA-12 · S/N 12-2708Cancelled Dec 14, 1956 · James M RyanN957DStinson 108-2 · S/N 108-2957Cancelled Nov 27, 1956 · Northwest Electronics IncN1553APiper PA-20 · S/N 20-755Cancelled May 29, 1956 · Exported to Canada · Hooper Leroy DN49372Fairchild M-62A-3 · S/N FC 217Cancelled May 21, 1956 · Best Harold DN1939KLuscombe 8E · S/N 4666Cancelled May 10, 1956 · Exported to Canada · Walker Roland DN2825ACessna 180 · S/N 30025Cancelled Apr 30, 1956 · Mifflin John PN95826Taylorcraft BC12-D · S/N 8126Cancelled Feb 27, 1956 · Stanton D JN49361Consolidated Vultee SNV-1 · S/N 1786Cancelled Nov 21, 1955 · Brown Roy DN87765Piper J3C-65 · S/N 15423Cancelled Oct 13, 1955 · Exported to Canada · Hansen Victor RN50891Laister-Kauffman TG-4A · S/N 25Cancelled Oct 11, 1955 · Lamb Flying ServiceN1702NCessna 120 · S/N 11946Cancelled Sep 23, 1955 · Gage B FN835APiper PA-22 · S/N 22-136Cancelled Aug 18, 1955 · Northwest Pilots AssnN77490Cessna 120 · S/N 11934Cancelled Aug 10, 1954 · Vandervert Robert AN8008KStinson 108-2 · S/N 108-3008Cancelled Jun 10, 1954 · Toms G ON49205Aeronca 0-58B · S/N 058B-4172Cancelled Jan 14, 1954 · R F T Aero ClubN3887VCessna 195A · S/N 7357Cancelled Feb 25, 1953 · Mifflin John PN1788DCessna 170A · S/N 20231Cancelled Feb 6, 1952 · Gemberling Paul EN5220Ryan B1 · S/N 108Cancelled Nov 23, 1951 · Kleiner Robert HN49337Fairchild M-62C(PT-23A) · S/N 3633AECancelled Oct 31, 1950 · Mamer Shreck Air TransportN91146North American NAVION · S/N NAV-4-38Cancelled Feb 27, 1950 · Built 1946 · Carman Harold EN49325Stinson L-5 · S/N 76-469Cancelled Oct 27, 1949 · Wallace Air Service IncN90687Commonwealth 185 · S/N 1782Cancelled Jun 2, 1949 · C G Coppinger DBA Spokane SkywaysN2211NCessna 140 · S/N 12447Cancelled May 31, 1949 · Empire Distributors Inc
Back to Spokane, WA