Plymouth, MA
Registered aircraft · 74
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 = 'MA' AND g.registrant_city = 'PLYMOUTH' 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 = 'MA' AND g.registrant_city = 'PLYMOUTH' 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.
N1262UCessna 172M · S/N 17266957N1267QCessna 150L · S/N 15072567N13803Piper PA-23-250 · S/N 27-4448N144BFCessna 172M · S/N 17264101N199MGCirrus Design SR22T · S/N 10265N20321DJI AGRAS T50 · S/N 1581F6BUB249E001575HN20329DJI MAVIC M3M · S/N 1581F5FKD2N20402Cessna 172M · S/N 17261261N20CFCessna 170B · S/N 26217N224NXCirrus Design SR22 · S/N 0170N2339TPiper PA-28R-200 · S/N 28R-7135227N25PTGrumman American Avn. AA-5B · S/N AA5B-0248N2719ESchneider Richard J LOADMASTER · S/N 97-001N2770MPiper PA-12 · S/N 12-1149N279FCLockhart Walter L KOLB TWINSTAR MK III · S/N M3-203N2811YCessna 182E · S/N 18253811N28NCPiper PA-28R-180 · S/N 28R-30357N293MViking Flying Boat KITTY HAWK B-4 · S/N 12N2961BPiper PA-28-161 · S/N 28-7916591N2964VCessna 150M · S/N 15076335N313KDCessna 177B · S/N 17702353N31651Waco VKS-7 · S/N 5275N357JSSannizzaro John A RV-7 · S/N 70312N36419Taylorcraft DC-65 · S/N 4160N400HEHelio H800 · S/N H-22N41805Bellanca 7ECA · S/N 982-73N419AEEurocopter EC120B · S/N 1161N4354TPiper PA-28R-200 · S/N 28R-7235015N46004Aeronca 0-58B · S/N 058B5572N46183Aeronca 0-58B · S/N 058B10483N46249Cessna 152 · S/N 15283019N47342Piper PA-32R-300 · S/N 32R-7880002N485BVAura Aero INTEGRAL R · S/N 003N48990Cessna 152 · S/N 15281090N5031YBellanca 7GCBC · S/N 1068-79N508PPDJI AGRAS T50 · S/N 1581F6BUB24C1001N51324Burrill Steven E A PLANE · S/N 4101N51890Cessna 172P · S/N 17274375N5300ZPiper PA-22-108 · S/N 22-9002N5302RCessna 172F · S/N 17252823N5749RCessna 172G · S/N 17253418N5842STalos Drones T60X · S/N 78KWN6500A5B6KN602PCPiper PA-28-181 · S/N 28-7990581N61755Cessna 172M · S/N 17264777N61985Cessna 172M · S/N 17264938N6340FCessna 182P · S/N 18264165N64HUAviat A-1C-200 · S/N 3467N651BFDJI MATRICE 4T · S/N 1581F7K3C254E00D9DBCN6656GCessna A188B · S/N 18801210N69019Cessna 152 · S/N 15282438
Back to Plymouth, MA