OpenAirDocs.org
Redstone Arsenal, AL

Cancelled registrations · 136

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 = 'AL' AND d.registrant_city = 'REDSTONE ARSENAL'
  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.

N6061VMD Helicopters 369FF · S/N 0260FFCancelled Sep 13, 2016 · Sale reported · Built 2016N6065DMD Helicopters 369FF · S/N 0265FFCancelled Sep 13, 2016 · Sale reported · Built 2016N6070ZMD Helicopters 369FF · S/N 0258FFCancelled Sep 13, 2016 · Sale reported · Built 2016N61006MD Helicopters 369FF · S/N 0261FFCancelled Sep 13, 2016 · Sale reported · Built 2016N4290YMD Helicopters 369FF · S/N 0180FFCancelled Aug 24, 2016 · Exported to Afghanistan · Built 2011 · US Army Contracting Command - RedstoneN3897DMD Helicopters 369FF · S/N 0179FFCancelled May 2, 2016 · Built 2011 · U S Army Contracting Command-RedstoneN43188MD Helicopters 369FF · S/N 0181FFCancelled May 2, 2016 · Exported to Afghanistan · Built 2011 · US Army Contracting Command - RedstoneN4339EMD Helicopters 369FF · S/N 0183FFCancelled May 2, 2016 · Exported to Afghanistan · Built 2011 · U S Army Contracting Command-RedstoneN4340RMD Helicopters 369FF · S/N 0184FFCancelled May 2, 2016 · Exported to Afghanistan · Built 2011 · U S Army Contracting Command-RedstoneN235AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9719Cancelled Feb 10, 2016 · Sale reported · Built 2015N178AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9703Cancelled Jul 28, 2015 · Sale reported · Built 2015N6061ZMD Helicopters 369FF · S/N 0220FFCancelled Apr 15, 2015 · Sale reported · Built 2014N6068HMD Helicopters 369FF · S/N 0214FFCancelled Apr 14, 2015 · Sale reported · Built 2014N114AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9690Cancelled Jan 28, 2015 · Sale reportedN901AEAirbus Helicopters MBB-BK 117 C-2 · S/N 9654Cancelled Dec 18, 2014 · Sale reported · Built 2014N124GLCessna 208B · S/N 208B0406Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1994 · U S Army - AmrdecN940AEAirbus Helicopters MBB-BK 117 C-2 · S/N 9674Cancelled Oct 23, 2014 · Sale reported · Built 2014N795AEAirbus Helicopters MBB-BK 117 C-2 · S/N 9670Cancelled Sep 17, 2014 · Sale reportedN741AEAirbus Helicopters MBB-BK 117 C-2 · S/N 9660Cancelled Jul 23, 2014 · Built 2014 · US Army Aviation And Missile CommandN756AEAirbus Helicopters MBB-BK 117 C-2 · S/N 9651Cancelled May 22, 2014 · Sale reported · Built 2014N703AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9643Cancelled Apr 25, 2014 · Sale reported · Built 2014N212AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9593Cancelled Jan 13, 2014 · Sale reported · Built 2013N44515Bell Helicopter Textron 445 · S/N 53903Cancelled Jan 13, 2014 · Sale reported · Built 2006N388AROrlando Helicopter H-19 · S/N 0HA55-388ARCancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1988 · United States Army Missile CommandN44548Bell 445 · S/N 53904Cancelled Aug 28, 2013 · Sale reported, canceled · Built 2006N445ARBell 445 · S/N 53905Cancelled Aug 28, 2013 · Sale reported, canceled · Built 2006N445LNBell 445 · S/N 81001Cancelled Aug 28, 2013 · Sale reported, canceledN98279Canadair F-86 MK.5 · S/N 1113Cancelled Mar 21, 2013 · Sale reported, canceledN788AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9553Cancelled Mar 18, 2013 · US Army Aviation And Missile CommandN778AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9548Cancelled Feb 12, 2013 · US Army Aviation And Missile CommandN98230Canadair F-86 MK.5 · S/N 980Cancelled Jan 7, 2013 · Sale reported, pending cancellation · Built 1954N544AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9519Cancelled Dec 19, 2012 · Sale reportedN520AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9516Cancelled Oct 18, 2012 · Sale reported · Built 2012N442AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9149Cancelled Sep 12, 2012 · Registration pending, canceled · Built 2007N361AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9495Cancelled Jun 18, 2012 · US Army Aviation And Missile CommandN331AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9487Cancelled May 30, 2012 · Sale reported · Built 2012N276AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9480Cancelled May 18, 2012 · Sale reported · Built 2012N297AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9483Cancelled May 18, 2012 · Sale reported · Built 2012N452AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9159Cancelled Feb 27, 2012 · Registration pending, pending cancellation · Built 2008N252AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9470Cancelled Feb 21, 2012 · Sale reported · Built 2011N443AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9150Cancelled Feb 21, 2012 · Registration pending · Built 2008N450AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9155Cancelled Feb 21, 2012 · Registration pending · Built 2008N180AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9455Cancelled Jan 10, 2012 · Sale reported · Built 2011N104AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9440Cancelled Oct 4, 2011 · Sale reported · Built 2011N994AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9434Cancelled Sep 23, 2011 · Sale reported · Built 2011N141AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9422Cancelled Aug 10, 2011 · Sale reported · Built 2011N984AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9412Cancelled Jun 15, 2011 · Sale reported · Built 2011N461AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9163Cancelled Jan 24, 2011 · Sale reported · Built 2008N879AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9386Cancelled Jan 13, 2011 · Sale reported · Built 2010N776AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9360Cancelled Oct 19, 2010 · Sale reported · Built 2010
Back to Redstone Arsenal, AL