Plymouth, MN
Registered aircraft · 42
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 = 'MN' 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 = 'MN' 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.
N1069WBeech A36 · S/N E-416N10941Cessna 150L · S/N 15075153N1666QCessna 150L · S/N 15072966Registration pendingN173AWTextron 172S · S/N 172S12859N21448Mooney M20M · S/N 27-0298N216BACessna 182P · S/N 18263882N21HACessna 310R · S/N 310R1850N21SJCessna 182R · S/N 18267869N239BAIcon A5 · S/N 00096N291MTBehnke Michael J RV-9A · S/N 91319N32187Piper PA-32-300 · S/N 32-7540021N342PEPilatus PC-12/47E · S/N 1342N4066PClifford Eric Scott RANS S-16 · S/N 1299019N411WTravel Air 12-W · S/N 12W2015N5032TPiper PA-28-140 · S/N 28-7225325N5423ZPiper PA-22-108 · S/N 22-9197N55419Piper PA-28-180 · S/N 28-7305380N6150CBeech A36 · S/N E-1960N633ASEa Vision EA J100 · S/N EAVUAV502585829N6385JPiper PA-28-180 · S/N 28-4799N643PAPiper PA-28RT-201 · S/N 28R-7918218N6537APiper PA-23-250 · S/N 27-7954002N654WTremblay Peter RV-7A · S/N 71993N6936WPiper PA-28-140 · S/N 28-21114N716PCTextron 182T · S/N 18283159N724TCessna 182S · S/N 18280250N7276WPiper PA-28-180 · S/N 28-1114N735GSCessna 182Q · S/N 18265418N7705HPiper PA-12 · S/N 12-597N7865UCessna 172F · S/N 17251865N79HHCirrus Design SR22 · S/N 2282N81963Cessna 150F · S/N 15063608N8564BCessna 172 · S/N 36264N867BMQuest KODIAK 100 · S/N 100-0168N8803VBellanca 17-30A · S/N 30335N888ABeech A36 · S/N E-3304N9311NPiper PA-28R-200 · S/N 28R-35011N948FSAmerican Legend AL3 · S/N AL-1053N967DTTrent Taylor CCX-2000 · S/N CCX-2000-0095N98239Piper PA-28-140 · S/N 28-26126N9889MCessna 182P · S/N 18264786N98992Piper PA-12 · S/N 12-350
Back to Plymouth, MN