Thomasville, GA
Registered aircraft · 59
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 = 'GA' AND g.registrant_city = 'THOMASVILLE' 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 = 'GA' AND g.registrant_city = 'THOMASVILLE' 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.
N1073EBellanca 7ECA · S/N 1209-77N11237Waco RNF · S/N 3439N127JPPiper J3C-65 · S/N 20770N132BUCASA 1.131 · S/N 437N146ECessna 182R · S/N 18268292N1560KLuscombe 8A · S/N 4287N183CACirrus Design SR22T · S/N 11195N19746Cessna 172L · S/N 17260717N229LSCirrus Design SR22T · S/N 11350N2443NCessna 140 · S/N 12696N261TDEclipse Aerospace EA500 · S/N 000261N298AGDJI AGRAS T50 · S/N 63YDL29001JQ0PN301FCCirrus Design SR22 · S/N 9076N311PLuscombe 8A · S/N 1479N3241XMaule MT-7-235 · S/N 18095CN34WPEclipse Aerospace EA500 · S/N 550-1012N350JDHockenberry Glenn Q2 · S/N 2772N3523DPiper PA-31-350 · S/N 31-7952112N3553WPiper PA-32-260 · S/N 32-441N35607Piper J5A · S/N 5-700N401PKAviat A-1A · S/N 1438N420BSHonda HA-420 · S/N 42000256N420XXHonda HA-420 · S/N 42000189N433STPiper PA-32-260 · S/N 32-7100014N4952Curtiss Wright TRAVEL AIR 2000 · S/N 450N50553Piper J3C-65 · S/N 14363N508JPEclipse EA500 · S/N 000071N52619Cessna 177RG · S/N 177RG1216N52PRCirrus Design SR22T · S/N 2396N54319Cessna 172P · S/N 17274954N571AGHonda HA-420 · S/N 42000282N577PEPilatus PC-12/47E · S/N 1577N59735Boeing A75N1(PT17) · S/N 75-2418N6102PPiper PA-24 · S/N 24-1200N626TRCirrus Design SR22 · S/N 2242N6345DCessna 182T · S/N 18281401N68111Flynt SPECIAL · S/N GHF-1N71470Luscombe 8A · S/N 2897N71540Luscombe 8A · S/N 2967N720JMCirrus Design SR22T · S/N 1984N750YPJohn R Clark ZENITH CH-750 · S/N 75-8645N75RATextron 700 · S/N 700-0041N77817Silvaire LUSCOMBE 8A · S/N 3544N77923Luscombe 8A · S/N 3650N77TEEclipse EA500 · S/N 000077N7900CPiper PA-28-181 · S/N 28-7690087N7987KBeech S35 · S/N D-7491N8113YAdams Dale HORNET · S/N 0038N815JJHonda HA-420 · S/N 42000083N81JCChesnut-Jennings VARIEZE · S/N 244
Back to Thomasville, GA