OpenAirDocs.org
Deadwood, SD

Registered aircraft · 49

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

N1193MCessna 172K · S/N 17258693Built 1969 · Eagle Sky Patrol IncN12521Cessna 172M · S/N 17262037Built 1973 · Eagle Sky Patrol IncN13551Cessna 172M · S/N 17262843Built 1973 · Eagle Sky Patrol IncN1381CCessna 177B · S/N 17702718Built 1977 · Eagle Sky Patrol IncN167RSSowers Ronald Eugene ZENITH CH750 CRUZER · S/N 10417Sowers Ronald EugeneN1851VCessna 120 · S/N 14119Built 1947 · Kraemer Norma JN2204YCessna 177 · S/N 17700004Eagle Sky Patrol IncN22191Cessna 150H · S/N 15068128Built 1967 · Perry OienN2306YCessna 177 · S/N 17700106Eagle Sky Patrol IncN244TBRobinson Helicopter R44 II · S/N 13629Built 2014 · Submissive Air IncN265YZEric Couch HIGHLANDER · S/N JA 380-05-14Built 2021 · Couch Eric DN2828XCessna 177 · S/N 17700228Built 1967 · Eagle Sky Patrol IncN29439Cessna 177 · S/N 17700888Built 1968 · Eagle Sky Patrol IncN29440Cessna 177 · S/N 17700889Built 1968 · Eagle Sky Patrol IncN2950XCessna 177 · S/N 17700350Built 1967 · Eagle Sky Patrol IncN29554Cessna 177 · S/N 17700960Built 1968 · Eagle Sky PatrolN29584Cessna 177 · S/N 17700974Built 1968 · Eagle Sky Patrol IncN2983XCessna 177A · S/N 17701365Built 1969 · Eagle Sky Patrol IncN2996XCessna 177 · S/N 17700396Built 1967 · Eagle Sky Patrol IncN30317Cessna 177A · S/N 17701190Built 1968 · Eagle Sky Patrol IncN30413Cessna 177A · S/N 17701240Eagle Sky Patrol IncN30654Cessna 177B · S/N 17701386Built 1969 · Eagle Sky Patrol IncN319FMacri Robert J JUST ACFT HIGHLANDER · S/N JA593-07-20Built 2023 · Couch EricN321DAAir Tractor AT-402A · S/N 402A-0814Built 1991 · Sherer Robert ON34320Cessna 177B · S/N 17701766Built 1972 · Eagle Sky Patrol IncN35163Cessna 177B · S/N 17702239Built 1975 · Eagle Sky Patrol IncN3529KPiper PA-28-140 · S/N 28-23544Built 1967 · Eagle Sky Patrol IncN354DBeech S35 · S/N D-7659Built 1964 · Air Repair IncN41631Robinson Helicopter R44 II · S/N 12294Built 2008 · Submissive Air IncN4855LPiper PA-28-180 · S/N 28-4204Eagle Sky Patrol IncN4975HPiper PA-11 · S/N 11-854Built 1948 · Morris Shannon DN5452TCessna 172E · S/N 17251352Built 1964 · Eagle Sky Patrol IncN608DBCessna 525 · S/N 525-0179Built 1997 · Door 4 LLCN614FLPiper PA-28-140 · S/N 28-7125493Built 1971 · Eagle Sky Patrol IncN63107Aerostar International RAVEN S57-A · S/N S57A-3110Old Style Saloon No 10N63483Cessna 172P · S/N 17275438Built 1981 · Eagle Sky Patrol IncN64294Cessna 172M · S/N 17265145Built 1975 · Eagle Sky Patrol IncN651ECCessna 177 · S/N 17700633Built 1967 · Eagle Sky Patrol IncN65VFRobinson Helicopter R44 II · S/N 10105Built 2003 · Submissive Air IncN6877FPiper PA-32-260 · S/N 32-7700004Built 1976 · Aces Full IncN700WWBeech C90 · S/N LJ-653Built 1985 · Aces Full IncN70228Cessna 172M · S/N 17267198Built 1976 · Eagle Sky Patrol IncN73069Cessna 172M · S/N 17267260Built 1976 · Eagle Sky Patrol IncN7869VMooney M20C · S/N 2832Built 1964 · Eagle Sky Patrol IncN8470UCessna 172F · S/N 17252370Built 1964 · Eagle Sky PatrolN87709Piper J3C-65 · S/N 15367Built 1946 · Sherer Robert ON9594HCessna 172M · S/N 17266253Eagle Sky Patrol IncN9679QCessna 172M · S/N 17265763Built 1975 · Eagle Sky Patrol IncN99KHHellmann Norma J CORBEN JR ACE E · S/N LN-1Built 1993 · Kraemer Norma J
Back to Deadwood, SD