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.
N5986SBeech A23-19 · S/N MB-81N4848KPiper PA-22 · S/N 22-1776N4272EMD Helicopters 369E · S/N 0609EN43656MD Helicopters 369E · S/N 0608EN40899MD Helicopters 369E · S/N 0610EN396AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9639N593AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9618N55158North Wing APACHE · S/N EWCJDH02N5515AParascender II · S/N 220068N25MZPdps Pzl-Bielsko SZD-48-3 · S/N B-2074N7514QMoore PPCLSA · S/N 001N33GEHamlett James E GLASAIR III · S/N 3021N7421UBalloon Works FIREFLY 7 · S/N F7-360N6541QAerostar International RX-7 · S/N RX7-3140N250PRPiper PA-23-250 · S/N 27-3062N98JRRadowski SONERAI II · S/N 150N94049Ercoupe 415-C · S/N 1372N4241YRaven S55A · S/N S55A-1036N7148HBarber Christopher A QUICKIE PLUS · S/N 1373N763RTViking Air DHC-6-400 · S/N 863N7053CHughes TH-55 · S/N 67-16748N4551RGulfstream American AA-5B · S/N AA5B1194N5596AHill James E BENSEN B-8M · S/N 1N7589YPiper PA-30 · S/N 30-656N2994NCameron Balloons US N-77 · S/N 5231N19VVCessna 402C · S/N 402C0454N30DESmith Donald E GLASAIR SH-2 · S/N 130N762RTViking Air DHC-6-400 · S/N 862N752RTViking Air DHC-6-400 · S/N 852N90692Smith AEROSTAR 601P · S/N 61P-0335-097N2493ECessna 172N · S/N 17271300N6168LAmerican AA-1 · S/N AA1-0368N98250Canadair F-86 MK.5 · S/N 1049N4049YBalloon Works FIREFLY 7 · S/N 7926N14RAAustin Robert MONERAI-S · S/N 2-358N36324Taylorcraft BC12-D · S/N 6404N7473HPiper J3C-65 · S/N 20740N75779Powrachute PC 2000 · S/N A-247POWN4848HPiper PA-17 · S/N 17-147N1428QCessna 150L · S/N 15072728N341AEAmerican Eurocopter MBB-BK 117 C-2 · S/N 9489N30FSSanders Fred G PITTS S1 · S/N 2389N9030NBlunt Ruben J VANS RV-3 · S/N 417N13MBBabin Michael GREAT LAKES · S/N 6705F-76BN59168Cessna 210L · S/N 21060138N164SEStone SUPER PETREL 100 · S/N 164N31506Stinson 10A · S/N 7757N3211XCessna 150G · S/N 15064611N177DCougar 1 · S/N 111220N7820HPiper PA-12 · S/N 12-718
Back to Huntsville, AL