Naples, FL
Registered aircraft · 459
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 = 'NAPLES' 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 = 'NAPLES' 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.
N468TBVans RV-12IS · S/N 12159N472ARBombardier BD-100-1A10 · S/N 20769N473PCirrus Design SR22T · S/N 2244N4768FCessna TP206B · S/N P206-0368N4770KCessna P210N · S/N P21000301N477BBCessna 680 · S/N 680-0138N477JNSocata TBM 700 · S/N 1008N4784LPiper PA-28-180 · S/N 28-4119N479PRIsrael Aircraft Industries GALAXY · S/N 008N481CStinson 108-2 · S/N 108-3481N4840YPiper PA-25-260 · S/N 25-4637N485RMDJI PHANTOM 4 PRO · S/N OAXDE1EOA21865N486RMDJI MAVIC 2 PRO · S/N 163CG9NR0A23LFN487RMDJI MAVIC 3 · S/N 1581 F45 TB 21C 41AE0359N48JLBeech G33 · S/N CD-1256N495RDLancair LC42-550FG · S/N 42032N4976UCessna 210E · S/N 21058676N497CPCirrus Design SR22 · S/N 3315N4BEmbraer Executive EMB-505 · S/N 50500347N4CKPiper PA-30 · S/N 30-1645N4MTEmbraer-Empresa Brasileira De EMB-505 · S/N 50500009N4QERobinson Helicopter R44 II · S/N 14857N500DGEclipse EA500 · S/N 000129N5035WPiper PA-28 · S/N 28-37N5042EBellanca 7ECA · S/N 1297-79N5100KRyan NAVION A · S/N NAV-4-2000N512CDCirrus Design SR22 · S/N 1614N512RCessna 150M · S/N 15076755N515SCCirrus Design SR22 · S/N 4627N5184VNorth American T-6G · S/N 49-3164N518JSPiper PA-32R-301 · S/N 3246212N519MRRobinson Helicopter R44 · S/N 1267N51PUPipistrel Lsa SINUS · S/N 565 SFN 912 LSAN5202KRyan NAVION B · S/N NAV-4-2102BN5240WPiper PA-28-160 · S/N 28-281N52753Cessna 182T · S/N 18281164N5288XHughes Helicopters HUGHES 369D · S/N 911059DN529LEBell Textron Canada 429 · S/N 57435N5314MCessna 152 · S/N 15284528N5324PPiper PA-28-181 · S/N 2843452N532JKEmbraer EMB-550 · S/N 55020108N53352Cessna 172S · S/N 172S9352N53JNLake LA-4-200 · S/N 1074N5424CCessna T206H · S/N T20608494First renewal noticeN5437UBeech 95-C55 · S/N TE-406N5486BCessna 182 · S/N 33486N54HGDassault FALCON 900 EX · S/N 140N555PAPiper PA-28-140 · S/N 28-7225476N555VMVictor R Herbert RV-7A · S/N 71880N55611Raven S55A · S/N S55A-537
Back to Naples, FL