OpenAirDocs.org
Cody, WY

Cancelled registrations · 40

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 = 'WY' AND d.registrant_city = 'CODY'
  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.

N1474VCessna 172M · S/N 17263609Cancelled Jan 31, 2026 · Sale reported, canceled · Built 1974N796CBMerrill Brian KITFOX 5 OUTBACK · S/N S9807-0165Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2000 · Card Joseph WN89AMCessna 340 · S/N 340-0545Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1975 · Windy Point Aviation LLCN228BBDJI INSPIRE 1 · S/N WM6101510Cancelled May 1, 2020 · Registration expired, pending cancellation · Bigjon'S Backhoe Service LLCN773NSSensefly EBEE · S/N EB-03-897Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Graham Dietz & Associates DBA Gda EngineersN595LXDJI PHANTOM 3 PROFESSION · S/N P78DCE16031044Cancelled Jan 22, 2019 · Registration expired, pending cancellation · Mccue Michael JN5038FFairchild Hiller FH-1100 · S/N 186Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1969 · Harrison Timothy BruceN6283EStrauch Henry BD-4 · S/N 95250Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Clark Vernon F TrusteeN104DRCessna 310H · S/N 310H0021Cancelled Jun 30, 2014 · Second renewal notice · Built 1962 · Cody KitN72232Cessna 140 · S/N 9405Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1946N29USPiccard AX-6 · S/N 629Cancelled Aug 30, 2012 · Registration pending, canceled · Built 1972N3633ZAerostar International RX 8 · S/N RX8-3048Cancelled Mar 21, 2012 · Second renewal notice · Built 1990 · Garlow Lindsay JN824BTEurocopter AS 350 B3 · S/N 3326Cancelled Jun 4, 2010 · Exported to Chile · Built 2000 · Vertical Lift LLCN8055HBeech C18S · S/N 44-47121Cancelled Sep 18, 2009 · Registration revoked · Skyways IncN86RBElkins Alan LANCAIR IV P · S/N LIV-309Cancelled Nov 4, 2004 · Exported to Mexico · Built 1997 · Barker Rotchford LN7155BPiper PA-22-150 · S/N 22-4379Cancelled Apr 15, 2004 · Second triennial mailing, no response · Built 1956 · Bickham Mark DanaN6574LPiper PA-18-150 · S/N 18-7409106Cancelled Jul 17, 2003 · Exported to Canada · Built 1974 · Foundation For North American Wild SheepN88PLPiper PA-46-310P · S/N 46-8508099Cancelled Jun 16, 2003 · Exported to France · Built 1985 · Clarkco LtdN365NHoward 500 · S/N 500-101Cancelled Aug 9, 1987 · Exported to Canada · Built 1963 · Husky Aviation IncN733GRCessna 172N · S/N 17268288Cancelled Sep 26, 1978 · Exported to New Zealand · Weamer RoyN8681QBeech S35 · S/N D 7695Cancelled Oct 4, 1976 · Shreck RoyN7690DPiper PA-18-150 · S/N 18-5916Cancelled May 9, 1975 · Exported to Canada · Elgin John WN7451Vickers VISCOUNT 745-D · S/N 207Cancelled Aug 30, 1974 · Aero Flite IncN28409Luscombe 8A · S/N 1276Cancelled Jun 21, 1973 · Wayne E AndersonN366NCessna TP206B · S/N P206-0402Cancelled Aug 18, 1972 · Exported to Bolivia · Husky Aviation IncN1340NBoeing B-17F · S/N 42-6107Cancelled Dec 1, 1971 · Built 1942 · Aero Flite IncN2649JCessna 150G · S/N 15065649Cancelled Jun 16, 1970 · Aero Flite IncN4077JCessna 150G · S/N 15065377Cancelled Jun 16, 1970 · Aero Flite IncN7228CBoeing B-17G · S/N 77226Cancelled Nov 16, 1967 · Aero Flite IncN4374APiper PA-18-150 · S/N 18-4776Cancelled Feb 23, 1967 · Exported to Canada · Built 1956 · Skyways IncN3946MPiper PA-12 · S/N 12-2836Cancelled May 25, 1965 · Clarke P YaugerN49052Fairchild PT-19A · S/N T423335Cancelled May 22, 1965 · Allen John EN73075Cessna 140 · S/N 10291Cancelled Mar 16, 1958 · Ray James NN33928Taylorcraft BL-65 · S/N 2778Cancelled Jan 8, 1957 · Skaggs BobN50006Fairchild M-62A · S/N T43-5054Cancelled Oct 21, 1955 · Alfred E KellerN49237Fairchild PT-19 · S/N T40-424Cancelled Feb 9, 1955 · John P WehrN2970KLuscombe 8A · S/N 5697Cancelled Aug 18, 1953 · Yauger Clarke PN3092VBeech 35 · S/N D-508Cancelled Aug 3, 1950 · Mountain States Drilling CoN9116ACessna 170A · S/N 18875Cancelled May 22, 1950 · Rocky Mountain Air ServiceN6151ECessna 172 · S/N 46251Cancellation date not recorded · Skyways Inc
Back to Cody, WY