OpenAirDocs.org
Pierre, SD

Registered aircraft · 70

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

N107MLAir Tractor AT-402B · S/N 402B-1250Built 2012 · Mike Ogan FarmsN1094GRaytheon 58 · S/N TH-1794Built 1996 · Ogan Michael JN118VRPiper J3C-65 · S/N 22095Built 1946 · Alliance Aircraft Sales IncN127ARCessna 208B · S/N 208B1055Built 2004 · Aircraft Unlimited IncN14JPBeech F33C · S/N CJ-177Built 1986 · Dakota Aircraft IncN15219Piper PA-28-235 · S/N 28-7310024Built 1972 · Shoup Michael DN200EKCessna 425 · S/N 425-0205Built 1984 · Bw Air LLCN2118ACessna T206H · S/N T20608451Built 2004 · South Dakota Highway PatrolN22JPSocata TB 30 EPSILON · S/N 85Built 1986 · Dakota Aircraft IncN242HABeech N35 · S/N D-6626Built 1961 · Rounds Agronomy LLCN24ABBunch Arle Ellis KR-2 · S/N 1Built 1984 · Koch Thomas RN24AYThomas R Koch AMERICAN EAGLET · S/N 1Built 2021 · Koch Thomas RN2608MPiper PA-12 · S/N 12-1074Built 1946 · Ehrenfelt Linda MaeN2688DCessna 414A · S/N 414A0332Built 1979 · B2 Air LLCN290FFThomas R Koch HM290 FLYING FLEA · S/N 1Koch Thomas RN29809Taylorcraft BL-65 · S/N 2658Timmons David LN304WSBreezer BREEZER · S/N 007 LSAMaberry Buell GN329JHBeech A36 · S/N E-870Built 1976 · Alliance Aircraft Sales IncN333TLBeech C90 · S/N LJ-999Built 1982 · Brad And Jill Janecke LLCN34JPBeech F33C · S/N CJ-39Built 1973 · Dakota Aircraft IncN35050Cessna 177B · S/N 17702176Built 1974 · Wings Aloft LLCN37126Beech A36TC · S/N EA-156Built 1980 · Robison Charles TN3945TPiper PA-28R-180 · S/N 28R30288Elsinger Vincent RN3954ZPiper PA-18-150 · S/N 18-7813Built 1962 · Thompson Charles MN4027HPiper PA-12 · S/N 12-3455Built 1947 · Ehrenfelt Linda MaeN406TACessna 172S · S/N 172S9406Built 2003 · Aircraft Unlimited IncN406WSWild Sky GOAT · S/N 1706Morris Milton LN4158YPiper PA-18-150 · S/N 1809103Built 1994 · Alliance Aircraft Sales IncN42JBBell Helicopter Textron Canada 505 · S/N 65091Built 2018 · Alliance Aircraft Sales IncN43745Piper PA-28-161 · S/N 28-7816020Coyle Andrew JN4400HPiper PA-15 · S/N 15-184Built 1948 · Stein WesleyN4476ZPiper PA-18-150 · S/N 18-8827S And C Flying LLCN4499WPiper PA-28-180 · S/N 28-2911Built 1965 · Urban James RN4657EAeronca 7EC · S/N 7EC-7Built 1950 · Nystrom Bay Farm PartnershipN477MBeech C90 · S/N LJ-1154Built 1987 · Aircraft Unlimited IncN4811MPiper PA-11 · S/N 11-322Built 1947 · Schumacher Marvin LN4811UCessna 210-5A · S/N 205-0511Built 1963 · Swartz Ryan WN4843TPiper PA-28-180 · S/N 28-7205205Built 1972 · Huizenga Jamie LN514FSCanadian Car & Foundry HARVARD MK IV · S/N CCF-4-172Dakota Aircraft IncN5451WPiper PA-28-160 · S/N 28-529Built 1962 · Andre Craig WN547ACAir Creation USA ARV TANARG · S/N AC10-36Morris Milton LN55JPCessna 525 · S/N 525-0296Built 1998 · Dakota Aircraft IncN56253Breezer BREEZER · S/N 005LSAMaberry Buell GN605VTTeton River Enterprises M24 ORION PLUS · S/N 24224206Built 2023 · Horizon Agronomy And Seed LLCN61SHAerospatiale TB 30 EPSILON · S/N 80Built 1986 · Alliance Aircraft Sales IncN63907Piper PA-18-150 · S/N 18-8009022Built 1979 · Brad & Jill Janecke LLCN699RABoeing E75N1 · S/N 75-4556Built 1943 · Dakota Aircraft IncN7088DCessna 172B · S/N 17248392Built 1961 · Shoup Greg LN7172QCessna 172L · S/N 17260472Rounds Agronomy LLCN717DCBeech B200 · S/N BB-1261Aircraft Unlimited Inc
Back to Pierre, SD