Huntsville, AL
Cancelled registrations · 227
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 = 'HUNTSVILLE' 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 = 'HUNTSVILLE' 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.
N242AMoon O E / Cavalaris J G LANCAIR · S/N 010N2467XCessna T206H · S/N T20608155N12TATremblay Kathleen DRIFTER SB · S/N 1034SBN81GHCessna T210N · S/N 21064355N496DDDunaway Dennis Gaines JR MINI MAX 1600 · S/N 0001N6408CTerkeurst Jr/Gardner/Sharp JR MU582 DRIFTER · S/N LL1043N8KDBergmann Gary RANS S-12XL · S/N 05950597N22CQAerospatiale SA365N · S/N 6061N769LWBeech A36 · S/N E1028N71089Balloon Works FIREFLY 7 · S/N F7-397N110WFFitzpatrick Wesley F KB-2 GYROPLANE · S/N KB-2-WF-1N391WNorth American T-28B · S/N 138266N2142SCessna T210L · S/N 21061103N1455JRockwell International 112A · S/N 455N5112PPiper PA-24 · S/N 24124N4720JBeech A23-19 · S/N MB178N13738Cessna 172M · S/N 17262984N3929HEngineering & Research ERCOUPE 415-CD · S/N 4630N3742YCessna 210D · S/N 21058242N757DNCessna 152 · S/N 15279658N9388KStinson 108-2 · S/N 108-2388N46791Canadair F-86 MK.5 · S/N 1129N70726Canadair F-86E MK.6 · S/N 1081N92426Canadair F-86E MK.6 · S/N 925N201XCanadair F-86 MK.5 · S/N 993N2290RCanadair F-86E MK.6 · S/N 1017N2290ZCanadair F-86E MK.6 · S/N 1073N98270Canadair F-86E MK.6 · S/N 1142N99605Canadair F-86E MK.6 · S/N 818N8948KUniversal Stinson 108-1 · S/N 1081948N205HLBellanca 8KCAB · S/N 422-78N42799Piper J3C-65 · S/N 15114N5925JCessna 182P · S/N 18263580N22626Cessna 150H · S/N 15068410N3546HErcoupe 415-C · S/N 4171N72491Canadair F-86 MK.5 · S/N 937N3314GHamilton T-28R-2 · S/N 2N47324Taylorcraft DCO-65 · S/N 5163N3639RPiper PA-28-180 · S/N 28-5734N5901WPiper PA-28-160 · S/N 28-2966N3881KTemco GC-1B · S/N 3581N51184Fairchild M-62A · S/N T43-5624N3860BBeech F35 · S/N D-4127N6477QMooney M20F · S/N 680019N3762SCessna 172E · S/N 17250962N4109VCessna 170 · S/N 18441N2PLLeeper BD-5 · S/N 1604N15218Piper PA-28-235 · S/N 28-7310023N8261XCessna 172C · S/N 17248761N9281JPiper PA-28-180 · S/N 28-3361
Back to Huntsville, AL