Salina, KS

Registered aircraft · 99

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

N127CTFlight Design CTSW · S/N 06-09-06Built 2006 · Hassler Randy DN1362YCessna 172C · S/N 17249062First renewal noticeBuilt 1961 · Kansas State UniversityN137MSBell 206B · S/N 2686Built 1979 · Kansas State UniversityN151RCClark Randolph R KR-2 · S/N 1Built 1986 · Clark Randolph RN1640NMcclish FUNK B85C · S/N 420Built 1947 · Burger Terry L TrusteeN1863WTextron 525B · S/N 525B0749Built 2025 · Kansas State UniversityN19719Cessna 172L · S/N 17260697Built 1972 · Kejr Melvin PN200TKDJI AGRAS T20P · S/N 1581F574B239100100G5T & K EnterprisesN20403Cessna 177B · S/N 17702669Built 1977 · Deatherage Edward DN2078APiper PA-28R-201 · S/N 28R-7837315Built 1978 · Ryan John TN22SZRawlins F A/Houseman D VANS RV-8A · S/N 81381Built 2001 · Bunn Rosemary J TrusteeN242TNMooney International M20TN · S/N 31-0140Built 2016 · Bycroft Kathleen A TrusteeN24327Cessna 152 · S/N 15280218First renewal noticeBuilt 1977 · Centurion AviationN269STHughes 269A · S/N 85-0363Built 1965 · Salina Tree IncN2898EAeronca 7AC · S/N 7AC-6481Built 1946 · Centurion Aviation LtdN327NSDJI AGRAS T50 · S/N 1581F6BUB243J001911PCame Equipment LLCN327SZDJI AGRAS T50 · S/N 1581F6BUB2431001C4R2Came Equipment LLCN355DCPiper PA-46-310P · S/N 46-8408079Built 1984 · Ryan John TN400GBReed Daniel B ACRO II · S/N 573Built 1996 · Reed Daniel BN4042VCessna 170 · S/N 18361Built 1948 · Freedom AviationN432MMMeyette Brian RV-7A · S/N 71008Kansas State UniversityN4573EAeronca 7CCM · S/N 7CCM-139Built 1949 · Cheatum Jamie KN47547Taylorcraft DCO-65 · S/N L-4846Farmer Larry A TrusteeN47KDMichalak Daniel A JR KITFOX V · S/N S94030002Built 1997 · Klassen Justin WN4834ZPiper PA-22-108 · S/N 22-8408Built 1961 · Roesner David AN496MMooney M-18C · S/N 246Built 1951 · Bc Enterprises Of Salina LLCN50525Beech 65-A90 · S/N LJ159First renewal noticeKansas State UniversityN5106BCessna 152 · S/N 15283747Built 1979 · Babcock Lori AN5500WBellanca 8KCAB · S/N 432-78Built 1978 · Kansas State UniversityN555LTBeech A36 · S/N E-737Built 1975 · Hogan DanielN56540Piper PA-34-200 · S/N 34-7350347Built 1973 · Schilling Aviation Services LLCN6010TCessna 162 · S/N 16200297First renewal noticeKansas State UniversityN60519Beech A36 · S/N E-1687Built 1980 · Bunn Robert Michael TrusteeN60669Cessna 162 · S/N 16200283First renewal noticeKansas State UniversityN6084BCessna T210M · S/N 21062678Built 1978 · Centurion Aviation LtdN6234CPiper PA-28-181 · S/N 28-7890349Built 1978 · Schilling Aviation Services LLCN6283HPiper J3C-65 · S/N 19467First renewal noticeBuilt 1946 · Middleton David E TrusteeN6355LAmerican AA-1A · S/N AA1A-0355Built 1972 · Locklear Steven MN68KSPiper PA-34-200T · S/N 34-7770252Built 1977 · Freedom Aviation Enterprise LLCN701CJCessna 401A · S/N 401A0022Built 1968 · Centurion Aviation LtdN70688Cessna 182M · S/N 18259358Built 1968 · Roesner David AN710TRCessna R172K · S/N R1722768Built 1977 · Sln Aviation LLCN723STPilatus PC-12/47 · S/N 723Built 2006 · Salina Aircraft Services IncN7261QCessna 172L · S/N 17260561Schilling Aviation Services LLCN7502JPiper PA-28R-180 · S/N 28R-30866Built 1968 · Irvin H HughN75263Boeing A75L300 · S/N 75-3621Built 1942 · Burger Terry L TrusteeN7568QCessna 310Q · S/N 310Q0068Built 1970 · Jughead Aircraft LLCN758DECessna R172K · S/N R1723006Built 1978 · Centurion Aviation LLCN7725KPiper PA-20 · S/N 20-547Built 1950 · Kansas State University SalinaN802KSTextron 172S · S/N 172S13388Built 2025 · Kansas State University
Back to Salina, KS