Plymouth, MI
Registered aircraft · 36
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 = 'MI' 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 = 'MI' 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.
N122DDPiper PA-23-250 · S/N 27-7754120N124PCMitsubishi MU-2B-40 · S/N 438SAN1602LMcdonnell Douglas Helicopter 369E · S/N 0225EN161DGAeropro CZ EUROFOX LSA · S/N 21207N221KDCirrus Design SR22T · S/N 10950N2278PHazem Samir-Moez VANS ACFT RV-7A · S/N 74728N2294YCessna 177 · S/N 17700094First renewal noticeN24371Taylorcraft BC-65 · S/N 1707N2711YCirrus Design SR20 · S/N 1211N2749LCessna 172H · S/N 17255949N2789TBeech V35 · S/N D-8483N29859Rockwell International 114 · S/N 14038N302FGPiper PA-28-161 · S/N 28-8016274N3052YCessna 182E · S/N 18254052N32596Balloon Works FIREFLY 7-15 · S/N F71015N330VACostruzioni Aeronautiche Tecna P2006T · S/N 348/USN34PCDassault FALCON 2000EX · S/N 156N354ASBombardier BD-100-1A10 · S/N 20914N3579QPiper PA-32R-301T · S/N 32R-8029039N3958PPiper PA-22-150 · S/N 22-3636N445SHughes 369HS · S/N 230445SN45CXCirrus Design SR22 · S/N 5145N4710MPiper PA-11 · S/N 11-219Registration revokedN53887Bellanca 7ECA · S/N 1138-76N57BPMooney M20M · S/N 27-0307N6609CCessna 180 · S/N 30157N7127KBalloon Works FIREFLY 7 · S/N F7-446N733AYCessna 172N · S/N 17268155N78FMMooney M20J · S/N 24-0768N85288Aeronca 7AC · S/N 7AC-4026N957CSRobinson Helicopter R44 II · S/N 14162N95CTCessna 525C · S/N 525C-0113N96566Taylorcraft BC12-D · S/N 8866N9846GCessna 172L · S/N 17259746First renewal noticeN988LMNara N Krall SLING TSI · S/N 605SKN9963ECessna 172N · S/N 17272301
Back to Plymouth, MI