OpenAirDocs.org
Scott City, KS

Registered aircraft · 37

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 = 'SCOTT CITY'
  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.

N111NMPiper PA-46-310P · S/N 46-8508006Built 1984 · Hineman Land & Cattle IncN112VFPilatus PC-12/47 · S/N 882Built 2008 · Victor Foxtrot LLCN1314Jodel D-11 · S/N F5072Built 1967 · Buehler Jon RN13884Cessna 172M · S/N 17263028Triple F Aviation LLCN172VFCessna 172M · S/N 17265334Built 1975 · Victor Foxtrot LLCN1901XCessna 182H · S/N 18256001Built 1965 · Buehler Jon R TrusteeN2023KBeech 95-B55 (T42A) · S/N TC-2169Built 1978 · Juliet Foxtrot LLCN215DJCessna 182T · S/N 18281622Built 2005 · Great Plains Aviation LLCN230VFCirrus Design SR22T · S/N 8824Built 2022 · Victor Foxtrot LLCN2835MPiper PA-28-181 · S/N 28-7890271Built 1977 · Wth Aviation Services LLCN2966CPiper J5A · S/N 5-804James NeilN4030KNorth American NAVION A · S/N NAV-4-1030Built 1947 · Burnett David MarkN407JFBell Textron Canada 407 · S/N 56439Built 2025 · Juliet Foxtrot LLCN486GETalos Drones T60X · S/N 2104F7EZB251J0017H70Edwards Spraying IncN553RWPilatus PC-12/45 · S/N 553Built 2004 · Foxtrot Sierra Bravo LLCN560VFCessna 560XL · S/N 560-5135Built 2000 · Victor Foxtrot LLCN57385Bellanca 7GCAA · S/N 260-73Built 1973 · Victor Foxtrot LLCN6266FCessna 182P · S/N 18264145Built 1975 · Silver 7 Aero LLCN629GVMyles Vulgamore RV-8 · S/N 82320Built 2025 · Victor Foxtrot LLCN6736GBeech A36 · S/N E-1648Built 1980 · Kough BryanN700GVSocata TBM 700 · S/N 290Built 2004 · E6 Aviation LLCN70GKPiper PA-28-181 · S/N 28-7790590Built 1977 · Scott Archer LLCN729JFBombardier BD-100-1A10 · S/N 20969Built 2023 · Juliet Foxtrot LLCN73371Cessna 172M · S/N 17267409Built 1976 · Elliott AaronN738ACGteex Revolution INDEPENDENCE 19 · S/N 212985300C853Vulgamore Land & Cattle Co IncN7936ABeech A36 · S/N E-1421Built 1978 · Bb Air Guys LLCN79WPCirrus Design SR22T · S/N 0354Built 2012 · 79wp LLCN8219ACessna 170B · S/N 25071Built 1952 · Elder Joel MN8368TCessna 175C · S/N 17557068Built 1962 · Yager James AN836RVStevenson W/Stevenson D/Kough RV-6 · S/N 21865Built 2006 · Bk Auto IncN8396NBeech 56TC · S/N TG-64Built 1968 · N&R Enterprises LLCN844MBRobinson Helicopter R44 II · S/N 13766Built 2014 · Victor Foxtrot LLCN8907DJI AGRAS T50 · S/N 63YBMAG002008TTurner FarmsN8908DJI AGRAS T50 · S/N 63YBMAG00200AGTurner FarmsN914TLCirrus Design SR22 · S/N 1142Built 2004 · Thomas MichaelN939BWBeech 300 · S/N FA175Built 1989 · Poky Feeders IncN958SBCessna R182 · S/N R18200954Built 1979 · Victor Foxtrot LLC
Back to Scott City, KS