OpenAirDocs.org
Newton, 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 = 'NEWTON'
  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.

N12268Cessna 425 · S/N 425-0227Ballard Aviation IncN123BVPiper PA-22-160 · S/N 22-5756Built 1957 · Infinity Metalworks IncN14CHCarlson-Hannasch DAVIS DA-2 · S/N 14Built 1973 · Clark Spencer LN176LABeech F90 · S/N LA-210Built 1983 · Ballard Aviation IncN2536QCessna 182K · S/N 18257736Built 1966 · Wiebe TimN2819UCessna 172D · S/N 17250419Built 1963 · Gartner Thomas MN303HBTextron T206H · S/N T20609577Built 2019 · Fly The Coop LLCN3242RRoberts Brown STARDUSTER TOO · S/N 1694Built 1982 · Robertson Dale RN333TAHughes Helicopters HUGHES 369D · S/N 590500DBuilt 1979 · Ballard Aviation IncN34PVVermilyea Paul E N3 SUPER PUP · S/N 62006Vermilyea Paul EN399ALTextron B200 KING AIR · S/N BB-1623Ballard Aviation IncN4601WCessna P210N · S/N P21000622Built 1980 · Mike Papa LLCN4872KCessna P210N · S/N P21000351Built 1979 · Mike Papa LLCN487FPBeech F90 · S/N LA-98Ballard Aviation IncN507GFRaytheon B200 · S/N BB-1778Built 2001 · Ballard Aviation IncN5171ACessna 172 · S/N 28171Built 1955 · Infinity Metalworks IncN5292SPiper PA-28-140 · S/N 28-26923Built 1970 · Vermilyea Paul EN5326DCessna 180A · S/N 50224Hiebert Nathan DN5770MCessna T-310P · S/N 310P0070Built 1968 · Ballard Aviation IncN6237QSchmidt Rollin RANS S-12XL AIRAILE · S/N 01960671Built 1996 · Hiebert Lance AN6543LLife Lawrence D MINI SPORT · S/N LDL001Life Laurence DN699ALBeech B100 · S/N BE-83Built 1980 · Ballard Aviation IncN7048XCessna 150A · S/N 15059148Built 1961 · Gartner Thomas MN70MDFlight Design CTLS · S/N F-11-04-12Built 2011 · Westfall GeorgeN72460Cessna 140 · S/N 9625Built 1946 · Harms Dakota JN72744Cessna 140 · S/N 9923Built 1946 · Hiebert Nathan DN7668XCessna 172B · S/N 17248168Built 1960 · Ekerberg Mark JN769XXBeech F33A · S/N CE-885Built 1980 · Ballard Aviation IncN818WDAmerican Champion 8KCAB · S/N 856-2000Built 2000 · Whiskey Bravo II LLCN86048Life Lawrence D HIPPS RELIANT · S/N 62050ALife Lawrence DN86052Life Lawrence D SKY RAIDER · S/N SR 179Built 2007 · Life Lawrence DN8705CPiper PA-22 · S/N 22-1363Built 1953 · Moore Gary WN9130EAeronca 11AC · S/N 11AC-763Built 1946 · Dufriend James M IIIN922ALBeech B200 · S/N BB1529Ballard Aviation IncN924DRJeff Roach RANS S-20 · S/N 11180085Roach Jeffrey DeanN94357Engineering & Research 415-C · S/N 1580Built 1946 · Ratzlaff James PN976ALSikorsky S-76B · S/N 760439Ballard Aviation Inc
Back to Newton, KS