Port Charlotte, FL
Registered aircraft · 71
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 = 'PORT CHARLOTTE' 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 = 'PORT CHARLOTTE' 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.
N10747Cessna 150L · S/N 15075003N1127BRaymond S Barkley DOMINATOR · S/N 1007N1218ASkydio SDR35V1 · S/N 1668BS20JB004SX7N127GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 344First renewal noticeN13814Piper PA-18-150 · S/N 18-8958N13STCessna 501 · S/N 501-0285N159ABeech J35 · S/N D-5598N2039VBeech A36 · S/N E-1375N2153MPiper PA-28R-201T · S/N 28R-7803110N2175TPiper PA-28-180 · S/N 28-7205025N231QTMooney M20K · S/N 25-0367N2465TNavion NAVION G · S/N NAV-4-2465N2559KSilvaire LUSCOMBE 8A · S/N 5286N26813Gulfstream American AA-5A · S/N AA5A0738N27PWCommander 114-B · S/N 14641N28532Grumman American Avn. AA-5B · S/N AA5B0662N306AKPiper PA-30 · S/N 30-1253N3308ZPiper PA-22-150 · S/N 22-7239N33JZAeronca 7AC-CONV · S/N 7BCM-487N360ZPMid American PITTS S12 · S/N 057N366ZBeech A36 · S/N E-769N3870HErcoupe 415-C · S/N 4571N4168HKurt John J RV4 · S/N 1263N42214Piper J3C-65 · S/N 14460N4558JPiper PA-28R-180 · S/N 28R-30418N470JKHill Kenneth R RV-9A · S/N 90310N48276Taylorcraft DCO-65 · S/N L5393N525TBKropelin Barry R DOMINATOR GYRO · S/N BK001N5323RCessna 172F · S/N 17252848N5466ECessna 180G · S/N 18051363N5469BCessna 182 · S/N 33469N5639PPiper PA-24-180 · S/N 24-709N567JNMooney M20K · S/N 25-0767N5740UPiper PA-28-140 · S/N 28-26556N582RCSchempp-Hirth VENTUS BT · S/N 76N6047JBeech C23 · S/N M-2174N6112JPiper PA-28-181 · S/N 28-7690342N6257HPiper PA-23-250 · S/N 277654057N62AHAeropro CZ EUROFOX LSA · S/N 22907N6337ACessna 182 · S/N 33137N633CDCirrus Design SR22 · S/N 0369N6371ACessna 182 · S/N 33171N6376MCessna 152 · S/N 15284698N64ZXBrantly B-2B · S/N 404N6619ACessna 172 · S/N 28719N662MCBell UH-1H · S/N 68-16622N662MFU-Fly-It Light Sport Acft CHALLENGER II · S/N UF-2909N6718VBeech C23 · S/N M-2268N671PACirrus Design SR22T · S/N 2097N67SLSmith Stanley AIRCAM · S/N AC-228
Back to Port Charlotte, FL