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.
N78PADiamond Aircraft Ind DA 40 NG · S/N 40.NC116N794MAMitsubishi MU-2B-60 · S/N 794 S.A.N7983QCessna 401B · S/N 401B0202N79APBeech 58P · S/N TJ206N79RZEmbraer-Empresa Brasileira De EMB-500 · S/N 50000142N7DREmbraer Executive EMB-505 · S/N 50500323N7RZBeech A36 · S/N E-2562N8009WPiper PA-28-180 · S/N 28-2071N800ACAero Commander 500-A · S/N 500A-1193-65N8019YPiper PA-30 · S/N 30-1128N801FBHawker Beechcraft HAWKER 900XP · S/N HA-0052N8020PPiper PA-24 · S/N 24-3264N807BHCirrus Design SR22T · S/N 1238N81337Aero Sport LAZER 200 · S/N AS200N813CGCirrus Design SR22 · S/N 4978N814RCPiper PA-30 · S/N 301202N8174SPiper PA-34-200T · S/N 34-8070166N8175QCessna 340 · S/N 340-0522N819LMSocata TBM 700 · S/N 675N826DSmith AEROSTAR 601P · S/N 61P0399138N8298UCessna 150M · S/N 15077915N829FACessna 182T · S/N 18281129N82LECessna 182T · S/N 18281377N830JSCessna 560XL · S/N 560-5274N830PDPzl-Bielsko B1-PW-5 · S/N 05.001.08First renewal noticeN831XChappel D/Chappel E LANCAIR IVP · S/N LIV 453N8360MCessna A150K · S/N A1500060N8382ZPiper PA-28-236 · S/N 28-8111064N8383KStinson 108-1 · S/N 108-1383N838FLDassault-Breguet FALCON 50 · S/N 126N83AJPilatus PC-12/47E · S/N 1415N84209Aerofab LAKE LA-250 · S/N 85N8431MCessna A150K · S/N A15000131N846RDPiper PA46-500TP · S/N 4697186Registration pendingN8480CPiper PA-28-151 · S/N 28-7615127N853WSpray Joel D VANS RV8 · S/N 80953N866BBGulfstream Aerospace GV-SP (G550) · S/N 5466N8670TCessna 182C · S/N 52570N86AHCirrus Design SR22 · S/N 3754N87085Ercoupe 415-C · S/N 258N8782FHughes 269A · S/N 0107N87SEVans RV-12IS · S/N 12162N880LPLance Maclean LOCKWOOD ACFT-AIRCAM · S/N 271-2N8819SCessna 150F · S/N 15062119N886JATextron T206H · S/N T20609552N887PBCessna U206C · S/N U206-1062N889ACPiper PA-60-700P · S/N 60-8423024N88SVCirrus Design SR22T · S/N 9075N8926VCessna 172M · S/N 17264283N8926XCessna 182 · S/N 18253326
Back to Naples, FL