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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1608YCessna 172C · S/N 17249308N1631DAlan K Davis SLING TSI · S/N 243SKN16HWHodges John P JR SKYBOLT · S/N 1N183RBeech H35 · S/N D-5155N20648Cessna 172M · S/N 17261460N21904Cessna 150L · S/N 15074525N2361NPiper PA-38-112 · S/N 38-79A0807N2554APiper PA-22-135 · S/N 22-850N25LLSmith AEROSTAR 601P · S/N 61P-0295-073N29667Cessna 177 · S/N 17701016N32WHBeech A36 · S/N E-1184N3462ZPiper PA-22-160 · S/N 22-7384N4051CCessna 340A · S/N 340A0995N44MPBeech D55 · S/N TE-760N4541AGrumman American Avn. AA-5B · S/N AA5B1317N4559MBeech A36 · S/N E-1235N469RAPiper PA-38-112 · S/N 38-78A0531N4875JBeech 35-C33A · S/N CE-124N48TFLuscombe T-8F · S/N 6274N497LPPipistrel D O O ALPHA TRAINER · S/N 1184 AT 912 LSARegistration pendingN506CJPiper PA-28RT-201 · S/N 28R-8018028N525BSCoates Kraig RV-8A · S/N 81342N589YBeech 58 · S/N TH-852N613ECottle PITTS S-1C · S/N CRC-3N6220GCessna 150K · S/N 15071720N64LZCorreia Joseph M LONG EZ (RUTAN) · S/N 1034N65772Cessna 172P · S/N 17275875N6822ACessna 172 · S/N 28922N7410YPiper PA-30 · S/N 30-472N79079Cessna 172K · S/N 17257867N7921MBeech V35 · S/N D-8251N818XNDavid Hart PITTS S1-S · S/N DH818N83EZCarmack Robert E VARIEZE · S/N 959N901HLN419cm VANS RV10 · S/N 41948N9169FHinds Clark E PRUE SUPER STD · S/N CH001First renewal notice
Back to Bartlett, TN