Cape Coral, FL
Registered aircraft · 110
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 = 'CAPE CORAL' 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 = 'CAPE CORAL' 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.
N115FBGrumman HU 16E · S/N 148327N1184TNorth American T-28C · S/N 146283N1191NAmerican General Acft AG5B · S/N 10017N13144Cessna 172M · S/N 17262527N137UDee Howard 500 · S/N 500-109N13EJBeech F33A · S/N CE1130N140CRCessna 140 · S/N 9928N1499YCessna 172C · S/N 17249199N152BPCessna 152 · S/N 15281066N1546YBeech F33A · S/N CE-1316N164PFMichael Ripley MTO SPORT · S/N M01254N1956RPiper PA-39 · S/N 39-85N1980HPiper PA-28R-201T · S/N 28R-7703044N2015WBeech S35 · S/N D-7975N2105SCessna 210L · S/N 21061069N2158VPiper PA-28R-201T · S/N 28R-7803151N21TGCessna 182P · S/N 18261547Sale reportedN220YPPowrachute AIRWOLF 912ULS · S/N A437ULSN2568MPiper PA-23-250 · S/N 27-7954079N269ZZDreier George E LONG-EZ · S/N 866N2818XPiper PA-28-181 · S/N 28-7990467N29002Cessna 210L · S/N 21059777N295TCCommander 114TC · S/N 20012N2982HErcoupe 415-C · S/N 3607N310PHCessna 310R · S/N 310R0281N3137UCessna 182F · S/N 18254537N313CEBellanca 7ECA · S/N 886-72N32525Piper PA-28-140 · S/N 28-7525078N32680Piper PA-28R-200 · S/N 28R-7535077N3460VCessna 150M · S/N 15076508N350RPLancair LC42-550FG · S/N 42046N357KSAnthes R/Anthes M RA SPECIAL · S/N 24803First renewal noticeN373AZCessna M337B · S/N 337M0079N394EARaytheon A36 · S/N E-3594N397MECessna 182S · S/N 18280876N412MRMooney M20C · S/N 680163N41453Piper PA-32R-301 · S/N 3246148N414DLCessna 414 · S/N 414-0367First renewal noticeN4158BBellanca 17-30A · S/N 76-30801N42170Piper J3C-65 · S/N 14412N424SSchleicher ASW-24 · S/N 24109N427TBSocata TBM 700 · S/N 1002N42PZZeidman Richard B VANS RV7 · S/N 72404N437JWRockwell International 114 · S/N 14075N43911Piper PA-46-310P · S/N 46-8508059N43DHMooney M20E · S/N 283N43TTCessna LC41-550FG · S/N 411149N44132Piper PA-28-140 · S/N 28-7425391N4524BGulfstream American AA-5B · S/N AA5B1098N4566HMooney M20J · S/N 24-0848
Back to Cape Coral, FL