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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N599AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9289N559AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9252N527AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9233N531AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9243N551AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9245N359TAAlenia Aeronautica C27J · S/N 129N536AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9190N465AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9165N470AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9170N460AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9160N481AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9184N464AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9164N423AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9123N430AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9129N431AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9132N424AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9125N422AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9119N420AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9116N5456KCessna 172P · S/N 17274122N416AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9109N410AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9106N408AEEurocopter Deutschland MBB-BK 117 C-2 · S/N 9101N5099UBoeing CH 47SD · S/N M4287N889AROrlando Helicopter H-19D · S/N OHA55889ARN789AROrlando Helicopter H-19D · S/N OHA55789ARN910AROrlando Helicopter H-19D · S/N OHA55109ARN159AROrlando Helicopter H-19D · S/N OHA55159ARN288AROrlando Helicopter H-19D · S/N 0HA55288ARN689AROrlando Helicopter H-19D · S/N OHA55689ARN989AROrlando Helicopter H-19D · S/N OHA55989ARN139AROrlando Helicopter H-19 · S/N OHA55139ARN119AROrlando Helicopter H-19D · S/N OHA55119ARN149AROrlando Helicopter H-19D · S/N OHA55149ARN188AROrlando Helicopter H-19D · S/N 0HA55188ARN92473Canadair F-86E MK.6 · S/N 1099N6095Cessna R172E · S/N R172-0136
Back to Redstone Arsenal, AL