Bradenton, FL
Registered aircraft · 137
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'FL' AND g.registrant_city = 'BRADENTON' ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'FL' AND g.registrant_city = 'BRADENTON' ORDER BY g.n_number
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.
N1088VCessna R172K · S/N R1722112N11802Cessna 172S · S/N 172S10463N1247JAero Commander 112 · S/N 247N155FTParrot ANAFI · S/N PS728000AA8G041918N15EZCubcrafters CC11-160 · S/N CC11-00371N1662CO'Connell Jeffrey J SUPER CAT · S/N 001First renewal noticeN170ARCessna 170B · S/N 20604N1733MSkydio SKYDIO 2T · S/N 1668BS20FB00ZW2UN174FFBo 105 S CBS · S/N S-913N1852SBeech A36 · S/N E-1923N19207Cessna 150L · S/N 15074237N203SPiper PA-23-150 · S/N 23-412N205FLSkydio 2+ · S/N S2.0J.B.00C9RDN213RMJames R Martin GYRO 02 · S/N 02N220ECRobinson Helicopter R44 II · S/N 14586N230QMSkydio SKYDIO 2T · S/N 1668BS20JB00R3TCN241MCDJI INSPIRE 2 · S/N 09YDG9P0R4JR11N242GFInspired Flights Tech IF1200A · S/N 1791553467N242VMInspired Flights Tech IF1200A · S/N 1791553462N2478NCessna 120 · S/N 12731N255MJBuckeye Industries DREAM MACHINE 582 · S/N 4886N2580DCessna 170B · S/N 20732N262BWEngineering & Research ERCOUPE 415-C · S/N 4295N27AKCessna 182Q · S/N 18266826N28059Bellanca 17-30A · S/N 79-30964N28655Grumman American Avn. AA-5B · S/N AA5B0731N2879CPiper PA-28RT-201T · S/N 28R-7931237N289RSShoemaker Ronald R PAZMANY PL-2 · S/N 089N289SBCirrus Design SR22 · S/N 1102N2901LBeech 58 · S/N TH-1172N29422Cessna 177 · S/N 17700878N2943YPiper PA-28RT-201T · S/N 28R-7931267N303MCDJI MAVIC PRO · S/N 08Q3G9QP0SWD13N30581Hardie Steven AIR CAM · S/N AC0096N3080NCessna 120 · S/N 13338N328RMMartin James R GATOR GYROPLANE · S/N 1N330XSExtra Flugzeugproduktions EA 300/SC · S/N SC048N331MCDJI MAVIC 2 PRO · S/N 1633J6G001M044N3323MPiper PA-28-181 · S/N 28-7890296N3425XMooney M20E · S/N 1121N345LBVans RV-12 · S/N 120347N3482APiper PA-22 · S/N 22-1748N34944Cessna 177RG · S/N 177RG1027N351TWCirrus Design SR22T · S/N 10597N3547RCessna 172R · S/N 17281066N361RDCirrus Design SR22T · S/N 10560N363FFSkydio X10 · S/N 1668BR4EA00Z8TVN363HMWingtra WINGTRA ONE GEN II · S/N 174445771N363ZMSkydio 2+ · S/N 1668BS20JB00X4TTN367VMSkydio SR47PCV · S/N SKYDIO X10-NZ8D
Back to Bradenton, FL