OpenAirDocs.org
Omak, WA

Cancelled registrations · 84

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

N4320RCessna 172M · S/N 17263073Cancelled Aug 14, 2023 · Built 1974 · Butler John LN4629JDarrin Jackson JACK 1 · S/N 001-211Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Dykes Steve BN32593Piper J4A · S/N 4-1289Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Sandefur Bobby GN80631Cessna 172H · S/N 17255259Cancelled Aug 14, 2019 · Exported to Canada · G And J Aircraft IncN73158Cessna 172M · S/N 17267294Cancelled Jul 16, 2019 · Exported to Canada · Built 1976 · Azzano OrchardsN6951WPiper PA-28-140 · S/N 28-21141Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1965 · Aircraft Salvage And Rebuild IncN22421Cessna 150H · S/N 15068269Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1968 · Howe Roger CN39520Piper PA-32RT-300T · S/N 32R-7887099Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1978 · Aircraft Salvage Rebuld IncN4053LCessna 421A · S/N 421A0103Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1969N772GWPiper PA-28-180 · S/N 28-2554Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1965N49794Cessna 152 · S/N 15281319Cancelled Jun 11, 2013 · First renewal notice · Built 1978 · Sandefur Bobby GN3017YCessna 182E · S/N 18254017Cancelled May 9, 2013 · Sale reported, canceled · Built 1962N7836VMooney M20C · S/N 2871Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1964 · Hartman Calvin GN244PLCessna U206G · S/N U20604371Cancelled Apr 30, 2013 · Sale reported, pending cancellation · Built 1978N5639WPiper PA-28-160 · S/N 28-787Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1962 · Aircraft Salvage And Rebuild IncN5116TCessna R182 · S/N R18201816Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1981N9815JCessna A150M · S/N A1500624Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1975N8018RBeech A24R · S/N MC-8Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1970N7596GCessna 172L · S/N 17259296Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1970N6395LAmerican AA-1A · S/N AA1A-0395Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1972N66350Beech C24R · S/N MC-687Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1980N6647BCessna 310B · S/N 35747Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1958N6754LPiper PA-31-310 · S/N 31-656Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1970N67866Cessna 152 · S/N 15282070Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1978N6876TCessna 310D · S/N 39176Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1960N8244MCessna T210K · S/N 21059244Cancelled Nov 9, 2012 · Sale reported, pending cancellation · Built 1969N3975Walter SMITH MINIPLANE · S/N 1Cancelled Sep 24, 2012 · Sale reported, canceled · Built 1974N3800VCessna 150M · S/N 15076625Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1975N33638Piper PA-28-140 · S/N 28-7525214Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1975N32142Piper PA-28-140 · S/N 28-7525027Cancelled Sep 6, 2012 · Sale reported, canceled · Built 1974N4366YPiper PA-28-161 · S/N 28-8416053Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1984N249CCCessna 210L · S/N 210-61510Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1976N2338APiper PA-20 · S/N 20-913Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1952N1728ZCessna 336 · S/N 336-0028Cancelled Jul 24, 2012 · Sale reported, canceled · Built 1963N1210CPiper PA-22-135 · S/N 22-1018Cancelled Jun 12, 2012 · Registration expired, pending cancellation · Built 1953 · Millard Jonathan LN21842Piper PA-32RT-300T · S/N 32R-7887234Cancelled Jul 21, 2011 · Sale reported, pending cancellation · Built 1978N1095PPiper PA-23-150 · S/N 23-104Cancelled Jul 1, 2011 · Sale reported, canceled · Built 1954N3821RCessna 172H · S/N 17255321Cancelled Aug 28, 2006 · Exported to Canada · Built 1966 · Schily Dan AN3331CBeech F35 · S/N D-4158Cancelled Sep 15, 2004 · Triennial form not returned · Built 1955 · Aircraft Salvage RebuildN24201Piper PA-38-112 · S/N 38-79A1099Cancelled Apr 5, 2004 · Triennial form not returned · Aircraft Salvage Rebuild IncN9228SBeech C23 · S/N M-1761Cancelled Mar 4, 2004 · Triennial form not returned · Built 1976 · Aircraft Salvage And Rebuild IncN400RDPiper PA-30 · S/N 30-1769Cancelled May 29, 2003 · Second triennial mailing, no response · Built 1968 · Aircraft Salvage & Rebuild IncN109RHPiper PA-32RT-300 · S/N 32R-7885070Cancelled May 28, 2003 · Built 1978 · Aircraft Salvage & Rebuild IncN181WSCessna 180A · S/N 50135Cancelled May 28, 2003 · Triennial form not returned · Built 1957 · Aircraft Salvage Rebuild IncN19304Cessna 150L · S/N 15074321Cancelled May 28, 2003 · Built 1973 · Aircraft Salvage And Rebuild IncN2473XCessna 182H · S/N 18256373Cancelled May 28, 2003 · Built 1965 · Aircraft Salvage And Rebuild IncN29133Cessna 210L · S/N 21059812Cancelled May 28, 2003 · Triennial form not returned · Built 1973 · Aircraft Salvage And Rebuild IncN3081VBeech 35 · S/N D-496Cancelled May 28, 2003 · Built 1947 · Aircraft Salvage And Rebuild IncN3280QPiper PA-32-300 · S/N 32-7840122Cancelled May 28, 2003 · Triennial form not returned · Built 1978 · Aircraft Salvage Rebuild IncN3966NMooney M-20G · S/N 680068Cancelled May 28, 2003 · Built 1968 · Aircraft Salvage And Rebuild Inc
Back to Omak, WA