OpenAirDocs.org
Granite Falls, WA

Cancelled registrations · 23

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 = 'GRANITE FALLS'
  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.

N64DSSchulze Erwin E JR SHA GLASAIR SH-2R · S/N 602RCancelled Jul 24, 2023 · Sale reported, canceled · Built 1993N62128Cessna 172P · S/N 17275217Cancelled Jan 31, 2023 · Exported to Kenya · Built 1981 · Aircraft Remanufacturing Company IncN738BMCessna 172N · S/N 17269849Cancelled Jan 31, 2023 · Exported to Kenya · Built 1977 · Aircraft Remanufacturing Company IncN6067LAmerican AA-5 · S/N AA5-0167Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1972 · Blackman Kennis GN1330RGrumman American Avn. AA-5 · S/N AA5-0730Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1975 · Blackman Kennis G DBAN720GAGrumman American Avn. GA-7 · S/N GA7-0002Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1977 · Blackman Kennis G DBAN6796XCessna 310F · S/N 310-0096Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1961 · Green Valley AviationN8387HAero Commander 680 · S/N 680-449-120Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1956 · Green Valley Aviation IncN7438XCessna 172B · S/N 17247938Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1960 · Green Valley Aviation IncN60092Cessna TU206F · S/N U20602004Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1973 · Green Valley Aviation IncN14JBCessna 170 · S/N 18190Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1948 · Brewer Joe LN77WHMooney M20A · S/N 1251Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1958 · Green Valley Aviation IncN789ECMooney M20C · S/N 1965Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1961 · Green Valley Aviation IncN7226FPiper PA-28-140 · S/N 28-25138Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1968 · Green Valley Aviation IncN5976PPiper PA-24-250 · S/N 24-1069Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1959 · Green Valley Aviation IncN81272Grumman American Avn. AA-5B · S/N AA5B0481Cancelled Apr 18, 2013 · Sale reported, pending cancellation · Built 1977N2235YCessna 177 · S/N 17700035Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1967 · Green Valley AviationN11758Cessna 150L · S/N 15075617Cancelled Jan 30, 2013 · Registration expired, pending cancellation · Built 1974 · Green Valley Aviation IncN40332Maule M-4-220C · S/N 2107CCancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1972 · Green Valley Aviation IncN2351SCessna 337B · S/N 337-0651Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1967 · Green Valley Avn IncN79SDDunning Hal H QUICKIE · S/N 140Cancelled Nov 14, 1994 · Triennial form not returned · Diaz Robert ZN7078TCessna 172 · S/N 46678Cancelled Jul 9, 1979 · Exported to Canada · Green Valley Avaition IncN55033Piper PA-32-300 · S/N 327340096Cancelled Jul 30, 1976 · Dahlin Joel E
Back to Granite Falls, WA