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.
N2568LBalloon Works FIREFLY 8B-15 · S/N F8B-424First renewal noticeN258LEBell OH-58A · S/N 71-20630N259RVGisselbeck Robert P RV9A · S/N 92218N25UADJI MATRICE 210 V1 · S/N 0G0DE9U0230052N261XHarrison W E JR VANS RV-6A · S/N 60239N262TXRaytheon 400A · S/N RK-464N26BEmbraer Executive EMB-505 · S/N 50500475N26SXEwing Tom MUSTANG M-1 · S/N 717N26XYSabot Jay M LEGACY · S/N L2K-247N270CWVans RV-12IS · S/N 12142N270DMTextron 182T · S/N 18283115N270RXCirrus Design SR20 · S/N 9132N275CStinson 108-2 · S/N 108-3275N275VBeech 58 · S/N TH-376N276JBRaytheon B300 · S/N FL-219N2814RCessna 182K · S/N 18258414N282GSEmbraer S A EMB-505 · S/N 50500041N2873ZPiper PA-18A 150 · S/N 18-7036N288MDAviat A-1B · S/N 2177N28RSCessna T210K · S/N 21059316N28SXBarrett James CHRISTEN EAGLE II · S/N 0429BN2917BBeech D35 · S/N D-3558N2AEDickson-Phelps CHRISTIAN EAGLE II · S/N DICKSON-0001N300SABeech F33A · S/N CE-545N301CGVans RV-12IS · S/N 12144N303WACessna T303 · S/N T30300265N305LCLeading Edge Aerial Tech PV40X · S/N 1937511461N30BPCessna 525 · S/N 525-0816N30RMBeech E-55 · S/N TE-828N30STCessna 525A · S/N 525A0497N310BVCessna 310R · S/N 310R0099N3115VCessna 150M · S/N 15076388N313TNMooney M20TN · S/N 31-0003N3143CEnstrom Helicopter 280C · S/N 1103N31MJTextron 182T · S/N 18283118N3219RPiper PA-28R-180 · S/N 28R-31132N3240HBalloon Works FIREFLY 7-15 · S/N F7-903N325FPEmbraer Executive EMB-500 · S/N 50000359N3268QCessna 401 · S/N 401-0068N326WDWinton S Douglas JR GT-VX2 · S/N VX2-007N327MJPiaggio P180 · S/N 1099N329MDCanadair CL-600-2B16 · S/N 5098N329TPiper PA-18-105 SPECIAL · S/N 18-2443N330CDCirrus Design SR22 · S/N 1319N330JGPiper PA-24-250 · S/N 24-3042N330YBCirrus Design SF50 · S/N 0455N333BGCessna A185F · S/N 18504224N339WMCirrus Design SR22 · S/N 9850N3410Cessna 560XLS · S/N 560-5649N342GFCirrus Design SR22 · S/N 4342First renewal notice
Back to Naples, FL