OpenAirDocs.org
Knoxville, TN

Registered aircraft · 385

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

N100UADJI MAVIC 3 ENTERPRISE · S/N 1581F5FH723A1002R1K1Crutchfield JamesN100UTTellus Agronomics AGRIEYE · S/N 111415University Of Tennessee Institute Of AgricultureN10302Aeronca C-2 · S/N A-68Schutze Curt KN103DMCirrus Design SF50 · S/N 0247Built 2021 · Ascend Services LLCN1048CBellanca 7GCAA · S/N 1153-76Built 1976 · Palmer GretchenN104BLOneil Willian Jerome ONEIL PITTS · S/N WJO-1Built 1993 · Spiva BrettN10764Mooney M20J · S/N 24-3155Built 1990 · Tennessee Technical Writers LLCN1077UMooney M20J · S/N 24-1693-14Built 1990 · Tenney RomaineN11124DJI AGRAS T30 · S/N 527BJ8Q0010015New Horizon Precision LLCN111UADJI MAVIC AIR 2 · S/N 3N33J4E002K108Crutchfield James AN1128QPiper PA-28R-201 · S/N 28R-7737027Built 1977 · Zastrow Andrew SN113JBPiper PA-23-250 · S/N 27-226Built 1960 · Mcdonald Aviation IncN115ANDassault FALCON 2000EX · S/N 339Built 2017 · Dornoch Leasing LLCN115SGAmerican Champion 7GCBC · S/N 1316-2001Built 2001 · Aileron Aviation LLCN1188CRobinson Samuel C RV-10 · S/N 40088Built 2011 · Robinson Samuel CN118MSRice Mark V RV-8 · S/N 1819Built 2001 · Gunter Donald D DBAN11DZCessna 182H · S/N 18256245Built 1965 · Lowe JacobN11VKBeech 95-A55 · S/N TC-200Built 1961 · Hoskins Terry Wayne IIN1236Piper PA-30 · S/N 30-1167Entwistle Brian VN123BZApogee Capital TL SPARKER · S/N 26SP12Apogee Capital LLCN124SFCirrus Design SR22 · S/N 4621Built 2018 · Cirrus Design CorpN1299Ercoupe 415-E · S/N 4590Grater Timothy FN131KGTextron B300 · S/N FL-1131Built 2018 · Ka131kg LLCN1379CCirrus Design SR22 · S/N 054179 Charlie LLCN1386ECessna 182R · S/N 18268176Built 1982 · Witsoe KathleenN1414HAeronca 15AC · S/N 15AC470Sardella JeffN142DCirrus Design SR22 · S/N 4587Built 2017 · Cirrus Design CorpN1432CCirrus Design SR20 · S/N 1332Built 2003 · Knoxville Flyers IncN1454GBeech P35 · S/N D-6914Built 1962 · N1454g LLCN1471UCessna 172M · S/N 17267138East Tenn Pilots Club IncN147SFGulfstream Aerospace GV-SP (G550) · S/N 5017Built 2003 · As Aviation III LLCN1499LBeech A23 · S/N M-899First renewal noticeBuilt 1966 · Hicks Philip R JrN150ARCessna 150J · S/N 15070693Berry Norman RN1512WBeech V35B · S/N D-9332Built 1972 · Bryant John MarkN1547ZBeech 35-B33 · S/N CD-423Built 1961 · Downing Darren JN157CMPiper PA-32R-300 · S/N 32R-7680023Built 1975 · Chamark LLCN161PSAviat PITTS S-2B · S/N 5339Built 1996 · Bond Robert EN162FAJenkins Clell D EXEC 162 F · S/N 6347Built 2001 · Jenkins Clell Denzel Jr TrusteeN16313Piper PA-28-235 · S/N 28-7310085Built 1973 · Sanders Christopher ScottN16442Firefly Balloons FIREFLY 7B-15 · S/N F7B-2016Rainwater AnthonyN1651FCessna 172H · S/N 17255046Murphey Julian RN169JWCessna 177 · S/N 17700360Built 1968 · Patterson Matthew DN16CTBeech F33A · S/N CE-843Old Boys Aviation LLCN170KMCessna 170A · S/N 19166Built 1949 · Marlow Properties LLC - Marlow Aviation LLC SeriesN1721BGeorge W Job RV-8 · S/N 83336Built 2018 · Job George WN172NCessna 172N · S/N 17270403Built 1978 · East Tennessee Pilots ClubN17655Beech B-55 · S/N TC-2058Built 1977 · Gray Stone Associates IncN176CABoeing 757-28A · S/N 24543Built 1990 · Cascade Spares IncN176STBeech A36 · S/N E-884Built 1976 · Cp A36 IncN179GErcoupe 415-C · S/N 1802Built 1946 · Anderson John P
Back to Knoxville, TN