OpenAirDocs.org
Pawcatuck, CT

Registered aircraft · 35

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 = 'CT' AND g.registrant_city = 'PAWCATUCK'
  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.

N174DQBeech C23 · S/N M2310Built 1981 · Simmons Aviation Services LLCN221JWAviat A-1A · S/N 1419Built 1998 · Simmons Aviation Services LLCN23DFBeech C18S · S/N 6220Built 1944 · Simmons Aviation Services LLCN336BALet L13 AC BLANIK · S/N 988603Heritage Flight FoundationN35MMWaco Classic YMF-F5C · S/N F5C-8-094Built 2001 · Simmons Aviation Services LLCN360GSWright Dennis H SONEX · S/N 1153Built 2015 · Lemay ThomasN445YCessna 305A · S/N 22817Built 1951 · Simmons Aviation Services LLCN4583QCessna L-19E · S/N 24578Simmons Aviation Services LLCN4691YPiper PA-25-235 · S/N 25-4422Built 1967 · Simmons Aviation Services LLCN4785YPiper PA-25-235 · S/N 25-4556Built 1968 · Simmons Aviation Services LLCN4898YPiper PA-25-235 · S/N 25-4705Built 1968 · Simmons Mark AdbaN4961PPiper PA-23-235 · S/N 27-562Built 1963 · Simmons Aviation Services LLCN52106Cessna 172P · S/N 17274413Built 1980 · Simmons Aviation Services LLCN5212GCessna 305A · S/N 21201Built 1950 · Simmons Aviation Services LLCN5213GCessna 305A · S/N 21573Built 1951 · Simmons Aviation Services LLCN5291GCessna 305A · S/N 23413Built 1953 · Simmons Aviation Services LLCN6079ZPiper PA-25 · S/N 25-91Built 1960 · Simmons Aviation Services LLCN6127ZPiper PA-25 · S/N 25-148Built 1960 · Simmons Aviation Services LLCN6264ZPiper PA-25 · S/N 25-326Built 1960 · Simmons Aviation Services LLCN6454ZPiper PA-25 · S/N 25-638Built 1961 · Simmons Aviation Services LLCN6456ZPiper PA-25 · S/N 25-639Built 1961 · Simmons Aviation Services LLCN6518ZPiper PA-25-235 · S/N 25-2046Built 1963 · Simmons Aviation Services LLCN6862ZPiper PA-25-235 · S/N 25-2548Built 1963 · Simmons Aviation Services LLCN711WWGrumman Acft ENG Cor-Schweizer G-164A · S/N 936Built 1972 · Simmons Aviation Services LLCN7127VMooney M20F · S/N 22-0056Built 1974 · Chenal Robert BN7282ZPiper PA-25-235 · S/N 25-3222Built 1965 · Simmons Aviation Services LLCN7313ZPiper PA-25-235 · S/N 25-3245Built 1965 · Simmons Mark A DBAN7460ZPiper PA-25-235 · S/N 25-3457Built 1965 · Simmons Aviation Services LLCN7649SNorth American/Victoria MNT LT AT-6A · S/N 786199Built 1941 · Simmons Mark A DBAN7714ZPiper PA-25-235 · S/N 25-3877Built 1966 · Simmons Aviation Services LLCN85650Grumman TBM-3 · S/N 85650Built 1945 · Simmons Aviation Services LLCN8670LPiper PA-25-235 · S/N 25-5123Built 1969 · Simmons Aviation Services LLCN8784LPiper PA-25-235 · S/N 25-5267Built 1970 · Simmons Aviation Services LLCN92358Piper PA 46-350P · S/N 4622147Built 1993 · Simmons Aviation Services LLCN94AGMaule M-7-235B · S/N 23052CBuilt 1998 · Simmons Mark A DBA
Back to Pawcatuck, CT