Boca Raton, FL
Registered aircraft · 335
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 = 'BOCA RATON' 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 = 'BOCA RATON' 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.
N100LUCessna 172R · S/N 17280075N101LUCessna 172R · S/N 17280709N103LUCessna 172R · S/N 17280298N104BEBeech C-99 · S/N U-221N104LUCessna 172R · S/N 17280625N104RJLearjet 60 · S/N 422N105LUCessna 172S · S/N 172S9774N106SXBeech C-99 · S/N U-166N106UCCessna 152 · S/N 15285419N107HBeech 95-C55 · S/N TE-36N107LUBeech A36 · S/N E-1847N108SXBeech C-99 · S/N U-184N109LUCessna 172R · S/N 17280991N10FHAviat A-1C-200 · S/N 3439N110LUCessna 172R · S/N 17281326N110VECessna 414A · S/N 414A-0017N111XTExtra Flugzeugbau EA 300/L · S/N 1188N111YVBeech 1900C · S/N UC-111N1126EBellanca 8KCAB · S/N 306-77N112YVBeech 1900C · S/N UC112N114JCChase Jerome H BUSHBY MUSTANG M-II · S/N 1092N1161ZMooney M20J · S/N 24-1356N1198ZCessna LC41-550FG · S/N 411151N11XNAero Vodochody L-39 · S/N 931336N126DSchweizer SGS 1-26C · S/N 81N127MTPiper PA-28R-201 · S/N 2844094N127PSAviat S-2C · S/N 6010N130GPBeech C-99 · S/N U-222N131GPBeech C-99 · S/N U225N134DSPiper PA-34-220T · S/N 348233148N138CDCirrus Design SR22T · S/N 11179N139LWAero Vodochody L-39 · S/N 232429N13TTPiper PA-23-250 · S/N 27-7554069N142JMCirrus Design SF50 · S/N 0334N1432NPiper J3C-65 · S/N 22956N151JMHonda HA-420 · S/N 42000269N152AFSwearingen SA227-AC · S/N AC520N1568GBeech 1900C · S/N UC-58N1568RGrumman American Avn. AA-5B · S/N AA5B-0068N15HCBeechcraft G36 · S/N E-4032N164HABeech 99 · S/N U-60N16628Aerotek PITTS SPECIAL S-1S · S/N 1-0010N169FLCessna 177 · S/N 17700047N174AVBeech C-99 · S/N U-174N178CMEmbraer-Empresa Brasileira De EMB-500 · S/N 50000178N179CAEmbraer EMB-120ER · S/N 120.179N17GGRaytheon B300 · S/N FL-419N181USGulfstream Aerospace G-IV · S/N 1181N183WWDassault FALCON 900 EX · S/N 294N1847HBeech 58TC · S/N TK-145
Back to Boca Raton, FL