OpenAirDocs.org
Spearfish, SD

Registered aircraft · 53

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

N119PECessna LC41-550FG · S/N 411043Doo Me Too LLCN1373ECessna 172N · S/N 17270975Built 1978 · Eagle Aviation LLCN16583Piper PA-28-140 · S/N 28-7325301Built 1973 · Gawlikowski Joseph JN1686ECessna 172N · S/N 17271093Built 1978 · Liddick Terry SN169PCAmerican Champion 7GCBC · S/N 1359-2004Built 2004 · Sachau Glen RN224BSDiamond Aircraft Ind DA 40 · S/N 40.428First renewal noticeBuilt 2004 · Hoff Brian DN257DCWeaver Lloyd J JR DAKOTA COYOTE · S/N 2Built 2001 · Weaver Lloyd J JrN2680PConsolidated Aeronautics LAKE LA-4-200 · S/N 889Built 1978 · Mach One LLCN2700YCessna 340 · S/N 340A0793Eaton Air LLCN2790GCessna 182B · S/N 52090Built 1959 · Bryan Roger JN301KTSeavall Mike LANCAIR IV · S/N 043Built 1994 · Check 6 LLCN324PTPtacek Mark J VANS RV-10 · S/N 40081Built 2007 · Planedocs LLCN350HNPiper PA 46-350P · S/N 4636681Built 2015 · Powerlift Door Consultants IncN3579VCessna 140 · S/N 14748Built 1948 · Greslin Michael DN357RJPiper PA-18-150 · S/N 18-5071Built 1956 · Jilek Ray AN35962Cessna U206F · S/N U20602833Built 1975 · Barker Aviation LLCN3614RPiper PA-28-180 · S/N 28-5710Krautschun BartN4127MPiper PA-12 · S/N 12-3024Built 1947 · Rand Richard EN463TBeech P35 · S/N D-7083Built 1963 · Check 6 LLCN477CSEurocopter/Canada BO 105LS A-3 · S/N 2045Registration pendingBuilt 1994N477LZDJI T40 · S/N 4LGZKC100701LLLacina Daron FN478CSEurocopter/Canada BO 105LS A-3 · S/N 2053Registration pendingBuilt 1998N4802BCessna 180 · S/N 31600Built 1954 · Jilek Ray AN4965MPiper PA-11 · S/N 11-451Built 1948 · Clark Ernest EdgarN5002GLarsen C J/Larsen B A RANS S6ES · S/N 02051637Built 2006 · Schwalm Wylie HN5034VBellanca 8KCAB · S/N 467-79Built 1978 · Bibler Barry DN503JPPatterson James F QUICKIE Q-2 · S/N 2289Built 1990 · Patterson James FN5174ZPiper PA-22-108 · S/N 22-8838Sale reportedBuilt 1961N5216SPiper PA-32-300 · S/N 32-40910Sale reportedBuilt 1970N5344RCessna 172F · S/N 17252872Built 1965 · Moxley Michael DN535SCHoff Douglas H ZENAIR CH 701 SP · S/N 7 9493Built 2004 · Hoff Douglas HN5770ECessna 150 · S/N 17270Built 1959 · Eagle Aviation LLCN5775UPiper PA-28-140 · S/N 28-26599Built 1970 · Bravo Tango AviationN5925VPiper PA-34-200T · S/N 34-7770271Built 1977 · Mcgreevy Duane TN64CGBeech S35 · S/N D-7674Built 1964 · Robinson James DN6515Stits Playmate SA-11-A · S/N HCB-1Built 1968 · South Dakota Aviation Hall Of FameN67DRBeech V35B · S/N D-9772Larson JeffreyN6895ACessna 172 · S/N 28995Built 1956 · Dettman Gary LN701RKKrause Roland ZENAIR CH 701 SP · S/N 7-9370Built 2003 · Martin Alden CN7183DPiper PA-18A 150 · S/N 18-5647Fedorko Michael IIIN72516Cessna 120 · S/N 9686Built 1946 · Schwalm Wylie HN7272RCessna 182S · S/N 18280492Built 1999 · Bst Equipment LLCN737DGCessna 172N · S/N 17269333Eagle Aviation LLCN741TJPiper PA-30 · S/N 30-477Built 1964 · Jackson Thomas R JrN80098Lingscheit Richard A RAPTOR · S/N A186CDRBuilt 2003 · Lingscheit Richard AN81143Funk B85C · S/N 273Jackson Thomas R JrN847WAPiper PA-12 · S/N 12-3214Built 1947 · Mcpherson Duane EugeneN899NWarren James M RV-4 · S/N 4472Richards Vallin JN91507Cessna 172M · S/N 17261499Built 1973 · Eagle Aviation LLCN9370HBeech D17S · S/N 4846Built 1944 · Rath Aviation Services LLC
Back to Spearfish, SD