Bradenton, FL
Cancelled registrations · 86
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 = 'FL' AND d.registrant_city = 'BRADENTON' 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 = 'FL' AND d.registrant_city = 'BRADENTON' 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.
N430DBell 430 · S/N 49078N112JTParrot ANAFI AI · S/N PS728310AA2F002777N154MCParrot Drone ANAFI THERMAL · S/N PF728120AD0H005828N632MCDJI MAVIC PRO · S/N 08QCEAS0228CY6N912PMDJI MATRICE 200 V2 · S/N 17SDGB10137155N218MCDJI PHANTOM 4 PRO V2.0 · S/N 11UCF7G0A50614N9213MDJI PHANTOM 4 PRO · S/N 0AXDE1L0A31385N9129EAeronca 11AC · S/N 11AC-762N8158FCessna 150F · S/N 15064258N93556Ercoupe 415-C · S/N 879N912QCDJI MAVIC 2 PRO · S/N 163CH84R0A2ZHJN6765MStinson 108-3 · S/N 108-4765N88773Swift TEENIE TWO · S/N GS001N30CHHolt PDQ-2 · S/N 1-75N8973HNorth American NAVION · S/N NAV-4-973N70347Piper J3C-65 · S/N 17331N9513XCessna 210A · S/N 21057813N3092UCessna 172E · S/N 17250692N8577BCessna 172 · S/N 36277N707EBeech 65 · S/N LC-101N223MLMikoyan Gurevich MIG-23ML · S/N 0390323303N355KMGrumman G-1159 · S/N 226N7250HPiper J3C-65S · S/N 20631N72765Cessna 140 · S/N 9948N99363Engineering & Research ERCOUPE 415-C · S/N 1986N230SPWeaver Philip M TEENIE TWO · S/N 001N7472Fletcher KR-1 · S/N QF3N90703Colyer Lawrence E AVENTURA II · S/N AP2A 0078N32864Piper PA-28-140 · S/N 28-7525123N774USNoles Vance L VANS RV7A · S/N 72389N9435KStinson 108-2 · S/N 108-2435N7273LRaven Industries RX6 · S/N RX6-114N9149Beader Gyrocopter B-8-M-J · S/N JB3960N73150Cessna 172M · S/N 17267291N5212ACessna 310 · S/N 35412N17KCCrum CASSUTT IIIM · S/N CK-1N99435Douglas DC3C · S/N 32899N2662CCessna R182 · S/N R18200200N202FEAero Commander 560 · S/N 225N47KBPiper PA-30 · S/N 30-1205N27CEShoemaker James B KR-2 · S/N 81N5332HPiper PA-16 · S/N 16-138N560BEMartin James R GYROBEE · S/N 001N12SMMeads Sam L BABY ACE D · S/N 1-82N591WSiai-Marchetti FN-333 · S/N 12BISN89366Cessna 152 · S/N 15282726N6182QCessna 152 · S/N 15285187N67861Cessna 152 · S/N 15282065N105AJGulfstream Aerospace G-1159A · S/N 201N96DRPiper PA-28RT-201T · S/N 28R-8231007
Back to Bradenton, FL