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.
N899BEFlight Design General Avn F2-LSA · S/N T-23-02-01N899NFStinson 108-3 · S/N 108-4736N89SWCirrus Design SR22T · S/N 9799N8LABombardier BD-700-2A12 · S/N 70267N900RLDassault FALCON 900 EX · S/N 131N900TKSocata TBM 700 · S/N 1069N902AGBombardier CL-600-2B16 · S/N 5512N9070DBalloon Works FIREFLY 8 · S/N F8-370N908TACirrus Design SR22T · S/N 10199N911CBAirbus Helicopters Deutschland EC135T3 · S/N 2105N911KJCirrus Design SR22T · S/N 0849N915CSCirrus Design SR22T · S/N 10520N915WKEmbraer S A EMB-505 · S/N 50500021N917CCNew Piper PA-46-500TP · S/N 4697259N918DWCirrus Design SR22 · S/N 4002N91AKVans RV-12IS · S/N 12163N9207SBeech B24R · S/N MC-376N920ACPiper PA-28-161 · S/N 2841216N92150Cessna 182N · S/N 18260064N922BPCirrus Design SR22 · S/N 4613N922TTBrousseau Ted PIETENPOL AIR CAMPER · S/N TB01First renewal noticeN923XSchweizer SGS 1-26B · S/N 338First renewal noticeN92DJEmbraer Executive EMB-505 · S/N 50500712N934PCRaytheon A36 · S/N E-3448N9353RCessna R182 · S/N R18200695First renewal noticeN9355CCessna 180 · S/N 31753N9418YBeech N35 · S/N D-6596N942SPBombardier BD-100-1A10 · S/N 20042N9430YBeech N35 · S/N D-6609N944BDB & D Ventures RV7A · S/N BD 001N946ACCessna 152 · S/N 15286018N947TETiger AG-5B · S/N 10226N9504NGolden Circle Air T BIRD II · S/N 531944N952SBCirrus Design SR22 · S/N 4314N955ACCessna 172S · S/N 172S8984N960ACPiper PA-28-161 · S/N 2841325N965ACPiper PA-28-161 · S/N 2841134N965KWVans RV-12IS · S/N 12145N970ACPiper PA-28-161 · S/N 28-8116113N971ACPiper PA-28-161 · S/N 28-7916188N974ACPiper PA-28-161 · S/N 28-7916126N9758XCessna 210B · S/N 21058058N975ACPiper PA-28-161 · S/N 28-7916121N975RCRichard Collins SLING TSI · S/N 487SKN976ACPiper PA-28-161 · S/N 28-8116308N977ACPiper PA-28-161 · S/N 2816073N978ACPiper PA-28-161 · S/N 2841220N97CTCirrus Design SR22 · S/N 0128N97LXCirrus Design SR22T · S/N 0544N980ACPiper PA-28R-201 · S/N 2844051
Back to Naples, FL