Atlanta, GA
Registered aircraft · 1,591
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 = 'ATLANTA' 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 = 'ATLANTA' 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.
N2247TCessna 182T · S/N 18281934N224JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000209N225JQEmbraer ERJ 170-200 LR · S/N 17000210N226JQEmbraer ERJ 170-200 LR · S/N 17000213N227JQEmbraer ERJ 170-200 LR · S/N 17000214N228JQEmbraer ERJ 170-200 LR · S/N 17000218N228PQBombardier CL-600-2D24 · S/N 15228N228SFScheibe SF-28A TANDEM-FALKE · S/N 57103N229GTScion Uas SA-210 WEASEL · S/N 002N229JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000219N22QHHermeus QUARTERHORSE MK 2.2 · S/N 10003N230JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000221N2317VRaytheon A36 · S/N E-3164N231DWMooney M20K · S/N 25-0144N231JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000222N232JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000225N232PQBombardier CL-600-2D24 · S/N 15232N233JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000226N234JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000229N234USBeech D35 · S/N D-3678N235JQEmbraer ERJ 170-200 LR · S/N 17000233N236JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000236N2378TPiper PA-28-140 · S/N 28-7225059N237JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000238N2384YCessna 177 · S/N 17700184N238JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000239N238ZABalloon Works FIREFLY 8B-15 · S/N F8B-552N239JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000244N23BMPiper PA-24 · S/N 24-1118N23DQGulfstream Aerospace GV-SP · S/N 5148N23LPCirrus Design SR22T · S/N 2077N23QHHermeus QUARTERHORSE MK 2.3 · S/N 10004N240JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000245N241EBLancair LC42-550FG · S/N 42065N241JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000246N24206Aeronca 65-LA · S/N L-6709N242JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000252N243JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000253N244JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000256N245JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000259N24665Beech A24R · S/N MC-147N246JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000262N246KAmerican Champion 8KCAB · S/N 658-91N247ABCirrus Design SR22T · S/N 2029N24ATCirrus Design SR22 · S/N 4768N24NRBell Helicopter Textron Canada 407 · S/N 54312N250KCGulfstream Aerospace G-IV · S/N 1025N252DMooney M20K · S/N 25-1014N253LACanadair CL-600-2B16 · S/N 5037N255RCCessna 560XL · S/N 560-5554
Back to Atlanta, GA