Seattle, WA

Cancelled registrations · 1,563

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

N2102VCessna 120 · S/N 14327Cancelled Nov 29, 1957 · Boeing Employees Flying AssociationN3261MPiper PA-12 · S/N 12-2031Cancelled Nov 13, 1957 · Exported to Canada · Universal Steel Fabricating CoN6191CRyan NAVION NAV 4 · S/N NAV-4-603Cancelled Aug 20, 1957 · Exported to Canada · Allison C WN10205Douglas DC-4 · S/N 42983Cancelled Aug 7, 1957 · Exported to Canada · Alaska Airlines IncN5119CBeech B35 · S/N D-2404Cancelled Mar 1, 1957 · Root CorneliusN8766CPiper PA-18A-135 · S/N 18-2851Cancelled Jan 24, 1957 · Exported to Canada · Reverman Henry JN49408Fairchild M-62A · S/N 5903AECancelled Dec 17, 1956 · Adams Robert S Or Byron G BehrensN2261DCessna 170B · S/N 20413Cancelled Dec 12, 1956 · Exported to Canada · Hubbard A MN49159Ryan Aeronautical PT-22 · S/N 1914Cancelled Oct 12, 1956 · Carpenter Ben IN71961Luscombe 8A · S/N 3388Cancelled Oct 11, 1956 · P J FrickletonN3073BCessna 195A · S/N 7957Cancelled Oct 3, 1956 · Farrington Fred HallN1477BLuscombe 8F · S/N 6104Cancelled Aug 8, 1956 · Exported to Canada · Casten FredN7909ACessna T-50 · S/N 2373Cancelled Jul 12, 1956 · Holmes Ronald EN44405Taylorcraft BCS12-D1 · S/N 10205Cancelled May 29, 1956 · G W PhillipsN45787Luscombe 8A · S/N 2314Cancelled May 10, 1956 · Reichardt Jack Raymond John Tantow John Ainslie HN50442Taylorcraft DCO-65 · S/N L-5342Cancelled Apr 30, 1956 · Paulson ClarenceN56552Fairchild M-62A · S/N T42-3466Cancelled Apr 30, 1956 · Perry Harold RN3128VBeech 35 · S/N D-553Cancelled Mar 23, 1956 · Built 1947 · Shaw A HN44213Taylorcraft BCS12-D · S/N 10013Cancelled Feb 29, 1956 · Pierce Monte K DBA The Sky HarborN1233NCurtiss Wright P-40N · S/N 27490Cancelled Feb 16, 1956 · Bell ArtN88322Piper J3C-65 · S/N 15940Cancelled Dec 7, 1955 · Exported to Canada · Roehl Donald DN49444Cessna T-50 · S/N 5524Cancelled Nov 21, 1955 · Carlson George MN2854EAeronca 7AC · S/N 7AC-6437Cancelled Nov 14, 1955 · Washington Aircraft & Transport CorporationN83798Aeronca 7AC · S/N 7AC-2476Cancelled Oct 28, 1955 · Charles L HallN49409Fairchild M-62A · S/N T43-5006Cancelled Oct 24, 1955 · Johnstone A F DBA Northern Aircraft CoN31911Aeronca 65-CA · S/N CA-11881Cancelled Oct 19, 1955 · Sanders Paul FN17024Arrow F · S/N 12Cancelled Oct 18, 1955 · Don McmichaelN1980KLuscombe 8E · S/N 4707Cancelled Oct 17, 1955 · Bowers Peter MN44314Taylorcraft BCS12-D1 · S/N 10114Cancelled Oct 10, 1955 · Kurtzer Flying ServiceN1027NFairchild PT-26A · S/N FV-451Cancelled Oct 5, 1955 · Walter E NicholsN2214NCessna 140 · S/N 12450Cancelled Aug 26, 1955 · Johnson Howard B M DN956BBell 47G · S/N 1274Cancelled Jul 15, 1955 · Exported to Canada · Boeing William E JrN1005NVultee BT-13 · S/N 312Cancelled Jun 6, 1955 · Robert S PeltonN91582North American NAVION A · S/N NAV-4-142Cancelled May 31, 1955 · Exported to Canada · Stephanus B MN3233EAeronca 11AC · S/N 11AC-1580Cancelled Mar 28, 1955 · Exported to Canada · Built 1947 · Gulbrandsen Harold AN73367Fairchild M-62A-3 · S/N 1011Cancelled Feb 7, 1955 · Watts A CN20346Taylorcraft A · S/N 447Cancelled Jan 14, 1955 · Built 1937 · Kellett Luther MN523CStinson 108-3 · S/N 108-3523Cancelled Nov 23, 1954 · Exported to Canada · O Connell George AN4242MPiper PA-12 · S/N 12-3159Cancelled Sep 30, 1954 · Exported to Canada · Savage Robert JN4338VCessna 195 · S/N 7244Cancelled Sep 21, 1954 · Uptegrove Lawrence IN6270KRepublic RC-3 · S/N 480Cancelled Jul 21, 1954 · Built 1947 · Crawford A ForbesN1735VCessna 120 · S/N 14131Cancelled Jun 14, 1954 · Metropolitan Chemical CoN7496KPiper PA-20 · S/N 20-410Cancelled Apr 22, 1954 · Exported to Canada · Built 1950 · Galeno Fred JN2450NCessna 140 · S/N 12703Cancelled Mar 24, 1954 · Exported to Canada · Macwhinnie Arthur BN95237Taylorcraft BC12-D · S/N 9637Cancelled Dec 29, 1953 · Exported to Canada · Burch Reed LN69646Cessna T-50 · S/N 2776Cancelled Nov 9, 1953 · Schrock B CN16240Waco ZQC-6 · S/N 4439Cancelled Nov 3, 1953 · Built 1936 · Hawkins William HN767NPerth Amboy BIRD A · S/N 4039Cancelled Oct 28, 1953 · Johnson Arthur AN36203Taylorcraft BC-65 · S/N 3157Cancelled May 21, 1953 · Exported to Canada · De Angelis MiloN2424NCessna 140 · S/N 12673Cancelled Apr 15, 1953 · Mensinger L S
Back to Seattle, WA