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.

N2247TCessna 182T · S/N 18281934Built 2007 · Yellow Jacket Flying Club IncN224JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000209Built 2008 · Delta Air Lines IncN225JQEmbraer ERJ 170-200 LR · S/N 17000210Built 2008 · Delta Air Lines IncN226JQEmbraer ERJ 170-200 LR · S/N 17000213Built 2008 · Delta Air Lines IncN227JQEmbraer ERJ 170-200 LR · S/N 17000214Built 2008 · Delta Air Lines IncN228JQEmbraer ERJ 170-200 LR · S/N 17000218Built 2008 · Delta Air Lines IncN228PQBombardier CL-600-2D24 · S/N 15228Built 2009 · Delta Air Lines IncN228SFScheibe SF-28A TANDEM-FALKE · S/N 57103Built 1979 · Johnson Marc DN229GTScion Uas SA-210 WEASEL · S/N 002Georgia Institute Of TechnologyN229JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000219Built 2008 · Delta Air Lines IncN22QHHermeus QUARTERHORSE MK 2.2 · S/N 10003Hermeus CorpN230JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000221Built 2008 · Delta Air Lines IncN2317VRaytheon A36 · S/N E-3164Built 1998 · May-Collier Aviation LLCN231DWMooney M20K · S/N 25-0144Built 1979 · Glickson Alan SN231JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000222Built 2008 · Delta Air Lines IncN232JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000225Built 2008 · Delta Air Lines IncN232PQBombardier CL-600-2D24 · S/N 15232Built 2009 · Delta Air Lines IncN233JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000226Built 2008 · Delta Air Lines IncN234JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000229Built 2008 · Delta Air Lines IncN234USBeech D35 · S/N D-3678Built 1953 · Long Camille DN235JQEmbraer ERJ 170-200 LR · S/N 17000233Built 2008 · Delta Air Lines IncN236JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000236Built 2008 · Delta Air Lines IncN2378TPiper PA-28-140 · S/N 28-7225059Built 1971 · Keiffer Taylor HN237JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000238Built 2008 · Delta Air Lines IncN2384YCessna 177 · S/N 17700184Area-I Flying Club LLCN238JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000239Built 2008 · Delta Air Lines IncN238ZABalloon Works FIREFLY 8B-15 · S/N F8B-552Built 1998 · Suskin DanN239JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000244Built 2008 · Delta Air Lines IncN23BMPiper PA-24 · S/N 24-1118Built 1959 · Axiom Development And Consulting LLCN23DQGulfstream Aerospace GV-SP · S/N 5148Built 2007 · Jfb3 LLCN23LPCirrus Design SR22T · S/N 2077Built 2020 · Volamus LLCN23QHHermeus QUARTERHORSE MK 2.3 · S/N 10004Hermeus CorpN240JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000245Built 2008 · Delta Air Lines IncN241EBLancair LC42-550FG · S/N 42065Built 2005 · Usd Flyers IncN241JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000246Built 2008 · Delta Air Lines IncN24206Aeronca 65-LA · S/N L-6709Fike William EN242JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000252Built 2008 · Delta Air Lines IncN243JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000253Built 2008 · Delta Air Lines IncN244JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000256Built 2008 · Delta Air Lines IncN245JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000259Built 2008 · Delta Air Lines IncN24665Beech A24R · S/N MC-147Axiom Development & Consulting LLCN246JQEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000262Built 2008 · Delta Air Lines IncN246KAmerican Champion 8KCAB · S/N 658-91Built 1991 · Keeton James HN247ABCirrus Design SR22T · S/N 2029Built 2019 · Flight Insite LLCN24ATCirrus Design SR22 · S/N 4768Built 2019 · Bobwhite Aviation LLCN24NRBell Helicopter Textron Canada 407 · S/N 54312Built 2012 · Georgia Department Of Natural ResourcesN250KCGulfstream Aerospace G-IV · S/N 1025Built 1987 · Flight 444 LLCN252DMooney M20K · S/N 25-1014Built 1986 · 252 Delta IncN253LACanadair CL-600-2B16 · S/N 5037One World Aviation 253 LLCN255RCCessna 560XL · S/N 560-5554255rc LLC
Back to Atlanta, GA