Vero Beach, FL
Registered aircraft · 575
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 = 'VERO BEACH' 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 = 'VERO BEACH' 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.
N1015SMooney M20J · S/N 24-3107N101RGCessna 182L · S/N 18258526N101RSTextron 208B · S/N 208B5289N101ZWSchweizer 269C-1 · S/N 0276N1020HPiper PA-30 · S/N 30-1569N102DHPiper PA-44-180 · S/N 4496597N103SAPiper PA-28-161 · S/N 28-8416012N104DHPiper PA-28-181 · S/N 2881999N10594Taylor E-2 · S/N 12N1066MBoeing B75N1 · S/N 75-7932N106GTCessna 172N · S/N 17270199N111FCPiper PA-32-260 · S/N 32-1030N111RLSchleicher ASW-24 · S/N 24111N113RSBlades Over Me AUTOGYRO BLAZER · S/N 071N1152MCessna 172L · S/N 17259452N115DXPiper PA-28-181 · S/N 28010102N115MAPiper PA-46-701TP · S/N 46020111N1160UPiper PA-28-181 · S/N 28020245N119APiper PA-28-140 · S/N 28-25947N11DSSchweizer 269C-1 · S/N 0323N1230UPiper PA-28-181 · S/N 28020277N123DGGates Lear Jet 24F · S/N 342N123ELFishman Randall ELECTRA FLYER-C · S/N EAC 1002N123FLPiper PA-44-180 · S/N 4496648N123LCAmerican Legend AL18 · S/N AL-1164N1250UPiper PA-28-181 · S/N 28020246N129JMPiper PA-46-701TP · S/N 46020129N1310UPiper PA-28-181 · S/N 28020247N131SAPiper PA-46-701TP · S/N 46020113N133WAPiper PA-46-701TP · S/N 46020133N136MMHefel Lyle L VANS ACFT RV-6 · S/N 21718N1377HPiper PA-28-161 · S/N 28-7716019N1378JJohnson William M TROJAN TA-16 · S/N 10N143PPPiper PA 46-350P · S/N 4636664N1440UPiper PA-28-181 · S/N 28020248N145ARPiper PA-28-181 · S/N 28010047N1463DCessna 170A · S/N 20046N152ARPiper PA-28-181 · S/N 28010048N153TJCessna 525A · S/N 525A0377N154ARPiper PA-28-181 · S/N 28010049N155ARPiper PA-28-181 · S/N 28010050N157ARPiper PA-28-181 · S/N 28010053N158NDPiper PA-28-161 · S/N 2842030N159NDPiper PA-28-161 · S/N 2842031N15RJBeech E33A · S/N CE-199N161KMPiper PA-28-161 · S/N 28-7716136N162AVPiper PA-28-181 · S/N 28010078N162HDCessna 172P · S/N 17274762N16378Piper PA-32-260 · S/N 32-7300026N163AVPiper PA-28-181 · S/N 28010061
Back to Vero Beach, FL