OpenAirDocs.org
Hays, KS

Registered aircraft · 47

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

N1032GPiper PA46-500TP · S/N 4697285Built 2006 · Osgood Air LLCN11067Champion 7ECA · S/N 81Built 1965 · Teel Glen AN1801VBeech A36 · S/N E-1859Southwind Aviation LLCN185AECessna A185F · S/N 18502125Built 1973 · Dbl LLCN192WJJames Wayne A AEROSPORT-3 SCAMP · S/N J-002Built 1987 · Teel Glen AN2088UCessna U206G · S/N U20606610Built 1982 · Simpson Equipment Leasing LLCN21MFRaytheon 58 · S/N TH-1871Built 1998 · Osgood Air LLCN222CLCrazy OLD Lions RANS S-21 OUTBOUND · S/N 01220234Built 2025 · Crazy Old Lions LLCN2379DCessna 170B · S/N 20531Built 1952 · Moore Orville GN250MBRaytheon Corporate Jets BAE 125-800A · S/N 258237Built 1993 · No Layover LLCN307JRLancair LC41-550FG · S/N 41513Built 2005 · Satellite Radio Management IncN338GMSmith Glenneth B H/Smith Maria RANS S6-S · S/N 01081850Built 2012 · Gil Edmund CN3517KPiper J3C-65 · S/N 22208Built 1946 · Moore Orville GN4063QCessna 310Q · S/N 310Q0724Built 1973 · Thin Air IncN502DBAir Tractor AT-502B · S/N 502B-3007Built 2014 · Dbl LLCN5050JSchlitter Randy RANS S-10 · S/N 0188001Schlitter RandyN509KSKelly L Crain RANS DSGN S21 OUTBND · S/N 11200151Built 2023 · Crain Kelly LN513DTRans Employee Flying Club S-20LS · S/N 07130001Built 2013 · Rans Employee Flying ClubN516SRandy Schlitter S-16 SHEKARI · S/N 0101028Built 2016 · Schlitter RandyN52895Cessna 182P · S/N 18262933Marshall Brian LN54417Piper PA-32-300 · S/N 32-7440052Built 1973 · Moore Alan JN5641DJI T-30 · S/N 527BK9P0010056Smoky Hill Precision Ag LLCN6105SCessna R182 · S/N R18201612Built 1980 · My Sky LLCN615RDRans Designs S-21LS OUTBOUND · S/N 04180002Built 2019 · Rans Designs IncN6502HLancair LC42-550FG · S/N 42037Built 2004 · Simpson Equipment Leasing LLCN664KMichael J Konz RV-14A · S/N 140049Built 2019 · Konz Michael JN6654RBeech V35B · S/N D-10273Built 1979 · Low Mach Aero LLCN678WKDJI AGRAS T50 · S/N 1581F6BUB24850017PVKansas State UniversityN6854NMooney M20C · S/N 680137Built 1968 · Teel Glen AN7012WSchlitter Randy RANS S-11 PURSUIT · S/N 393004Built 1993 · Schlitter Randy JN7054WPiper PA-28-180 · S/N 28-820Language Gert JohannesN707EDDresher Edward RANS S-7 · S/N 1093121Built 1995 · Kisner Jared AN716RDRandy Schlitter RANS S-21 OUTBOUND · S/N 06250429Built 2025 · Rans Designs IncN719RSRans S-19 · S/N 070600001Built 2007 · Rans Aircraft IncN7289ZPiper PA-25-235 · S/N 25-3232Built 1965 · Werth John FN759GDCessna 182Q · S/N 18265975Built 1977 · Thin Air IncN80184Cessna 172M · S/N 17266428Built 1975 · Ljmf LLCN809CPiper PA 46-350P · S/N 4636485Built 2010 · Jl & R Aviation LLCN812TCRans Designs S-7LS · S/N 00796-0002Built 2010 · Rans Designs IncN81RXMilton R Holloway RV-7A · S/N 72824Built 2017 · Moore Alan JN8355HPiper PA-32R-301T · S/N 3257204Built 2001 · Ljmf 17 LLCN862EFPowrachute AIRWOLF 912ULS · S/N A325VIKBuilt 2019 · Jones Jarrod EN9067SSchlitter Randy RANS S-9 · S/N S986001Built 1986 · Schlitter Randy JN910TDAnthony J Dopita S-20 RAVEN · S/N 11150054Built 2019 · Dopita Anthony JN9252MMooney M20C · S/N 3452Built 1966 · Starfox Aero LLCN944MAAviat A-1B · S/N 2211Built 2002 · Ljmf 17 LLCN9598GCessna 182P · S/N 18263406Built 1974 · Stecklein Daniel R
Back to Hays, KS