OpenAirDocs.org
Satanta, KS

Registered aircraft · 18

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 = 'KS' AND g.registrant_city = 'SATANTA'
  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.

N2912DCessna 170B · S/N 26855Satanta Flying Service IncN3004KAyres S2R-G10 · S/N G10109Built 1994 · Ag Solutions LLCN332ATAir Tractor AT-802A · S/N 802A-0087Built 1999 · Ag Solutions LLCN35474Cessna 172I · S/N 17256789Built 1968 · Massey Shawn AN3765JCessna 150G · S/N 15065065Satanta Flying Service IncN3791YCessna 210D · S/N 21058291Built 1964 · Satanta Flying Service IncN47NLBilly V Anton BEARHAWK · S/N 135BBuilt 2018 · Anton Billy VN546CBRaytheon A36 · S/N E-3489Flatland Aviation LLCN60940Cessna 150J · S/N 15070681Built 1969 · O Lazy L Ranch & FarmN6127LAyres S2R-G5 · S/N G5-103Built 1994 · Ag Solutions LLCN6136ZAyres S2R-G6 · S/N G6-138Built 1996 · Ag Solutions LLCN7115MCessna 175 · S/N 55415Built 1958 · Satanta Flying Service IncN76632Cessna 140 · S/N 11072Built 1946 · Satanta Flying Service IncN802KPAir Tractor AT-802A · S/N 802A-0397Built 2011 · Ag Solutions LLCN836MCCessna T182T · S/N T18208835Robec LLCN88MAerotek PITTS S-2A · S/N 2131Satanta Flying Service IncN946BVBill Anton VAN'S RV-4 · S/N 3735Built 2022 · Anton BillN9875VCessna A188 · S/N 188-0125Built 1966 · Satanta Flying Service Inc
Back to Satanta, KS