Flowery Branch, GA
Registered aircraft · 30
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 = 'FLOWERY BRANCH' 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 = 'FLOWERY BRANCH' 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.
N1385RGrumman American Avn. AA-5 · S/N AA5-0785N141MAVans RV-12IS · S/N 12194N14229Piper PA-23-250 · S/N 27-4794N216HBCirrus Design SR22T · S/N 10274N22669Cessna 182T · S/N 18281942N2457KLuscombe 8E · S/N 5184N280DAPiper PA-28R-201 · S/N 28R-7737154N2983DCessna 170B · S/N 26926N31BZRich ESQUAL VM-1 · S/N E180070N3661KPiper J3C-65 · S/N 22352N4048MCessna 182R · S/N 182-67993N42692Piper J3C-65 · S/N 14988N4837MSouthern Air-Time MX SUPER · S/N 1010N483AHSchempp Hirth Flugzeugbau VENTUS 2B · S/N 132N5128LPiper PA-28-180 · S/N 28-4411N528VTGame Composites GB1 GAMEBIRD · S/N 0084N54470Piper PA-28-151 · S/N 28-7415069N555RBeech B35 · S/N D-2295N5837ACessna 172 · S/N 28437N6445RPiper PA-28-140 · S/N 28-21628N6549MCessna 182P · S/N 18263749N71318Luscombe 8A · S/N 2745N719GWPiper PA-18-150 · S/N 1809034N7807FCessna 150F · S/N 15063907First renewal noticeN78KCCessna 414A · S/N 414A-0045N80PCCox Paul W BUSHBY MUSTANG II · S/N PC-2Sale reported, canceledN8402MCessna A150K · S/N A1500102N8874TCessna 182C · S/N 52774First renewal noticeN92758Cessna 182N · S/N 18260343N97MVPiper PA 46-350P · S/N 4636023
Back to Flowery Branch, GA