OpenAirDocs.org
Rapid City, SD

Registered aircraft · 151

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 = 'RAPID CITY'
  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.

N101WPiper PA-32R-301 · S/N 32R-8013087Built 1980 · Cole-Tac LLCN1036CRans S-12XL · S/N 02050996Built 2006 · Benkert Daniel DN104BRBelsaas Richard A RV-10 · S/N 40373Built 2007 · Belsaas Richard AN10NHDaughenbaugh Randy SKYSTAR KITFOX SER 5 · S/N S9909 0214Built 2004 · Daughenbaugh Randall JN114SCChristiansen-Robert BERYL CP-750 · S/N 7-2-50Built 1979 · Christiansen Robert ScottN127VASchindler M M/Schindler B L RV9A · S/N 90127Built 2003 · Telkamp Gary ON1391WRutan/Petrosino LONG EZ · S/N 124Built 1983 · Kotinek Douglas AN142JLHayward Jim C-2 · S/N CH2-0498-1743Built 2000 · Hayward JimN143LWCessna R182 · S/N R18201265Built 1979 · Murphy Law Office PcN145AFRaytheon C90A · S/N LJ-1721Dale Aviation IncN1468Starduster SA-300 · S/N 210Built 1968 · Benkert Daniel DN1549APiper PA-20 · S/N 20-752Dirk Chantz MN162TEAnderson Gregory TURBINE EXEC · S/N 6726Anderson GregoryN1689TPiper PA-28-140 · S/N 28-7125006Built 1970 · Fun Flyers LLCN1692PPiper PA-22-150 · S/N 22-2478First renewal noticeBuilt 1954 · Hoffmeyer Ronald PN1742ECessna T310R · S/N 310R1558Built 1978 · Cole-Tac LLCN184SCChristiansen R Scott ELLIPSE · S/N 4Built 2010 · Christiansen Robert SN1904EChampion AERONCA 7AC · S/N 7AC-5471Built 1946 · Telkamp Gary ON201YGMooney M20J · S/N 24-0515Built 1978 · N201yg LLCN203RFCirrus Design SR22 · S/N 0453Built 2003 · Rapid Flyers LLCN204SDAmerican Champion 8KCAB · S/N 958-2004Ostern Mark LynnN2057TSchweizer SGS 2-33A · S/N 487Built 1977 · Larson Martin BN207PBeech C90A · S/N LJ-1406Built 1995 · Dale AviationN2085Kolter SAILPLANE TERN 1 · S/N RMKWTM1872Built 1972 · Clark Raymond CN21757Cessna 172M · S/N 17264007Built 1974 · Olson Terry LN220APWright M John AVID BANDIT · S/N 1420EBuilt 1994 · Ewald AlanN220VACirrus Design SR22T · S/N 11192Built 2026 · Vision Air LLCN222PJPiper PA-28-180 · S/N 28-7305259Built 1973 · Schroeder James LN22596Cessna 150H · S/N 15068390Built 1968 · Anderson Bradley PN23201Piper J3F-60 · S/N 2975Belsaas Richard AN23MYSocata TBM 700 · S/N 483Built 2008 · Jetka LLCN24107Hammond Steve A BEAVER RX 550 · S/N 001Built 2007 · Hammond Steve AN243CDCirrus Design SR20 · S/N 1252Built 2002 · Sojourn Flight LLCN2538MLancair LC41-550FG · S/N 41081Built 2005 · Warren James RentN256PCPiper PA-18-150 · S/N 18 8537Built 1969 · Hall RobertN2577QCessna A185F · S/N 18503520Built 1977 · Slingsby J GeoffreyN266ETaylorcraft/Ellis BL-65 · S/N 2012Built 1940 · Aero Leasing LLCN269CJCessna 172L · S/N 17259512Built 1970 · Larson Martin BN26ARRaytheon C90A · S/N LJ-1725Built 2004 · Dale AviationN284MRRaytheon C90A · S/N LJ-1729Built 2005 · Dale Aviation IncN291WWDavid Wayne Hendrickson ZENITH 750 SD STOL · S/N 750SD-11480Hendrickson David WN2927ZPiper PA-22-150 · S/N 22-6898Built 1959 · Densmore Jerry LN2930VPiper PA-34-200T · S/N 34-7970384Dale Aviation IncN2970NPiper PA-28-236 · S/N 28-7911283Built 1979 · Gilcrease Patrick CN2PNPiper PA-31-350 · S/N 31-7752141Built 1977 · Fugro USA Land IncN3022ZPiper PA-22-150 · S/N 22-6975Van Helsdingen RiaanN3041WBeech V35A · S/N D-8824Built 1968 · Estes Aviation LLCN304CLHPH GLASFLUGEL 304CZ-17 · S/N 50-17Built 2002 · Murphy John RN305RTMooney M20K · S/N 25-0051Morris AlysseN310TXBeech 300 · S/N FA-140Built 1988 · Riddles Group Inc
Back to Rapid City, SD