OpenAirDocs.org
Onida, SD

Registered aircraft · 22

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 = 'ONIDA'
  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.

N24759Piper J3C-85 · S/N 3428Built 1939 · Lamb Daniel JN2539YCessna 172D · S/N 17249839Built 1962 · Oly LLCN258KBBarber Kenneth RAF 2000 GTX SE · S/N 2-97-8-274Barber Kenneth MN31FSBeech V35B · S/N D-9586Built 1974 · Strickland CorpN358KBKen Barber M26 VICTOR · S/N 26255906Barber Ken MN4324ZPiper PA-18-150 · S/N 18-8639Built 1968 · Bretts Spray Service IncN4493VBeech 35 · S/N D-1313Built 1948 · Weinheimer Ethan TN4639KCessna 182P · S/N 18263641Built 1975 · Myers Gary L TrusteeN4860DCessna 182A · S/N 34960Built 1958 · Weinheimer Jeffrey TN502GDAir Tractor AT-502B · S/N 502B-2620Built 2007 · Brett'S Spray Service IncN502NJAir Tractor AT-502 · S/N 502-0138Built 1991 · Bretts Spray Service IncN503CRCub Crafters CC11-100 · S/N CC11-0001Built 2006 · Barber MarkN5415HPiper PA-18 · S/N 18-6Built 1949 · Hill Ross EN57725Piper PA-36-285 · S/N 36-7660047Built 1975 · Bretts Spray Service IncN605SFScott Foth ELA ECLIPSE-10 EVO · S/N 10237071025Built 2026 · Foth Air LLCN6655YBeech A36 · S/N E-1559Built 1979 · Bretts Spray Service IncN732VGCessna 210M · S/N 21061804Built 1977 · Crystal Air LLCN76BCAmerican Champion 8GCBC · S/N 606-2020Built 2020 · Yackley RanchesN818EBAir Tractor AT-802A · S/N 802A-0715Built 2017 · Bretts Spray Service IncN824DKRobinson Helicopter R44 II · S/N 11117Built 2006 · Warner Farm CorpN870DKRobinson Helicopter R44 II · S/N 13583Built 2014 · Foth Air LLCN977RMAir Tractor AT-802 · S/N 802-0702Built 2017 · Bretts Spray Service Inc
Back to Onida, SD