OpenAirDocs.org
Yankton, SD

Registered aircraft · 27

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

N1171WMooney M20J · S/N 24-1256Built 1982 · Eisenmenger James P TrusteeN125NKDJI AGRAS T40 · S/N 1581F574BZZ4N00102MRNorman Kramer EN150CPChris Nelson RV-10 · S/N 40919Built 2018 · Nelson Chris LN1945WBeech B19 · S/N MB-603Built 1973 · Hunhoff Mark BN2035UPiper PA-28-151 · S/N 28-7415467Built 1974 · Lihs AshleyN234CFDJI AGRAS T50 · S/N 63YBM4C002002ECarda Tyler RN234GTCessna 210M · S/N 21062155Built 1977 · Any Border LLCN2789QCessna 182K · S/N 18257989Built 1967 · Centerline LLCN396LRPiper PA-32RT-300 · S/N 32R-7885238Built 1978 · Rupiper LarryN448MCClearman Albert M RV8 · S/N 81229Built 2002 · Toczek Keith EN472BBXag P150 · S/N 1863FPEG8223449JS211Healy Joseph JN5171SCessna R182 · S/N R18201513Built 1980 · Halsted Holdings LLCN521ZCirrus Design SR22 · S/N 0176Built 2002 · Hoffner Flying IncN54RNRokahr Steven C TORNADO · S/N D03912SOHK0444Built 2003 · Rokahr Steven CN6086SCessna R182 · S/N R18201610Built 1980 · Dos Lobos Aviation LLCN643MDRichardson Michael J WITTMAN TAILWIND W10 · S/N MR928Built 2021 · Lacey Robert EN6610GCessna 150L · S/N 15072110Built 1970 · Thomas Charles LN6728VBeech A36 · S/N E-2103Built 1983 · Driftwood Creek Flying Club LLCN6737NMooney M20F · S/N 680186Built 1968 · Cox James GN69421Xag P150 MAX · S/N 186325P18229548P86V4Healy Joseph JN81347Grumman American Avn. AA-5B · S/N AA5B0503Built 1977 · Tusha Kenneth RN827JHHuls James J RV-4 · S/N 2438Built 1996 · Eisenmenger James P TrusteeN8323VChampion 7GCBC · S/N 55Toczek Keith EN84878Cessna 172K · S/N 17258650Built 1969 · Yankton FlyersN88NGCessna 177RG · S/N 177RG1223Built 1977 · Bakke Dale WN9690DPiper PA-18 · S/N 18-6791Built 1959 · Hoffner Flying IncN9696LCessna 172P · S/N 17276599Built 1986 · Any Border LLC
Back to Yankton, SD