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.

N599AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9289Cancelled Nov 20, 2009 · Sale reportedN559AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9252Cancelled Aug 25, 2009 · Sale reported · Built 2009N527AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9233Cancelled Aug 7, 2009 · Sale reported · Built 2009N531AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9243Cancelled Jun 17, 2009 · Sale reported · Built 2009N551AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9245Cancelled May 15, 2009 · Sale reported · Built 2009N359TAAlenia Aeronautica C27J · S/N 129Cancelled Feb 2, 2009 · Sale reportedN536AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9190Cancelled Nov 7, 2008 · Built 2008 · Eads North America Defense CoN465AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9165Cancelled Nov 6, 2008 · Sale reported · Built 2008N470AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9170Cancelled Sep 22, 2008 · Sale reported · Built 2008N460AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9160Cancelled Sep 19, 2008 · Registration pending · Built 2008N481AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9184Cancelled Sep 19, 2008 · Sale reportedN464AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9164Cancelled Jul 10, 2008 · Sale reportedN423AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9123Cancelled Feb 9, 2008 · Built 2007 · US Army Aviation And Missile CommandN430AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9129Cancelled Nov 30, 2007 · Built 2007 · US Army Aviation And Missile CommandN431AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9132Cancelled Nov 30, 2007 · Built 2007 · US Army Aviation And Missile CommandN424AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9125Cancelled Oct 10, 2007 · Built 2007 · US Army Aviation & Missile CommandN422AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9119Cancelled Aug 2, 2007 · Built 2007 · US Army Aviation And Missile CommandN420AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9116Cancelled Jul 17, 2007 · Built 2007 · US Army Aviation And Missile CommandN5456KCessna 172P · S/N 17274122Cancelled May 23, 2007 · Triennial form not returned · Built 1980 · Redstone Arsenal Flying ActivityN416AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9109Cancelled May 17, 2007 · Built 2006 · US Army Aviation And Missile CommandN410AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9106Cancelled Mar 13, 2007 · Built 2006 · US Army Aviation And Missle CommandN408AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9101Cancelled Feb 16, 2007 · Built 2006 · US Army Aviation & Missile CommandN5099UBoeing CH 47SD · S/N M4287Cancelled Mar 28, 2002 · Exported to GreeceN889AROrlando Helicopter H-19D · S/N OHA55889ARCancelled Jul 25, 1996 · Triennial form not returned · Commander US Army Missile CommandN789AROrlando Helicopter H-19D · S/N OHA55789ARCancelled Sep 6, 1995 · Commander US Army Missile CommandN910AROrlando Helicopter H-19D · S/N OHA55109ARCancelled Oct 21, 1994 · United States Army Missile CommandN159AROrlando Helicopter H-19D · S/N OHA55159ARCancelled Oct 28, 1993 · US Army Missile CommandN288AROrlando Helicopter H-19D · S/N 0HA55288ARCancelled Oct 28, 1993 · Commander US Army Missile CommandN689AROrlando Helicopter H-19D · S/N OHA55689ARCancelled Oct 28, 1993 · US Army Missile CommandN989AROrlando Helicopter H-19D · S/N OHA55989ARCancelled Sep 11, 1993 · US Army Missile CommandN139AROrlando Helicopter H-19 · S/N OHA55139ARCancelled May 14, 1993 · Triennial form not returned · US Army Missile CommandN119AROrlando Helicopter H-19D · S/N OHA55119ARCancelled Sep 17, 1992 · Commander US Army Missile CommandN149AROrlando Helicopter H-19D · S/N OHA55149ARCancelled May 22, 1992 · US Army Missile CommandN188AROrlando Helicopter H-19D · S/N 0HA55188ARCancelled Oct 28, 1991 · Triennial form not returned · US Army Missile CommandN92473Canadair F-86E MK.6 · S/N 1099Cancelled Jun 1, 1983 · Sale reported · Built 1954N6095Cessna R172E · S/N R172-0136Cancelled Apr 10, 1975 · Redstone Arsenal Flying Club
Back to Redstone Arsenal, AL