OpenAirDocs.org
Smtm Holdings Inc

Registered aircraft · 21

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 = 'SMTM HOLDINGS INC' OR list_contains(g.other_registrant_names, 'SMTM HOLDINGS INC')
  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.

N1004HPiper PA-28-151 · S/N 28-7715301Built 1976 · Wilmington, DEN20773Cessna 172S · S/N 172S9570Built 2004 · Wilmington, DEN2428FPiper PA-38-112 · S/N 38-79A0436Built 1979 · Wilmington, DEN33367Piper PA-28-180 · S/N 28-7505136Built 1975 · Wilmington, DEN3604JCessna 150G · S/N 15064904Wilmington, DEN3844QCessna 172L · S/N 17259944Built 1971 · Wilmington, DEN43899Piper PA-28-161 · S/N 28-8516033Built 1985 · Wilmington, DEN4574VCessna 172M · S/N 17266358Wilmington, DEN48900Cessna 152 · S/N 15283387Built 1979 · Wilmington, DEN4896MCessna 172P · S/N 17274294Built 1981 · Wilmington, DEN52426Cessna 172P · S/N 17274515Built 1980 · Wilmington, DEN529KMPiper PA-28R-200 · S/N 28R-7435196Wilmington, DEN54162Cessna 172P · S/N 17274895Wilmington, DEN5557JSocata TB 9 TAMPICO · S/N 1326Built 1991 · Wilmington, DEN61972Cessna 172M · S/N 17264928Built 1975 · Wilmington, DEN68197Cessna 152 · S/N 15282178Built 1978 · Wilmington, DEN68799Cessna 152 · S/N 15282382Built 1978 · Wilmington, DEN702RAPiper PA-28-151 · S/N 28-7415475Built 1974 · Wilmington, DEN711CVPiper PA-28R-200 · S/N 28R-7135212Built 1971 · Wilmington, DEN752RAPiper PA-28-161 · S/N 2841203Built 1989 · Wilmington, DEN96493Cessna 172P · S/N 17276080Wilmington, DE
Back to Smtm Holdings Inc