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.
N350WDPiper PA 46-350P · S/N 4636703N355AFPilatus PC-12/45 · S/N 345N357LHRobinson Helicopter R22 BETA · S/N 2254N359RBoeing A75N1(PT17) · S/N 75-2433N3658EBalloon Works FIREFLY 8B · S/N F8B-068N368FDCirrus Design SR22 · S/N 4858N379DTCessna T206H · S/N T20608777N379PSEmbraer Executive EMB-505 · S/N 50500964N37MMCessna 150F · S/N 15062913N385RCGates Learjet 55 · S/N 117N38KMSchempp-Hirth VENTUS A/16.6 · S/N 94N390GMRaytheon 390 · S/N RB-172N3932ABeech A45 · S/N 53-4117AN39EBCostruzioni Aeronautiche Tecna P2004 BRAVO · S/N 136N39EYSocata TB 30 EPSILON · S/N 39N3QECirrus Design SR22T · S/N 10147N3WJBeech 95-B55 (T42A) · S/N TC-1713N40068Piper PA-28R-201 · S/N 28R-7737131N400ACPilatus PC-12/45 · S/N 472N404DGCessna 414A · S/N 414A0111N405EPPowrachute PEGASUS · S/N A481PEGN408RWCirrus Design SF50 · S/N 0461N412CGCirrus Design SR22T · S/N 0992N4177AAmerican Champion 7GCBC · S/N 1480-2021N41JTCompagnie Daher TBM 700 · S/N 1295N421NCirrus Design SR22T · S/N 10103N4226KRyan NAVION A · S/N NAV-4-1226N422JCessna 182Q · S/N 18266172N424DTextron T182T · S/N T18209162N427DLCessna 560XL · S/N 560-5622N427KFFoxair KITFOX LIGHT SPORT · S/N KA15157319N432WBCirrus Design SR20 · S/N 8725N434LRPilatus PC-12/47E · S/N 2130N438DBBarkman D Barry RAND KR 2 · S/N 4438N441JWIai GULFSTREAM G280 · S/N 2305N441MHCessna 441 · S/N 441-0163N444BAIcon A5 · S/N 00020N44790Piper PA-28R-200 · S/N 28R-7535007N447TCOlson Mike TOP CUB · S/N 006N450JCGulfstream Aerospace GIV-X (G450) · S/N 4255N4531PPiper PA-23-250 · S/N 27-35N45328Cessna 150M · S/N 15076846N4545TGrumman American Avn. AA-5B · S/N AA5B1268N455EDCessna 210 · S/N 21058118N456RFEmbraer EMB-500 · S/N 50000223N457BBrian Baillod SEAREY · S/N 1DK467CN458SAMagnaghi Aeronautica SKY ARROW LSA · S/N LSA 023N46704Cessna 172K · S/N 17257440N4679MLeading Edge Aerial Tech PV40X · S/N 1937511510N468KACirrus Design SR22T · S/N 8576
Back to Naples, FL