Mount Pleasant, SC
Registered aircraft · 91
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 = 'SC' AND g.registrant_city = 'MOUNT PLEASANT' 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 = 'SC' AND g.registrant_city = 'MOUNT PLEASANT' 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.
N1042UPiper PA-34-200 · S/N 34-7250026N1467TPiper PA-28-180 · S/N 28-7205305N15850Piper PA-28-180 · S/N 28-7305164N1982YMooney M20E · S/N 269Sale reportedN201TJMooney M20J · S/N 24-0306N2298MPiper PA-32R-300 · S/N 32R-7880062N23BCCirrus Design SR22 · S/N 3514N24581Beech A24R · S/N MC-130N26412Grumman American Avn. AA-5A · S/N AA5A0493N276CCPiper/Cub Crafters PA-18-150 · S/N 9923CCN280JRIai GULFSTREAM G280 · S/N 2150N282CXIai GULFSTREAM G280 · S/N 2291N296MPCirrus Design SR22 · S/N 4252N300KBeech E-55 · S/N TE-1103N303HGSchweizer 269C-1 · S/N 0073N3067TBeech A36 · S/N E-2368N3099EPiper PA-32R-301T · S/N 3257382N310JTCessna 310 · S/N 35486N311AVCirrus Design SR22 · S/N 2395N313GPCirrus Design SR22T · S/N 1478N31WZCirrus Design SR22T · S/N 11330N3206MRobinson Helicopter R44 II · S/N 12041N3210KGlobe GC-1B · S/N 1203N321SECirrus Design SR22 · S/N 2089N32THHarper Thomas E SKYBOLT · S/N TH101N3323KGlobe GC-1B · S/N 1316N333FVGrumman American Avn. AA-5A · S/N AA5A0276N34LMPiper PA-34-200T · S/N 34-7770133N3673UBeech 58 · S/N TH-1149N36YVBeech A36 · S/N E-1244N404EBombardier DHC-8-402 · S/N 4067N411VVAero Commander 520 · S/N 520-39N41492Piper PA-32R-301T · S/N 3257105N42BZCirrus Design SR20 · S/N 11231N43566Kendrick Sherrill V SONEX · S/N 0688N4371VPiper PA-32-301 · S/N 32-8406018N456ACCirrus Design SR22 · S/N 4249N461ABeech V35 · S/N D-8392N4644FCessna P206A · S/N P206-0244N477LMMooney M20E · S/N 643N4824TCostruzioni Aeronautiche Tecna ASTORE · S/N 064N48967Cessna 152 · S/N 15281079N4968NCessna 182Q · S/N 18267489N507HPCessna 525 · S/N 525-0395N5087XChampion 7KCAB · S/N 160N5110HPiper PA-14 · S/N 14-115N5130FCessna 172S · S/N 172S9068N525HQCessna 525 · S/N 525-0827N540PGCirrus Design SR20 · S/N 1998N54504Piper PA-23-250 · S/N 27-3369
Back to Mount Pleasant, SC