OpenAirDocs.org
Greeneville, TN

Registered aircraft · 46

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

N10719Mooney M20J · S/N 24-3141Built 1990 · Florida Independent Truck Repair IncN1121XPiper PA-28-151 · S/N 28-7515316Built 1975 · Crosscheck Ftc LLCN112MRVashon RANGER R7 · S/N 10155Built 2020 · Wooten Freddy LN12HEErwin Randall RV-9A · S/N 91367Built 2007 · Olafsen George FN1426FCessna 172H · S/N 17254921Built 1966 · Miller John T IIIN14661Beech C35 · S/N D-2978Badenhope John RN1595WBeech 95-B55 (T42A) · S/N TC-1448Hope John WN16DPPiper PA-24-250 · S/N 24-3024Ndmi IncN1PUHawker Beechcraft HAWKER 900XP · S/N HA-0201Built 2011 · Smn Investments IncN22276Cessna 150H · S/N 15068185Built 1968 · Ramsey Lenny JN2260GCessna 182B · S/N 51560Built 1958 · Jump Tn LLCN251VWDJI AGRAS T40 · S/N 64TBL7D0020031Woodlawn Farms LLCN275MGulfstream Aerospace GIV-X (G450) · S/N 4048Built 2006 · Skyknight LLCN3040FCessna 182J · S/N 18257140Built 1966 · Jump Tn LLCN3075PRaytheon 58 · S/N TH1887Built 1999 · Wjs IncN32SRSchauss Richard D PITTS S-2 · S/N RDS-01Built 1983 · Badenhope John RN3647LCessna 172G · S/N 17253816Built 1965 · Emmett Kerry NN404LRRaytheon 400A · S/N RK-339Skyknight LLCN421EMCessna 421C · S/N 421C1037Dinger R ScottN422LSCessna 172S · S/N 172S11117Built 2011 · Skyknight LLCN480TBeech 35-A33 · S/N CD-301Built 1961 · Jeffers Mortuary IncN5098SPiper PA-28R-200 · S/N 28R-7135097Badenhope John RN517HHEavision EA-J150 · S/N JMZKJ150UAV602595179Heritage & Habitat LLCN618JMCessna 172S · S/N 172S11164Built 2012 · Skyknight LLCN634FTAmerican General Acft AG5B · S/N 10048Built 1991 · New Life Aviation LLCN63847Fairchild M-62A · S/N T40-404Built 1941 · Niswonger Foundation IncN651PATextron 172S · S/N 172S12016Built 2017 · Smn Investments IncN652PATextron 172S · S/N 172S12017Built 2017 · Smn Investments IncN6786JPiper PA-28-140 · S/N 28-24514Built 1968 · Hope John WN7018VMooney M20F · S/N 22-1370Built 1976 · Hausser Joel SN7130FCessna 150F · S/N 15063730Ricker Gary LN72400Galdieri Paul GLASAIR IIS-RG · S/N 2031Built 1999 · Brown MichaelN7969QCessna 401B · S/N 401B0109Badenhope John RN7979SDJI PHANTOM 4 · S/N 07DDD4U0A10034Cowles StewartN799ARLouis J Wither AMF-S14W-F · S/N F-1084Wither Louis JN82868Aeronca 7AC · S/N 7AC-1518Built 1946 · Olafsen George FN830UCDJI PHANTOM 4 PRO+ · S/N OAXCE480B31409Cowles StewartN8713WPiper PA-28-235 · S/N 28-10247Tree Star Aviation LLCN8750EPiper PA-28-181 · S/N 28-7690197Built 1976 · Crosscheck Ftc LLCN8854VBellanca 17-30A · S/N 30380Built 1971 · Badenhope John RN8873UCessna 172F · S/N 17252789Built 1965 · Olafsen George FN9088EMaule M-5-235C · S/N 7092CBuilt 1977 · Brink Kirk HN9254VMooney M20C · S/N 690066Leyden Jar LLCN94660Cessna 182Q · S/N 18266480Built 1978 · Tweed Bradley StevenN95217Piper PA-28-140 · S/N 28-25844Laight KevinN984THDouglas Hiram P SA-300 · S/N 2002Badenhope John R
Back to Greeneville, TN