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.

N70788Piper J3C65 · S/N 17808Cancelled May 31, 1949 · Spokane Skyways IncorporatedN85067Aeronca 7AC · S/N 7AC-3794Cancelled Mar 25, 1949 · Mamer-Shreck Air TransportN49340Cessna UC-78 · S/N 5390Cancelled Feb 3, 1949 · Muller Dorothy CN49080Fairchild M-62A · S/N T43-5830Cancelled Feb 2, 1949 · Franck Earl FN49084Ryan Aeronautical ST3KR · S/N 2144Cancelled Nov 16, 1948 · Built 1942 · Lamb R GN49342Consolidated Vultee BT-13A · S/N 7324Cancelled Nov 12, 1948 · Johnston Spencer LN49331Fairchild M-62C(PT-23A) · S/N 417Cancelled Nov 1, 1948 · Bambino Herbert GN6469KRepublic RC-3 · S/N 720Cancelled Sep 20, 1948 · A N Hilsen DBA Hilson Aero ServiceN37044Luscombe 8A · S/N 1705Cancelled Aug 30, 1948 · Built 1941 · Calkins Cc And Dwight LN20075Piper J-2 · S/N 1875Cancelled Aug 17, 1948 · Eugene W TerwayN26414Stinson 10 · S/N 7760Cancelled Jul 26, 1948 · Built 1940 · Gill Archie BN15246Waco YOC · S/N 4332Cancelled Jul 6, 1948 · Built 1935 · Flemister Edward WilliamN49333Fairchild M-62C(PT-23A) · S/N 1383AECancelled Jun 22, 1948 · Howard Lloyd AN20820Piper J-3 · S/N 2120Cancelled Jun 15, 1948 · Calkins Aircraft CoN49386Boeing PT-13 · S/N 75-1613Cancelled May 12, 1948 · Lamb R GN81MFairchild 42 · S/N 3Cancelled May 12, 1948 · Clarence Lee SmithN37293Interstate S-1A · S/N 136Cancelled May 11, 1948 · Fred W LucasN8025Fairchild FC-2-W2 · S/N 518Cancelled Mar 31, 1948 · Wallace Air ServiceN49093Taylorcraft DCO-65 · S/N L-4728Cancelled Dec 8, 1947 · Hilsen A N DBA Hilsen Aero ServiceN49314Consolidated Vultee BT-13B (SNV-2) · S/N 79-1330Cancelled Oct 16, 1947 · Wallace Air Service IncN73625Boeing N2S-3 · S/N 75-7089Cancelled Sep 2, 1947 · Van Newkirk IvanN49350Fairchild M-62A-3 · S/N FT-577Cancelled Jul 11, 1947 · James Harold CN28531Fairchild 24R-40 · S/N R40-423Cancelled Sep 13, 1946 · Built 1940 · Wallace H R / Wallace Air ServiceN49111Aeronca L-3C · S/N 4162Cancelled Jul 18, 1945 · Shreck MarieN425MStinson SM-8A · S/N M-4014Cancelled Feb 8, 1945 · Built 1930 · Inman John Et AlN798HMonocoupe 90 · S/N 621Cancelled Oct 17, 1938 · Day Glenn RN365Lincoln Standard LS 3 · S/N SF-2Cancelled Jul 1, 1937 · Built 1920 · Hawley Carroll MN2977Alexander EAGLEROCK A-1 · S/N 169Cancelled Dec 1, 1936 · Pitts HaroldN10187Aeronca C-2 · S/N A-63Cancelled May 15, 1935 · Anderson HilmerN8455Wirt Franklin Petroleum BUHL CA-6B · S/N 61Cancelled Oct 4, 1934 · Built 1930 · Mamer Flying Service IncN755HEaglerock A-3 · S/N 859Cancelled Apr 22, 1932 · Built 1929 · Bigelow Johnson IncN846WBird BK · S/N 2051-31Cancelled Aug 4, 1931 · Pounder Flying Service IncN9630Buhl CA-6 · S/N 46Cancelled Nov 10, 1930 · Exported to Mexico · Built 1929 · Wilson Sam JN862NBellanca CH300 PACEMAKER · S/N 185Cancelled Nov 6, 1930 · Pioneer Educational Society IncN8456Wirt Franklin Petroleum BUHL CA-6B · S/N 62Cancelled Nov 3, 1930 · Built 1930 · International Air TransportN8457Wirt Franklin Petroleum BUHL CA-6B · S/N 63Cancelled Oct 13, 1930 · Built 1930 · International Air TransportN2198TPiper PA-28 · S/N 28-7205050Cancellation date not recorded · Powers Jay LN58908Cessna T-50 · S/N 2410Cancellation date not recorded · United Truck LinesN58912Cessna T-50 · S/N 2429Cancellation date not recorded · Built 1932 · Spokane Aero Supply
Back to Spokane, WA