Williamson, GA
Registered aircraft · 85
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 = 'WILLIAMSON' 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 = 'WILLIAMSON' 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.
N11077Champion 7ECA · S/N 91N1115EChampion 7AC · S/N 7AC-4670N1125BLuscombe 8A · S/N 5752N1163HAeronca 15AC · S/N 15AC-176N1187SSchweizer SGS 2-33A · S/N 237N134XSAeromot AMT-200S · S/N 200.134N1358MBoeing B75N1 · S/N 75-1229N135EXSchweizer SGS 1-35C · S/N 72N139JLLiebman Jeffrey E LIEBMAN RV-8 · S/N 81378N140SKCessna 140 · S/N 12835N1441BLuscombe 8A · S/N 6068N150AKP Z L Koliber 150A · S/N 04940071N162NLLimor Nachshon 162F · S/N 6769N1751GBeech 35-B33 · S/N CD-494N21831Piper J3F-50 · S/N 2608N21YPR Alexander Youth Avn Program SONEX SPORT TRAINER · S/N 1695N220DPAero Commander 200D · S/N 380N224DMMoffett David R RV-4 · S/N 001N245SFAmerican Champion 8KCAB · S/N 880-2001N24MABeech 95-B55 (T42A) · S/N TC-1435N2550FChampion 7ECA · S/N 172N25994Piper J3L-65 · S/N 3952N2745SCessna 150G · S/N 15066645N2867NCessna 140 · S/N 13128N2892FCessna 182J · S/N 18256992N29355Waco UPF-7 · S/N 5382N29788Bellanca 7GCAA · S/N 396-80N32578Piper J5A · S/N 5-339N3407DCessna 170B · S/N 26950N3638WPiper PA-32-260 · S/N 32-540N38559Piper J3C-65 · S/N 7127N3874WPiper PA-32-260 · S/N 32-820N39TSStrub Theodore W HATZ LB1 · S/N 39N405NTravel Air E-4000 · S/N 1336N41242Piper J3C-65 · S/N 8006N415TRWilliams Timothy L HATZ CLASSIC · S/N 1001N42394Piper J3C-65 · S/N 14653N424WMCessna 172N · S/N 17269385N427VKCessna M337B · S/N 337M0133N4394LCessna 172G · S/N 17254475N4410WBoeing A75N1(PT17) · S/N 75-3551N44WKKlink Wallace RV-3 · S/N 11144N46385Cessna 172K · S/N 17257233N52376Cessna 182P · S/N 18262562N53713Bellanca 7GCAA · S/N 531-75N5649CCessna 140A · S/N 15603N57NCessna 120 · S/N 11996N6093MStinson 108-3 · S/N 108-4093N6101VBeech 35-C33 · S/N CD-848N65843Schweizer SGS 2-33A · S/N 333
Back to Williamson, GA