OpenAirDocs.org
Cheyenne, WY

Cancelled registrations · 299

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

N733HLBoeing 737-229 · S/N 21176Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Red Cloud Assets LLCN737HLBoeing 737-229 · S/N 21177Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Red Cloud Assets LLCN804MRBritish Aerospace BAE 125 SERIES 800A · S/N 258012Cancelled Jan 12, 2017 · Exported to Mexico · Built 1984 · Mountain Aviation LLCN6709YBeech 76 · S/N ME-307Cancelled Nov 2, 2016 · Built 1979 · N6709y LLCN330CCAerospatiale SA330J · S/N 1589Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1979 · Roberts Aircraft CoN742RMBell Helicopter Textron Canada 407 · S/N 54354Cancelled Jan 29, 2015 · Exported to Guatemala · Built 2012 · Advanced Aviation Consultant LLCN11630Cessna 150L · S/N 15075584Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1974 · Bedrock Investments LLCN412JTGrumman G-1159 · S/N 101Cancelled Dec 11, 2014 · Third renewal notice · Built 1970 · Jetsteam Aviation IncN268WCGates Learjet 25D · S/N 268Cancelled Dec 10, 2014 · Third renewal notice · Jetsteam Aviation IncN405DWBritish Aerospace HS 125-700A · S/N 257130Cancelled Dec 10, 2014 · Third renewal notice · Built 1981 · Oasis Travel Services IncN366JAGulfstream American G-1159A · S/N 366Cancelled Dec 9, 2014 · Third renewal notice · Built 1982 · Aero Investments LLCN6389XSchleicher KA 6 BR · S/N 340Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1962 · Johnson Erik A IIN6485UMooney M20C · S/N 2232Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1962 · Edwards Dorsey DN31660Aerospatiale SA316B ALOUETTE III · S/N 1481Cancelled Oct 30, 2014 · First renewal notice · Built 1967 · Roberts Aircraft CompanyN402AHAerospatiale SA315B · S/N 2484Cancelled Oct 30, 2014 · First renewal notice · Roberts Aircraft CompanyN5924LAmerican AA-1 · S/N AA1-0224Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1969 · Oconnor Bo RN650KAGrumman G-1159 · S/N 50Cancelled Oct 7, 2014 · Exported to Dominican Republic · Built 1969 · Ford Electric CoN707EXAerospatiale SA315B · S/N 2430Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1976 · Roberts Aircraft CompanyN82465Piper PA-34-200T · S/N 34-8070328Cancelled Aug 25, 2014 · Exported to Brazil · Built 1980 · Harpia Investment Group LLCN315AVAerospatiale SA315B · S/N 2549Cancelled Aug 8, 2014 · Registration expired · Built 1979 · Roberts Aircraft CoN48184Aerospatiale SA316B ALOUETTE III · S/N 1906Cancelled Aug 8, 2014 · First renewal notice · Built 1970 · Roberts Aircraft CoN48HJAerospatiale SA315B · S/N 2341Cancelled Aug 8, 2014 · First renewal notice · Built 1973 · Roberts Aircraft CoN62339Aerospatiale SA315B · S/N 2401Cancelled Aug 8, 2014 · First renewal notice · Roberts Aircraft CoN929JVEurocopter SA315B · S/N 2361Cancelled Aug 8, 2014 · Registration expired · Built 1973 · Roberts Aircraft CoN83HFBritish Aerospace HS 125-700A · S/N NA0339Cancelled Jul 2, 2014 · Third renewal notice · Built 1981 · Mountain Aviation LLCN7264CLockheed PV-2 · S/N 15-1552Cancelled Oct 24, 2013 · Registration expired, pending cancellation · RalcoN7040CRobinson Helicopter R22 BETA · S/N 3187Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 2001 · Plexis Management IncN5404JConsolidated-Vultee 28-5ACF · S/N 22022Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Neptune Aero Marine IncN55015ECK David QUICKSILVER MXLII SP · S/N N0767816Cancelled Aug 28, 2013 · Sale reported, canceled · Built 2004N370MHAerospatiale SA330J · S/N 1304Cancelled Aug 23, 2013 · Sale reported, canceledN377JBHenley STARDUSTER TOO · S/N LH1Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1973N1769XCessna T210L · S/N 21060790Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1975 · Smith Thomas RN5163YPiper PA-23-250 · S/N 27-2203Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1962N8YFLong Jack D LONG 2000 · S/N H2-01-12-519Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 2002 · Long Jack DN8520UCessna 172F · S/N 17252420Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1964 · Bedrock Investments LLCN131WAArland Warren/Dave EAA SPORT BIPLANE · S/N A-001Cancelled May 6, 2013 · Registration expired, pending cancellation · Arland Warren DN2935MPiper PA-34-200T · S/N 34-7870100Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1977 · Sky Harbor Air Service IncN5745TCessna 172E · S/N 17251645Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1964N731HLBoeing 737-229 · S/N 20911Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Red Cloud Assets LLCN278FKRobinson Helicopter R44 · S/N 0018Cancelled Oct 16, 2012 · Airjohn LLCN41120Raven Industries RALLY RX7 · S/N RX7-338Cancelled Aug 10, 2012 · Registration pending, canceled · Built 1984N24RNGlandt Dan A RICK 1 · S/N DAG-2Cancelled Jul 17, 2012 · Built 2011 · Glandt Dan AN17781Aeronca K · S/N K50Cancelled Apr 12, 2012 · Registration pending, pending cancellationN151GLBeech 1900D · S/N UE-151Cancelled Apr 9, 2012 · First renewal notice · Built 1995 · Great Lakes Aviation LtdN2128ZAerospatiale SA315B · S/N 062014Cancelled Jan 9, 2012 · Built 1972 · Roberts Aircraft CoN316HPAerospatiale SA316B ALOUETTE III · S/N 1539Cancelled Jan 9, 2012 · Built 1969 · Roberts Aircraft CoN198GTBritish Aerospace HS 125-700A · S/N NA0288Cancelled Oct 12, 2011 · Exported to Mexico · Built 1980 · Aero Investments LLCN1235AAerospatiale SA316B ALOUETTE III · S/N 1235Cancelled Sep 28, 2011 · First renewal notice · Built 1964 · Roberts Aircraft CompanyN1521KAerospatiale SA316B ALOUETTE III · S/N 1521Cancelled Sep 28, 2011 · First renewal notice · Built 1964 · Roberts Aircraft CoN49525Aerospatiale SA315B · S/N 2492Cancelled Sep 28, 2011 · First renewal notice · Built 1976 · Roberts Aircraft Co
Back to Cheyenne, WY