Mount Pleasant, TX
Registered aircraft · 110
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 = 'TX' 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 = 'TX' 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.
N1004Curtiss Wright TRAVEL AIR 4000 · S/N 416N1042BNorth American B-25N · S/N 44-30823AN11153Stinson SM-6000-B · S/N 5021N1156AHelicopteres Guimbal CABRI G2 · S/N 1156N1180VBeech D17S · S/N 6904Registration pendingN12164Stinson JR. S · S/N 8102N12288Detroit VEGA DL-1 · S/N 161N1255MCessna 182P · S/N 18264261First renewal noticeN1315UCessna 172M · S/N 17267004N13754Cessna 172M · S/N 17262995N13YZBeech A36 · S/N E-859N14307Moss Jim JIM MOSS QED · S/N 1N14458Beech B17E · S/N B17E-49N14757Taylor E-2 · S/N 150N15165Stinson A · S/N 9125N151MCCavalier F51D MUSTANG · S/N AF6722581N1536Advance WACO 9 · S/N 9N15376Piper PA-28-180 · S/N 28-7305065N15GRBeech T-34C-1 · S/N GM55N15SHawker Siddeley MK 10 SEA FURY · S/N WJ288N16240Canadian Car & Foundry HARVARD MK IV · S/N 20366N16793Fleetwings F401 · S/N 1N17662Spartan 7W · S/N 28N17MParamount CABINAIRE · S/N 7N18207Howard DGA-11 · S/N 206N18422Stinson SR-9F · S/N 5714N18900Ryan Aeronautical SCW-145 · S/N 214N1940SLockheed 18-56 · S/N 2509N20882Cessna 182P · S/N 18261283N20961Waco SRE · S/N 5086N2108PPiper PA-23 · S/N 23-698N210FGCessna 210M · S/N 21062096N224MJCamair 480 · S/N 1-064N2290FDehavilland DH-89A · S/N 89445N2347Monocoupe 110 SPECIAL · S/N 5W-641N2445Antonov AN-2 · S/N 1G11756N250DLockheed 18-56 · S/N 2597N2696DCessna 170B · S/N 20848N26BKDouglas A-26B · S/N 28045N28RENorth American T-28A · S/N 51-7789N317MDassault FALCON 2000 · S/N 188N32455Cessna C-165 · S/N 588N32486Piper PA-28-151 · S/N 28-7515167N3277GCurtiss Wright ROBIN · S/N 237N330RKTextron 525C · S/N 525C0471N333LTCook Robert K RV-3 · S/N 495N34DAPiper PA-23-160 · S/N 231469N3751WPiper PA-32-260 · S/N 32-665N377MCurtiss Wright TRAVEL AIR A-6000-A · S/N A6A-2003N387RFHughes 369A · S/N 301381
Back to Mount Pleasant, TX