Rockledge, FL
Registered aircraft · 43
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 = 'ROCKLEDGE' 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 = 'ROCKLEDGE' 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.
N115BRTextron 182T · S/N 18282415N1409RGrumman American Avn. AA-1B · S/N AA1B-0509N1427ZNussbaum T J/Nussbaum J E RUTAN VARIEZE · S/N 81N1447GBeech 35-B33 · S/N CD-461N182LXCessna 182P · S/N 18262627N183SPCessna 172N · S/N 172-68675N188LGPiper PA 46-350P · S/N 4622043N195SECessna 195 · S/N 7857N29982Waco UPF-7 · S/N 5479N300XLIsrael Aircraft Industries 1124 · S/N 276N318BSUtter Roy G RANS S-12 AIRAILE · S/N 1093441N369YGreg J Swingle GLASAIR SPORTSMAN · S/N 0007123N3744QPiper PA-28-181 · S/N 28-7790465N40837Piper J3C-65 · S/N 7541N442JSCirrus Design SR20 · S/N 9948N47700Piper PA-28R-201 · S/N 28R-7837001N494RACessna 150G · S/N 15066996N51119Piper J3C-65 · S/N 9939N5194CCessna LC41-550FG · S/N 411079N535CSCirrus Design SR22T · S/N 2466N5488VNorth American SNJ-5 · S/N 51789N558CHHylio HYL-300 · S/N 17906130206N574MGPiper PA-32RT-300T · S/N 32R-7987101N577JHMooney M20M · S/N 27-0281N637CBCirrus Design SR20 · S/N 10638N642AVGezik James F AVENTURA II · S/N AA2A0112N661RCCharles R Carmichael VANS RV-14 · S/N 140780N676CHCessna 172M · S/N 17266905N681FLFreedom Lift Innovations Q · S/N 00001N7090YPiper PA-28-180 · S/N 28-7305058N7094VMooney M20F · S/N 22-1422N7516JPiper PA-28R-180 · S/N 28R-30883N755BCCessna 421C · S/N 421C0497N79540Cessna 172K · S/N 17258160N85338Aeronca 7AC · S/N 7AC-4077N893HFEurocopter Deutschland EC 135 P2+ · S/N 0893N9190JPiper PA-28-180 · S/N 28-3258N934CWTextron 525 · S/N 525-0934N94768Cessna 152 · S/N 15285782N9705LBeech B23 · S/N M-1324N9876KPiper PA-32R-300 · S/N 32R-7880038N99642Forney 415-D · S/N 2265N9998Boeing PT-17 · S/N 41-1059
Back to Rockledge, FL