OpenAirDocs.org
Hot Springs, SD

Registered aircraft · 45

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 = 'SD' AND g.registrant_city = 'HOT SPRINGS'
  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.

N108AJArbc Inc DBA Lindstrand 90A · S/N 5512Christensen Balloons LLCN112KKVans RV-12 · S/N 120427Built 2013 · Kusch Kim GN129CTFlight Design CT2K · S/N 02-01-03Tinaglia J DeanN169PTKay ANN West WEST-2 · S/N 002Built 2012 · Olstad Richard DN181LBCessna T182T · S/N T18208666Built 2006 · Watts RodneyN205CCMooney M20J · S/N 24-3044Hinn Terry AN24444Taylorcraft BL · S/N 1781Built 1940 · Kusch Kim GN258RERoy J Ebel RV-8 · S/N 82515Built 2012 · Ebel Roy JN27EGLarry D Vetterman PANTHER LS · S/N 062Built 2017 · Vetterman Larry DN316TBArbc Inc DBA Lindstrand 120A · S/N 5502Built 2012 · Western Horizons LLCN36097Piper PA-28R-201T · S/N 28R-7803310Conner Don RN3786XAero Commander 100 · S/N 281Built 1968 · Tinaglia J DeanN40098Cessna R172E · S/N R172-0134Built 1966 · Fall River County Emergency ManagementN4271RRaven S55A · S/N S55A-971Built 1983 · Gwin CoreyN444MRBuxbaum Mark Edward LONG EZ · S/N 563Built 1995 · Buxbaum Mark EdwardN4583EAeronca 7CCM · S/N 7CCM-152Built 1949 · Cheatham Glenn W JN4809Cessna 180K · S/N 18052914Built 1978 · Miller WadeN50036Lauritsen Ralph M RV 4 · S/N 693Built 1989 · Vetterman Larry DN51220Cessna 150J · S/N 15069853Trevillyan Bart LN51777Aerostar International S53A · S/N S53A-3060Built 1999 · Wilson PetraN5266TAerostar International S53A · S/N S53A-3073Built 2000 · Christensen Balloons LLCN5292BAerostar International S-57A · S/N S57A-3219Wilson PetraN5294JAerostar International S53A · S/N S53A-3084Built 2001 · Dakota Balloons LLCN5318JAerostar International S53A · S/N S53A-3087Wilson Brian AN5367RCessna 172F · S/N 17252899Built 1965 · Brooks Gordon B SrN56KBKubicek Factory S R O BB34E · S/N 2112Built 2023 · Western Horizons LLCN6156WPiper PA-28-140 · S/N 28-20175Housley Steven WN6192LAmerican AA-1 · S/N AA1-0392Built 1970 · Tinaglia Aviation LLCN6343RAerostar International RAVEN S49A · S/N S49A-3047Built 1991 · Dakota Balloons LLCN7148GAerostar International S-57A · S/N S57A-3181Built 1996 · Dakota Balloons LLCN7172YAerostar International RX-7 · S/N RX7-3321Gwin Corey JN71CJCurtis W Burt RANS S-7S · S/N 0710545Built 2013 · Burt Curtis WN7359VBellanca 17-30 · S/N 30199Built 1969 · Hatheway Justin CN746SCLarry D Vetterman JAVRON PA-18 REPLICA · S/N JA1210075Vetterman Larry DN751SCLarry D Vetterman JAVRON PA-18 REPLICA · S/N JA1705107Built 2019 · Vetterman Larry DN815KSCessna 172R · S/N 17280910Built 2000 · Penner Bruce WadeN8779HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1526Built 1975 · Miller Wade WN8919DPiper PA-22-160 · S/N 22-6076Built 1958 · Luallin Randy DN898AMAviat A-1A · S/N 1427Built 1998 · Wyatt LLCN9002YHead Balloons AX8-105 · S/N 502Built 2022 · Dakota Balloons LLCN9095TAerostar International S53A · S/N S53A-3041Built 1997 · Dakota Balloons LLCN9100LAerostar International S53A · S/N S53A-3043Built 1998 · Christensen Balloons LLCN91045Cessna 414 · S/N 414-0623Built 1975 · Dakota Aircraft Specialists LLCN9158ZAerostar International RX 8 · S/N RX8-3380Built 2008 · Wilson PetraN9234GCessna 182N · S/N 18260774Built 1971 · Godlevsky Leslie
Back to Hot Springs, SD