Redmond, WA

Cancelled registrations · 67

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

N70JRForman James Roy GLASAIR II S TD · S/N SH2055Cancelled Feb 14, 2007 · Triennial form not returned · Forman James RoyN2071JCameron Balloons US V-77 · S/N 5428Cancelled Jul 27, 2004 · Triennial form not returned · Built 1988 · Nelson Lawrence WN50PLIsrael Aircraft Industries 1124A · S/N 338Cancelled Sep 11, 2003 · Triennial form not returned · Built 1981 · Panda Leasing CoN116DCCrocker Donald E RV-6 · S/N 20298Cancelled Jul 30, 2003 · Second triennial mailing, no response · Built 1991 · Crocker Donald EN628BNorth American T-28B · S/N 138224Cancelled Mar 20, 2003 · Second triennial mailing, no response · Built 1955 · Weber GregoryN71PWBoeing 737-2Q8C · S/N 21960Cancelled Dec 23, 2002 · Exported to Kyrgyzstan · Global Aviation ServicesN704NYCessna 150M · S/N 15078754Cancelled Sep 19, 2002 · Triennial form not returned · Built 1976 · Zephyr Aviation LtdN75PWBoeing 737-2T5 · S/N 22632Cancelled Sep 9, 2002 · Exported to Kyrgyzstan · Global Aviation ServicesN5669SMaule M-7-235 · S/N 4040CCancelled Aug 24, 2001 · Stieber John WN40191Stinson 108 · S/N 108121Cancelled Mar 4, 1997 · Triennial form not returned · Dickerson William RN34RNNewton Richard PANTHER 2 PLUS · S/N 69034Cancelled Jun 16, 1993 · Triennial form not returned · Reeves Robert TN11NACessna 310 · S/N 35182Cancelled Jun 5, 1991 · Fouroohi VafaN37025Balloon Works FIREFLY 8-24 · S/N F8059Cancelled Apr 16, 1991 · Triennial form not returned · Paul WillN8908PPiper PA-24-260 · S/N 24-4363Cancelled Oct 3, 1984 · Administratively canceled · Emr AviationN8346Randall FLYBABY 1A · S/N 2071Cancelled Dec 11, 1981 · Exported to Canada · Randall Ralph LN252BColonial C-1 · S/N 12Cancelled Sep 21, 1978 · Exported to Canada · Bouton NormanN9650BCessna 180 · S/N 32947Cancelled Aug 18, 1975 · Bolles William A
Back to Redmond, WA