Cocoa, FL
Registered aircraft · 49
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 = 'COCOA' 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 = 'COCOA' 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.
N1109DCessna 140A · S/N 15669N124FAMagnus FUSION 212I · S/N MG11-002N1392DCessna 170A · S/N 19968N1513TPiper PA-32-300 · S/N 32-7240128N1587SBeech 95-A55 · S/N TC-322N2005PPiper PA-23-150 · S/N 23-574N20FQSocata TB21 · S/N 638N214LAVans RV-12 · S/N 120229N21YCPiper PA-34-200T · S/N 34-7770375N22DXCessna 182A · S/N 51442N231JPCessna 414 · S/N 414-0628N247APCessna 172K · S/N 17259066N2907ZBellanca 8KCAB · S/N 377-78N2950WPiper PA-28-161 · S/N 28--7916577N2973BBeech D35 · S/N D-3613N2YRCessna U206F · S/N U20601737N32393Piper PA-28R-200 · S/N 28R-7535050N3252FMooney M20E · S/N 670045N3360FCessna 182J · S/N 18257360N3733QBeech 95-C55 · S/N TE-294N38GHPiper PA-28-180 · S/N 28-4264N398CDWings Of Paradise DRIFTER · S/N UA-007N45575Weber Eugene F BEE DIFFERENT · S/N 1N4619HPiper PA-17 · S/N 17-36N4989JPiper PA-28R-180 · S/N 28R-30744N5053YPiper PA-32R-301T · S/N 3257242N514RMPiper PA-28-181 · S/N 2843661N53617Cessna 337G · S/N 33701740N540VPaul Vagner TANGO 2 · S/N 000002N5571JPiper PA-32-260 · S/N 32-997N580SMTextron G58 · S/N TH-2444N5924FPiper PA-28-151 · S/N 28-7715159N606APAviat A-1C-200 · S/N 3064N61NFAviat A-1C-180 · S/N 3215N6262HPiper PA-23-250 · S/N 27-3354N62MLLockhart Michael R Rans S12 S12 · S/N 03960701N63885Piper PA-23-250 · S/N 27-7854030N6511SCessna 150H · S/N 15067311N65GLMooney M20E · S/N 542N69729Cessna 310Q · S/N 310Q0946N704AECessna 150M · S/N 15078452N704DGCessna 150M · S/N 15078524N777PPBeech A45 · S/N G-278N8065HCherokee Breezy Club BREEZY · S/N 434N90957Piper PA-18-150 · S/N 18-8109041N9241WPiper PA-28-235 · S/N 28-10911N9329VDestiny Powered Parachutes DESTINY 2000 PPC · S/N 1C0280N93938Engineering & Research ERCOUPE 415-C · S/N 1261N99337Ercoupe 415-C · S/N 1960
Back to Cocoa, FL