Bartlett, TN

Registered aircraft · 35

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

N1608YCessna 172C · S/N 17249308Built 1962 · Kohr Daniel EN1631DAlan K Davis SLING TSI · S/N 243SKBuilt 2022 · Davis Alan KN16HWHodges John P JR SKYBOLT · S/N 1Built 2001 · Kelley John EN183RBeech H35 · S/N D-5155Built 1957 · Lea Brandon Wayne SrN20648Cessna 172M · S/N 17261460Built 1973 · Jones Farm Fresh LLCN21904Cessna 150L · S/N 15074525Built 1973 · Ragsdale Justin SN2361NPiper PA-38-112 · S/N 38-79A0807Built 1979 · Brewer Philip TN2554APiper PA-22-135 · S/N 22-850Built 1952 · Walker Michael KN25LLSmith AEROSTAR 601P · S/N 61P-0295-073Davies Bryan RN29667Cessna 177 · S/N 17701016Built 1968 · Viles TimothyN32WHBeech A36 · S/N E-1184Built 1977 · Eagle Air Partners LLCN3462ZPiper PA-22-160 · S/N 22-7384Built 1960 · Wilson Anthony JN4051CCessna 340A · S/N 340A0995Built 1980 · Sky High Ventures LLCN44MPBeech D55 · S/N TE-760Built 1969 · Miller Dennis JosephN4541AGrumman American Avn. AA-5B · S/N AA5B1317Built 1979 · Steward David FN4559MBeech A36 · S/N E-1235Sky High Ventures LLCN469RAPiper PA-38-112 · S/N 38-78A0531Built 1978 · Chorice KennethN4875JBeech 35-C33A · S/N CE-124Built 1966 · Beech Bound Aviation LLCN48TFLuscombe T-8F · S/N 6274Built 1948 · Freeman Stephen KN497LPPipistrel D O O ALPHA TRAINER · S/N 1184 AT 912 LSARegistration pendingBuilt 2023N506CJPiper PA-28RT-201 · S/N 28R-8018028Built 1979 · Matthews Joseph RN525BSCoates Kraig RV-8A · S/N 81342Built 2008 · Snapp William BN589YBeech 58 · S/N TH-852Built 1977 · Dennis Aviation LLCN613ECottle PITTS S-1C · S/N CRC-3Built 1984 · Hart David EN6220GCessna 150K · S/N 15071720Built 1970 · Duncan Paul JN64LZCorreia Joseph M LONG EZ (RUTAN) · S/N 1034Built 1996 · Wilson Tony GN65772Cessna 172P · S/N 17275875Built 1982 · Sky Adventure LLCN6822ACessna 172 · S/N 28922Built 1956 · Stewart Brock AllenN7410YPiper PA-30 · S/N 30-472Built 1964 · Duncan Paul JN79079Cessna 172K · S/N 17257867Built 1968 · Jones Farm Fresh LLCN7921MBeech V35 · S/N D-8251Built 1966 · Miller Dennis JN818XNDavid Hart PITTS S1-S · S/N DH818Hart DavidN83EZCarmack Robert E VARIEZE · S/N 959Built 1981 · Kelley John EN901HLN419cm VANS RV10 · S/N 41948Washington LamarN9169FHinds Clark E PRUE SUPER STD · S/N CH001First renewal noticeBuilt 2023 · Hinds Clark E
Back to Bartlett, TN