Punta Gorda, FL
Registered aircraft · 146
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 = 'PUNTA GORDA' 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 = 'PUNTA GORDA' 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.
N1038FPiper PA-28-140 · S/N 28-25552N10BUBell 47G-2 · S/N 666N1169ZMooney M20J · S/N 24-1311N11845Cessna 177B · S/N 17702377N1231ZBeech N35 · S/N D-6693N129WCCrowl William D HUMMELBIRD · S/N CROWL001N12SVNord STAMPE SV4C · S/N 418N1319RGrumman American Avn. AA-5 · S/N AA5-0719N133DDouglas DC-3A-S1C3G · S/N 1499N134QWaco UPF-7 · S/N 5484N13HMBeech E-55 · S/N TE-813N13VFParker Ronald B VANS AIRCRAFT RV-8 · S/N 81625N1473KColumbia Aircraft Mfg LC41-550FG · S/N 41773N14VYJMB Aircraft S R O VL-3EH-916 · S/N VL-3-684N154WTSikorsky UH-60A · S/N 86-24508N16085Lockheed 12A · S/N 1214N16343Sud GARDAN GY 80-180 · S/N 115N168RRidge Lowell & Jane RIDGEAIRE · S/N 168N17221Cessna 150L · S/N 15073673N17JJNelson John R LANCAIR LEGACY · S/N L2K-229N182SBCessna 182P · S/N 18261721N197DHRaytheon A36 · S/N E-3084N200GRCirrus Design SR20 · S/N 1300N2035BBeech A36 · S/N E-1359N2071LHasch Robert M JR RV-7A · S/N 70412N2095YCessna 172D · S/N 17249595N2172BPiper PA-32RT-300T · S/N 32R-7987034N2179MCessna T182T · S/N T18208466N222WPBeech A36 · S/N E-516N223TKBurke Timothy F BERKUT · S/N 022N2273HErcoupe 415-D · S/N 2898N2375LBeech 23 · S/N M-223N23UAUrban Air Sro UFM-13 LAMBADA · S/N 122/13N2486KLuscombe 8E · S/N 5213N2542AQuad City Ultralight Acft CHALLENGER II · S/N 0392-0829N2553WMooney M20C · S/N 3265N2690TCessna 414A · S/N 414A0408N273NFCirrus Design SR22 · S/N 4407N277RVRv-7a RV-7A · S/N 71914N279SCBeech E18S · S/N BA-74N27HRAviat A-1A · S/N 1444N2929XCessna 177 · S/N 17700329N293SPowrachute AIRWOLF 912ULS · S/N A338VIKN2971KLuscombe 8A · S/N 5698N29FPSkykits USA SAVANNAH VG · S/N 07-01-51-572N301ESUstek LANCAIR ES-P · S/N ESP-192N311RKCirrus Design SR20 · S/N 2241N3204UCessna 182F · S/N 18254604N320ESDibenedetto Vincent A LANCAIR 320 · S/N 859320701N32572Piper J5A · S/N 5336
Back to Punta Gorda, FL