OpenAirDocs.org
Simmons Aviation Services LLC

Registered aircraft · 28

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'SIMMONS AVIATION SERVICES LLC' OR list_contains(g.other_registrant_names, 'SIMMONS AVIATION SERVICES LLC')
  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 · Pawcatuck, CTN221JWAviat A-1A · S/N 1419Built 1998 · Pawcatuck, CTN23DFBeech C18S · S/N 6220Built 1944 · Pawcatuck, CTN35MMWaco Classic YMF-F5C · S/N F5C-8-094Built 2001 · Pawcatuck, CTN445YCessna 305A · S/N 22817Built 1951 · Pawcatuck, CTN4583QCessna L-19E · S/N 24578Pawcatuck, CTN4691YPiper PA-25-235 · S/N 25-4422Built 1967 · Pawcatuck, CTN4785YPiper PA-25-235 · S/N 25-4556Built 1968 · Pawcatuck, CTN4961PPiper PA-23-235 · S/N 27-562Built 1963 · Pawcatuck, CTN52106Cessna 172P · S/N 17274413Built 1980 · Pawcatuck, CTN5212GCessna 305A · S/N 21201Built 1950 · Pawcatuck, CTN5213GCessna 305A · S/N 21573Built 1951 · Pawcatuck, CTN5291GCessna 305A · S/N 23413Built 1953 · Pawcatuck, CTN6079ZPiper PA-25 · S/N 25-91Built 1960 · Pawcatuck, CTN6127ZPiper PA-25 · S/N 25-148Built 1960 · Pawcatuck, CTN6264ZPiper PA-25 · S/N 25-326Built 1960 · Pawcatuck, CTN6454ZPiper PA-25 · S/N 25-638Built 1961 · Pawcatuck, CTN6456ZPiper PA-25 · S/N 25-639Built 1961 · Pawcatuck, CTN6518ZPiper PA-25-235 · S/N 25-2046Built 1963 · Pawcatuck, CTN6862ZPiper PA-25-235 · S/N 25-2548Built 1963 · Pawcatuck, CTN711WWGrumman Acft ENG Cor-Schweizer G-164A · S/N 936Built 1972 · Pawcatuck, CTN7282ZPiper PA-25-235 · S/N 25-3222Built 1965 · Pawcatuck, CTN7460ZPiper PA-25-235 · S/N 25-3457Built 1965 · Pawcatuck, CTN7714ZPiper PA-25-235 · S/N 25-3877Built 1966 · Pawcatuck, CTN85650Grumman TBM-3 · S/N 85650Built 1945 · Pawcatuck, CTN8670LPiper PA-25-235 · S/N 25-5123Built 1969 · Pawcatuck, CTN8784LPiper PA-25-235 · S/N 25-5267Built 1970 · Pawcatuck, CTN92358Piper PA 46-350P · S/N 4622147Built 1993 · Pawcatuck, CT
Back to Simmons Aviation Services LLC