Athens, AL
Registered aircraft · 49
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 = 'AL' AND g.registrant_city = 'ATHENS' 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 = 'AL' AND g.registrant_city = 'ATHENS' 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.
N171GSMaule M-5-180C · S/N 8014CN172KDCessna 172M · S/N 17267467N178CSRobert Saltz SALTZ STARLETT · S/N 001N1933XCessna 182H · S/N 18256033N2012MPiper J3C-65 · S/N 20777N243LCBell OH-58A · S/N 70-15423N244LCBell OH-58C · S/N 71-20802N2715YBeech 95 · S/N TD-62N2935JCessna 150G · S/N 15065735N310WSCessna 310R · S/N 310R0612N316LFFurlong Lou BARRACUDA · S/N 400N3273GDJI AGRAS T50 · S/N 1581F6BUB234F00101UDN35601Piper J5A · S/N 5-694N363GMMccormick Gregory W FLY BABY 1A · S/N 5542N367LSCulp J Stephen CULPS SPECIAL · S/N 001N3971YCessna 210D · S/N 21058471N399SBBuchanan Sam C RV6 · S/N 25241N40679Piper PA-28R-201 · S/N 28R-7737132N41567Piper J3C-65 · S/N 9047N46581Cessna 172K · S/N 17257366N46899Aeronca 0-58B · S/N 058B-4502N47093Interstate/Smith L6 S1B1 · S/N 2N475FDEa Vision EA J100 · S/N EAVUAV502485313N4JGPiper PA-28-180 · S/N 28-7205281N5404RCessna 172F · S/N 17252942N5442FPiper PA-32R-300 · S/N 32R-7780010N552ADEavision EA-J150 · S/N JMZKJ150UAV602595194N5664YMaule M-7-235 · S/N 4033CN579RVDavid Scott Millhouse RV-7A · S/N 72347N593DPEavision EA-J150 · S/N JMZKJ150UAV602595248N6057TCessna 150D · S/N 15060757N6321GCessna 150K · S/N 15071821N6904SCessna 150H · S/N 15067604N6906KPiper PA-20 · S/N 20-9N7067YPiper PA-30 · S/N 30-80N714YWCessna 152 · S/N 15279547N8025FCessna 150F · S/N 15064125N8321RPiper PA-28-140 · S/N 2822192N88ABCessna 172M · S/N 17262739N903RMCirrus Design SR22 · S/N 0903N9124UCessna 150M · S/N 15078075N91SMCirrus Design SR22T · S/N 0644N9282SBeech C23 · S/N M-1624N94TWExtra Flugzeugbau EA 300/L · S/N 049N9570YBeech 35-B33 · S/N CD-570N95HWVans RV-12 · S/N 120191N9665FHughes 269C · S/N 110088N9690UGrumman American Avn. AA-5A · S/N AA5A-0056N9915Travel Air 4-D · S/N 1102
Back to Athens, AL