Maxwell Afb, AL
Cancelled registrations · 224
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 = 'MAXWELL AFB' 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 = 'MAXWELL AFB' 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.
N291CPCessna 182T · S/N 18281991N939CPTextron 182T · S/N 18282404N5404ECessna 182R · S/N 18268315N784CPCessna 182T · S/N 18281784N2770ZSchweizer SGU 2-22E · S/N 211N342BALet L-23 SUPER BLANIK · S/N 998418N994CPCessna 172R · S/N 17280318N381BALet L-23 SUPER BLANIK · S/N 018801N9514XCessna 182R · S/N 18268542N99162Cessna 172P · S/N 17276413N704DECessna 182Q · S/N 18266237N7771SSchweizer SGS 2-33A · S/N 141N5342GDehavilland BEAVER U-6A · S/N 854N5117NCessna 182Q · S/N 18267528N1981DRaven S55A · S/N S55A-737N4793CDehavilland BEAVER DHC-2 MK.1 · S/N 296N914CPCessna 172S · S/N 172S8334N4810NCessna 182Q · S/N 18267384N4732NCessna 182Q · S/N 18267321N734WACessna 172N · S/N 17269162N7538Schweizer SGS 2-33A · S/N 168N31818Cessna R172E · S/N R172-0194N65844Schweizer SGS 2-33A · S/N 335N50760Cessna 310 · S/N 38116N5134FCessna 172F · S/N 17252909N79058Cessna 172K · S/N 17257850N7887ZCessna 150C · S/N 15059987N99562Cessna 172P · S/N 17276468N98991Cessna 172P · S/N 17276393N396BALet L-23 SUPER BLANIK · S/N 019003N4892NCessna 182Q · S/N 18267441N58630Cessna 182P · S/N 18262187N5079DBeech 65 · S/N LF-31N99087Cessna 172P · S/N 17276400N48256Cessna R172E · S/N R172-0023N1137SSchweizer SGS 1-26E · S/N 517N5779SSchweizer SGS 2-33A · S/N 109N9186ZCherokee II · S/N D.A.D.-15N60663Cessna 150J · S/N 15070486N5122GPiper PA-28-180 · S/N 28-5010N2861ACessna 180 · S/N 30061N26209Cessna R172E · S/N R172-0159N8301TPiper PA-28RT-201 · S/N 28R-8118030N1736FCessna 172H · S/N 17255131N356BALet L-23 SUPER BLANIK · S/N 998420N96960Cessna 172Q · S/N 17276140N2968HSchweizer SGS 2-33A · S/N 558N2046TSchweizer SGS 2-33A · S/N 476N62602Cessna 172P · S/N 17275308N1384UCessna 172M · S/N 17267055
Back to Maxwell Afb, AL