OpenAirDocs.org
Box Elder, SD

Registered aircraft · 39

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 = 'BOX ELDER'
  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.

N109JAAaron James F H5 · S/N JAD-4Built 2013 · Rocca John CN158CVAeros VELOCITY II · S/N 054Built 2003 · Smawley K MasonN2037ABeech A36TC · S/N EA-3Built 1979 · Crosswind Enterprises LLCN222YBManuel Borrero/Pedro Rodriguez SEAREY LSX · S/N 1LK545CCameron Chad EN3184JFolken Les KITFOX III · S/N 817Built 1992 · Belcher Sylvester AN32LKWilson Duane C RV-9A · S/N 91199Built 2007 · Morrow Gregory AN333PDJohnson Paul B AVID MARK IV · S/N 1256DBuilt 2009 · Belcher Sylvester AN34045Cessna 177B · S/N 17701612Built 1970 · Ackerman Mark RN398HASchrauder Matthew HAWK ARROW · S/N H-SSA-922-TD-503Rocca JohnN400FCCessna 414A · S/N 414A0023Crosswind Enterprises LLCN4018KArbc Inc DBA Lindstrand 77X · S/N 5769Built 2022 · Keller Kelli CN4143ZPiper PA-18-150 · S/N 18-8221Built 1965 · Ravenscroft Brant AN46BTHumpton Lyle R RAF 2000 GTX SE FI · S/N H2-06-17-661Built 2006 · Tayler Baron LN5272YAerostar International RX 8 · S/N RX8-3334Built 2000 · Shrum Michael LN5515ECessna 150 · S/N 17015Built 1958 · Nomad Pursuits LLCN5560Albright Harold SONEX · S/N 888Built 2007 · Rocca John CN567USDJI INSPIRE 1 · S/N W13DCB16020628Syme Bob NN5754DPiper PA-22-150 · S/N 22-4454Rocca JohnN5839RMaule MX-7-180A · S/N 20042CBuilt 1995 · Giraud StephenN586MKDJI MINI 5 PRO · S/N 1581F9DEC25BV029JE1LKwok Samuel SN63162Aerostar International RAVEN S57-A · S/N S57A-3113Built 1990 · Young Deborah LN6393XBecker Leonard L CHRISTAVIA MK1 · S/N 010Built 2000 · Mccarney Thomas RN6611XCessna 182F · S/N 18254798Built 1963 · Nelson AnnN700ASAthenian School SUPER SPORT · S/N 001Built 2005 · Gunderson David AN701FNBalony Kubicek Spol Sro BB20GP · S/N 715Built 2009 · Young Deborah LN7233MCessna 175 · S/N 55533Built 1958 · Gunderson David AN7544SMensink Jan ROTORWAY 162F · S/N 7227Sale reportedBuilt 2008N75755Kolb TWINSTAR · S/N 051689Blasius Travis LN777PXKornoff Ivan Peter KOMET -7 · S/N 70861Built 2005 · Kornoff Ivan PN7932MBeech V35 · S/N D-8241Built 1966 · Power James PN8004KArbc Inc DBA Lindstrand 60X · S/N 5767Built 2022 · Keller Kelli CN81738Aeronca 7AC · S/N 7AC-359Built 1945 · Seidner Neil WN8990ZMichael D Stom MXL II SPORT · S/N 0953Built 2013 · Stom Michael DN9091HCessna 172M · S/N 17265937Built 1975 · Campbell RaymondN917DBPiper PA-46-600TP · S/N 4698129Havir Douglas CharlesN958BMBrad G Marcum THATCHER CX4 · S/N 179Built 2019 · Rocca John CN9642DPiper PA-22-150 · S/N 22-6556Built 1959 · Malsom Isaac BN9704GCessna 180H · S/N 18052204Built 1971 · Johnsons Aero Ag IncN975TBeech 35-33 · S/N CD-179St Lucys LLC
Back to Box Elder, SD