OpenAirDocs.org
Kingsport, TN

Registered aircraft · 34

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 = 'TN' AND g.registrant_city = 'KINGSPORT'
  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.

N100JDCessna 414A · S/N 414A0669Built 1981 · Mark Aviation LLCN1258QPiper PA 46-350P · S/N 4636191Built 1999 · Siner John RN1514GFirefly Balloons FIREFLY 8B-15 · S/N F8B-2024Built 2002 · Compton Preston WN224DACirrus Design SR22 · S/N 2988Built 2008 · Airalley LLCN22PGCastrillo Ivan F KITFOX · S/N KA13265273Built 2022 · Austin Daniel ClarkeN2396BBlack Christopher RELIANT · S/N 62072Built 2000 · Oreilly Andre MN252CSCarter Raymond C JR VANS RV-7A · S/N 70674Stock Cory WN2618MPiper PA-34-200T · S/N 34-7870089Built 1977 · Soltis Stephen TN29098Piper PA-28-181 · S/N 28-7990436Built 1979 · Gill Stuart W JrN3321FCessna 182J · S/N 18257321Built 1966 · Owl Aviation LLCN338BSSlagle John W RV8-A · S/N 80310Built 2002 · Mcnabb William BN342GZEurocopter GAZELLE SA342M · S/N 4055Black Ops Asphalt LLCN401VTBalony Kubicek Spol S R O BB30ED · S/N 1509Built 2019 · Fortney Wayne DN417LFCessna 182P · S/N 18264714Built 1976 · Russell Tommy EdwardN420PPike Richard W KOLB TWINSTAR MK III · S/N M3-215Built 1996 · Pike Richard WN4373TPiper PA-28-180 · S/N E-13Built 1972 · Michelli Charles WayneN46435Cessna 172K · S/N 17257266Built 1968 · Hawkins County Sports Wings IncN494ECGulfstream Aerospace GIV-X (G450) · S/N 4226Built 2011 · Eastman Chemical CoN518WMMintz James W HUMMEL ULTRACRUISER · S/N 000245Built 2005 · Mintz James WN544SARobinson Helicopter R44 II · S/N 11145Built 2006 · Black Ops Asphalt LLCN550CDCirrus Design SR22 · S/N 1124Built 2004 · Coen Scott DN6015LGrumman American Avn. AA-5 · S/N AA5-0115Built 1972 · Wade Rolla RN6624FCessna 150F · S/N 15063224Built 1966 · Jackson Jeffrey GN735BRCessna 182Q · S/N 18265299Built 1977 · Cooper Kevin JN7590SCessna 182Q · S/N 18265239Built 1976 · Moody Gene MN76PJYoung Glenn P COZY · S/N 92Built 1991 · Mcentire CleatisN78MHHathaway Michael T VANS RV-14A · S/N 140897Built 2022 · Hathaway Michael TN793TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 2414USABuilt 1994 · Fortney WayneN863SBeech V35A · S/N D-8922Built 1969 · Testerman George M MdN86PGMooney M20E · S/N 21-0013Built 1971 · Jackson Jeffrey GN90321Globe GC-1B · S/N 335Built 1946 · Jackson Virgil GeneN9084CAeronca 7BCM · S/N 7BCM-62Duncan Jeremy DN920JCTrabold Jeffrey G RV-6 · S/N 21684Built 2013 · Trabold Jeffrey GN9298DPiper PA-32R-301T · S/N 3257002Built 1997 · Aims Air LLC
Back to Kingsport, TN