OpenAirDocs.org
Brookings, SD

Registered aircraft · 60

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

N103XSBurkhart Grob G 103 TWIN II · S/N 3745Built 1982 · Prairie Thermals LLCN106JSCirrus Design SR22T · S/N 1661Built 2018 · Blok Air IncN1090WCessna 172S · S/N 172S10284Built 2006 · Medary Aviation LLCN11969American General Acft AG5B · S/N 10126Brookings Aerosports Unlimited IncN1310ABeech 35-C33 · S/N CD-1105Built 1967 · Koep Evan TN1674ECessna 172S · S/N 172S9915Built 2005 · Medary Aviation LLCN1956VCessna 172S · S/N 172S9934Built 2005 · Medary Aviation LLCN2121FCessna 172S · S/N 172S10437Built 2007 · South Dakota State UniversityN243SDPiper PA-44-180 · S/N 4496576Registration pendingBuilt 2024N247WYCirrus Design SR22T · S/N 11368Built 2026 · Brimen Aviation LLCN288MECessna 172S · S/N 172S8548Built 2000 · South Dakota State UniversityN2911BXag P100 PRO · S/N 1863FPEG82193392W57TGrimsrud Thad JN3347NPiper J3C-65 · S/N 22546Built 1946 · Fite Robert GN3434RCessna 182L · S/N 18258734Built 1967 · Burkhardt JamesN39599Aeronca 65-TAC · S/N C5643TABuilt 1943 · Barney John AN4077SBeech A36 · S/N E-638Built 1975 · Riedesel Lynn RN430SDTextron 172S · S/N 172S13323Built 2025 · Medary Aviation LLCN457SPCessna 172S · S/N 172S8321Built 1999 · South Dakota State UniversityN4685XCessna 150G · S/N 15064735Built 1966 · Fite Robert GN4686BCessna 180 · S/N 31584Built 1955 · Thompson Harrison CN51637Cessna 172S · S/N 172S9033South Dakota State UniversityN521SDTextron 172S · S/N 172S13137Built 2024 · Medary Aviation LLCN522SDTextron 172S · S/N 172S12920Built 2022 · South Dakota State UniversityN5309FCessna 172S · S/N 172S9273Medary Aviation LLCN5333EBeech K35 · S/N D-5824Built 1959 · Beech Bums LLCN537CLAviat A-1B · S/N 2176Built 2001 · Ackerman Terry LN5566KTennessee Engineering & Mfg HI MAX 1700 · S/N 631Built 1994 · Cooper Jim AN605GREa Vision EA J100 · S/N EAVUAV502585892Agrone Solutions LLCN605SDTextron 172S · S/N 172S13271Built 2024 · Medary Aviation LLCN6297XCessna 340A · S/N 340A0468Mike Sierra LLCN62HBohner-Hershiser STITS PLAYBOY S1 · S/N BH11Fite Robert GN6365NChampion 7KCAB · S/N 41Built 1967 · South Dakota State UniversityN6377XPzl-Swidnik PW-5 · S/N 17.10.024Built 1998 · Prairie Thermals LLCN6508RBeech C23 · S/N M-1583Registration pendingBuilt 1974N65728Adkins Clifford P BIPLANE · S/N 4Fite Robert GN6576SBeech A36 · S/N E-803Built 1976 · Beech Aviators LLCN680NDPiper PA-44-180 · S/N 4496384Built 2015 · Medary Aviation LLCN697NDPiper PA-44-180 · S/N 4496385Built 2015 · South Dakota State UniversityN69HSHarrison C Thompson GLASAIR SH-2R · S/N 2361Built 2025 · Pofahl Steven RN7180RPiper PA-28-140 · S/N 28-21891Built 1966 · Kostas KaounasN71HKAir Tractor AT-802A · S/N 802A-1186Built 2025 · Sak IV LLCN728SFlight Design CTSW · S/N 06-11-19Built 2006 · Dusty Sails LLCN74LHSchool District 274 EMERAUDE · S/N 1413Built 1974 · Petik Wil AN78MLCessna T206H · S/N T20608731Dakota Wings LLCN792MMclaughlin Robert J RV-4 · S/N 3750Built 2002 · Mclaughlin Theadolinda JN801THTextron 172S · S/N 172S12801Built 2022 · South Dakota State UniversityN805FWCessna 172S · S/N 172S8348Built 2000 · Medary Aviation LLCN808CSRaytheon 390 · S/N RB-62Sierra Alpha Aviation LLCN8182TTextron T206H · S/N T20609549Built 2018 · Mesa Aviation LLCN81SUBeech C90A · S/N LJ-1194Built 1989 · Medary Aviation LLC
Back to Brookings, SD