OpenAirDocs.org
Johnson City, TN

Registered aircraft · 63

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

N1039TBeech A36 · S/N E-1059Built 1977 · JeraN1106PYakovlev YAK 52 · S/N 844411Built 1984 · Hopland Steven RN1398RGrumman American Avn. AA-5 · S/N AA5-0798Built 1975 · Hopland Steven RN1941TBeech 35-C33 · S/N CD-958Built 1965 · Erwin Randall LN201TFMooney M20J · S/N 24-0326Bartley Jamie KN2116LBeech V35B · S/N D-9916Built 1976 · Hagg TheodoorN211BKIndus T-211 THORPEDO · S/N 024SBuilt 2006 · Kincaid Janet LN2158NMooney M20R · S/N 29-0167Built 1998 · 2th Aviation LLCN2180FPiper PA-32-300 · S/N 32-7940012Built 1978 · Gentle Breezes LLCN2218KSilvaire LUSCOMBE 8A · S/N 4945Built 1947 · Estaban Granwel GN237EWZall Jihlavan Airplanes S R O JA-600 SKYLEADER · S/N 6309338YBuilt 2019 · Horizon Ventures Limited LLCN23ELRobinson Helicopter R22 BETA · S/N 2363Westerfield Mark HN2435PPiper PA-22-150 · S/N 22-2806Built 1955 · Garst William PN258JPPrice Jeremy W REPLICA PA-18 · S/N 001Garrison Thomas CN260SGJon Staudacher S260G · S/N 35Built 2014 · Esteban Granwel Genio JrN2635VCessna 170 · S/N 18145Laycock Justin DN26UAUrban Air Sro UFM-13 LAMBADA · S/N 121/13Built 2008 · Hopland Steven RN286LDCirrus Design SR22T · S/N 8916Built 2022 · Spectre Aviation Group LLCN28GDDayhoff Guy W S-19 · S/N 030900064Built 2021 · Dayhoff Guy WN2920PPiper PA-22-150 · S/N 22-3188Built 1955 · Erwin RandallN3108KBalloon Works FIREFLY 7-15 · S/N F7-901Kirgiss Randy MN32303Piper PA-32-300 · S/N 32-7540029Built 1974 · Eagle Air Solutions LLCN32361Piper PA-28-140 · S/N 28-7525055Built 1974 · Odom Eric JN345DSCirrus Design SR22T · S/N 1997Built 2019 · Aviation New Generation LLCN366LDCirrus Design SR22 · S/N 4792Built 2019 · Horizon Aviation LLCN3819YCessna 210D · S/N 21058319Built 1964 · Laycock Justin DN38616Piper J3F-65 · S/N 7148Built 1941 · Scott Robert GizzieN4257AMaule M-7-235C · S/N 25083CRemlap Holdings LLCN42MEAms-Flight Doo DG-300 ELAN · S/N 3E493Built 2001 · Peterkin Michael JN43355Piper PA-32-301 · S/N 32-8406004Built 1983 · Calloway Enterprises LLCN44014Piper PA-28-151 · S/N 28-7415568Built 1974 · Carlone Edward JN444DHGulfstream Aerospace GV-SP (G550) · S/N 5084Built 2005 · Hatley Aviation LLCN45693Cessna 150M · S/N 15077022Built 1975 · Wingnut Aviation LLCN46SASwearingen SA-226T · S/N T231Built 1973 · Hopland StevenN47918Piper PA-28-161 · S/N 28-7816158Built 1977 · Hay YotamN4886GCessna 172N · S/N 17273433First renewal noticeBuilt 1979 · Skycrafters IncN4ZLCessna 560 · S/N 560-0448Built 1997 · Flying 5 LlcfN5049CBellanca 8KCAB · S/N 519-79Built 1979 · Innovative Design And Manufacturing LLCN51GNCessna 525 · S/N 525-0317Built 1999 · Powell Construction Company IncN51GSLearjet 45 · S/N 466Built 2013 · General Shale Building Materials IncN5253TPiper PA-28-140 · S/N 28-7225373Hart WilliamN5559FPiper PA-28-140 · S/N 28-24899Built 1968 · Esteban GranwelN5827MCessna 340 · S/N 340-0051Built 1972 · Hopland SteveN611RMCirrus Design SR22 · S/N 1133Built 2004 · Rm Management CorpN613RSCirrus Design SR22T · S/N 10025Built 2024 · Green Trees Aviation LLCN61DTEclipse EA500 · S/N 000192Built 2008 · East Tennessee Aircraft LLCN624CDCirrus Design SR22 · S/N 1119Provincial Properties LLCN64JTAmerican Legend AL18 · S/N AL-1229Built 2019 · Hairetown LLCN72860Cessna 140 · S/N 10051Built 1946 · Woodside NicholasN74145Balloon Works FIREFLY 7 · S/N F7-290First renewal noticeLeonard Michael A
Back to Johnson City, TN