OpenAirDocs.org
Durango, CO

Cancelled registrations · 51

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 = 'CO' AND d.registrant_city = 'DURANGO'
  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.

N791YCDJI PHANTOM 3 PROFESSION · S/N P78DCL18071143Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Coldwell Banker Heritage House RealtorsN97WRAir Creation CLIPPER · S/N T04011Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 2004 · Mauk DanielN136SCSix Chuter LEGEND XL · S/N 3100Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Wales Charles BN42QCLamb Michael S LAMB-RACER · S/N 001Cancelled Nov 13, 2020 · Exported to United Kingdom · Built 1998 · Q & A Co LLCN726RDRupp Roger J RUTAN DEFIANT · S/N 26Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1988 · Bolton Harry PN9031MCessna 182P · S/N 18264650Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1976 · Mainwaring Angela GN91JFFickler John L MURPHY REBEL · S/N 592RCancelled Jan 29, 2018 · Registration expired, pending cancellation · Sablosky Bradford AN6574PSix Chuter SR2 · S/N 95-1359-2Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1995 · Nelson Wade HN30FRLashley Douglas/Rocketworksllc TEAM ROCKET LPF-1EVO · S/N 166Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Rocketworks LLCN25153Socata TB21 · S/N 968Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Osborne Stephen WN261TPipistrel TAURUS · S/N 051 T 503Cancelled Oct 25, 2017 · Registration expired, pending cancellation · Built 2009 · Gemtec IncN310AKCessna 310 · S/N 35189Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1955 · Oldenburg C.M.N30850Charles Paul D MONOPLANE II · S/N A-76Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Olson Arthur JN8923YPiper PA-30 · S/N 30-1996Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1969 · Westberg Craig SN7248SCessna 150H · S/N 15067948Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1967 · Smithback Mark AN735QNCessna 182Q · S/N 18265602Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · Croom Ted TN800RWCirrus Design SR22 · S/N 1266Cancelled Apr 9, 2014 · Third renewal notice · Built 2005 · Durango Development IncN17LEGrantham Richard J LONG-EZ · S/N 1464Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Barnes Daudi MN82535Potter/Challenger II · S/N 1265Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1995 · Hawks Roscoe L DBAN6360ECessna 172 · S/N 46460Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1959 · Walker Mary LN57307Raven S-60A · S/N S60A-176Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1981 · Bridwell Timothy JN411PCPiper PA-23-250 · S/N 27-3931Cancelled Mar 11, 2013 · Sale reported, pending cancellation · Built 1968N808JCDG Flugzeugbau DG-800B · S/N 8-230B144Cancelled Aug 23, 2012 · Exported to Canada · Built 2001 · Piotrowski David JN823TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 2468USACancelled May 15, 2012 · Third renewal notice · Built 1994 · Lenberg Douglas DN110AZDoktor Fiberglas H101 SALTO · S/N 61Cancelled Jul 20, 2011 · Exported to Australia · Built 1985 · Brueckner ThomasN99860Let BLANIK L-13 · S/N 026511Cancelled Jul 30, 2007 · Built 1976 · St Clair Lavern DN93379Cessna T210L · S/N 21060383Cancelled May 23, 2007 · Exported to Canada · Built 1974 · Scarafiotti TimN409EXCessna 404 · S/N 404-0436Cancelled Apr 8, 2004 · Exported to Venezuela · Built 1979 · Durango Air Service IncN8264MCessna 210K · S/N 21059264Cancelled Aug 19, 2003 · Built 1970 · Brown William F JrN725STSabian Kenneth A RANS S12-XL · S/N 03990875Cancelled Jan 8, 2003 · Built 2001 · Sabian Ken AN182BGCessna R182 · S/N R18200256Cancelled Apr 29, 2002 · Triennial form not returned · Built 1978 · Durango Air Services IncN444AECessna 182K · S/N 18257963Cancelled Dec 8, 2000 · Exported to Canada · May William CN8611RSchweizer SGS 1-26B · S/N 137Cancelled Sep 12, 2000 · Triennial form not returned · St Clair La Vern DN6JEEichar John L VENTURE · S/N V111PNCancelled Aug 31, 1998 · Second triennial mailing, no response · Eichar John LN4834VCessna 172RG · S/N 172RG0395Cancelled Apr 7, 1997 · Triennial form not returned · Durango Air Service IncN2781VCessna 177RG · S/N 177RG0695Cancelled Aug 6, 1996 · Exported to Canada · Oldenburg C MN773JBCessna 182N · S/N 18260610Cancelled Jul 19, 1994 · Triennial form not returned · Gregg Flying Service IncN4807UCessna 210-5A(205A) · S/N 2050507Cancelled Aug 17, 1992 · Triennial form not returned · Wilson James MN8266UPiper PA-28-181 · S/N 288390002Cancelled Mar 27, 1991 · Triennial form not returned · Newton EnterprisesN8862BCessna 172 · S/N 36562Cancelled Apr 27, 1983 · Administratively canceled · Lamunyon Harold EN75564Cessna 172N · S/N 17267813Cancelled Jan 4, 1983 · Hamilton E Bentley JrN7616SBellanca 8GCBC · S/N 204-76Cancelled Jun 21, 1979 · Exported to Canada · Stonehouse J EN9247MMooney M20C · S/N 3450Cancelled May 24, 1973 · Baars Donald LN6305Bensen B-8M · S/N LA00001Cancelled Jun 23, 1971 · Sub-Surface Machine Mfg IncN6820ACessna 172 · S/N 28920Cancelled Apr 15, 1965 · Gregg Flying ServiceN24132Akron B · S/N 58Cancelled Jan 18, 1951 · Built 1940 · Hocker Jess L Et AlN64426Lockheed P-38M · S/N 5794Cancelled Jan 17, 1949 · Hardwick JackN21079Aeronca KCA · S/N KCA-51Cancelled Jun 10, 1948 · Hardwick Jack Bcheckerboard AirwaysN76319Cessna 140 · S/N 10733Cancelled Dec 17, 1947 · Laplata Flying ServiceN89543Cessna 140 · S/N 8579Cancelled Oct 7, 1947 · La Plata Flying Service
Back to Durango, CO