OpenAirDocs.org
Great Bend, KS

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

N13114Piper F-2 · S/N 47Martinez AnthonyN14485Rearwin 7000 · S/N 403Built 1935 · Martinez Anthony IIIN15STCessna 425 · S/N 425-0140Built 1981 · Spray Brothers Aviation LLCN17554Piper J-2 · S/N 1057Martinez Anthony NmnN19455Cessna C-38 · S/N 408Tonys Aerial Spraying IncN19484Cessna C-145 · S/N 454First renewal noticeBuilt 1938 · Koelling William WN200PJStone P/Mcrostie J J GILES G200 · S/N G2001002Built 1997 · Clayton Allen HeidelbergN204HWHaring Clay RV6A · S/N 25151Built 2004 · Nordman Marvin JN205CGAir Tractor AT-502A · S/N 502A-2603Built 2006 · Seewald Jeffrey WN2305CCessna 180 · S/N 30605Latham Cory DN2414Piper E-2 · S/N 64Martinez Anthony IIIN2828ACessna 180 · S/N 30028Latham Cory DN2WDNavion NAVION B · S/N NAV-4-2153-BBuilt 1950 · Brantley Scott RN305CRCessna 305A · S/N 21483Built 1950 · Seewald Jeffrey WN35657Piper J3F-65 · S/N 6516Built 1941 · Martinez Anthony IIIN417SPBellanca 7GCAA · S/N 1350-80Built 1980 · Tonys Aerial Service IncN421BCCessna 421C · S/N 421C0086Built 1976 · Spray Brothers Aviation LLCN42319Piper E-2 · S/N 303Built 1934 · Martinez AnthonyN424CKCirrus Design SR22 · S/N 3495Cca Aviation LLCN4364BPiper PA-32R-301 · S/N 32R-8413018Built 1984 · Fairway Aviation LLCN4729MPiper PA-11 · S/N 11240Built 1947 · Tonys Aerial Spraying IncN568TXCessna 560 · S/N 560-0558Built 2001 · Spray Brothers Aviation LLCN582ZAEavision EA-J70 · S/N JMZKJ070UAV612555407Performance Crop Research LLCN604MPAir Tractor AT-602 · S/N 602-1258Built 2015 · Seewald Jeffrey WN605ADPiper PA-28-140 · S/N 28-20067Built 1964 · Blue Sky Aviation LLCN6259PPiper PA-24-250 · S/N 24-1366Built 1959 · Wyant Dustin JayN6388CPiper PA-28R-201T · S/N 28R-7803225Built 1978 · Spray Brothers Aviation LLCN697CGDJI AGRAS T30 · S/N 3U5BJ6P001000EAmerican Plains Co-OpN7050YPiper PA-30 · S/N 30-53Built 1963 · Tonys Aerial Service IncN7581HPiper PA-12 · S/N 12-451Built 1946 · Martinez Anthony IIIN777SPiper PA-18-150 · S/N 18-8109040Built 1981 · Nichols Max EN807SHHoughton Stephen M RV7A · S/N 73116Built 2012 · Circle5 LLCN80951Piper J3P · S/N 2471Martinez AnthonyN814BKKilgore Brandyn L RV-7A STANDARD · S/N 74731Built 2025 · Kilgore Brandyn LN8244JPiper AEROSTAR 601P · S/N 61P06487963299Built 1979 · Tonys Aerial Service IncN896SJPiper PA 46-350P · S/N 46-36033Built 1996 · Tumbleweed Aviation LLCN916JTextron 560XL · S/N 560-6353Built 2023 · Rock Springs Management IncN949WCCampbell Weldon CAMPBELL RV6 · S/N 23469Built 1997 · Campbell Weldon WN992CBaker Clark D LANCAIR LEGACY · S/N L2K-312Baker Clark D
Back to Great Bend, KS