Atlanta, GA
Registered aircraft · 1,590
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.
N101CWCessna 177RG · S/N 177RG0290N101DQAirbus A321-211 · S/N 9409N102DABoeing 767-232 · S/N 22214N102DNAirbus A321-211 · S/N 9485N103AVPiper PA-28-181 · S/N 28-8390084N103DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50022N103TWTroy Woodland SOLO 103 · S/N 0001N1040CBombardier BD-700-2A12 · S/N 70243N10460Stinson L-5E · S/N 44-03957N104DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50023N106TNMooney M20TN · S/N 31-0106N1080HPiper PA-28-151 · S/N 28-7715306N108DNAirbus A321-211 · S/N 10003N109DNAirbus A321-211 · S/N 9588N110DXAirbus A321-211 · S/N 10015N111DCAirbus A321-211 · S/N 10018N111KXLaurie Kip KOLB FIRESTAR II · S/N FS-705N111YXLaurie Kip D WAIEX · S/N W0082N112DNAirbus A321-211 · S/N 10085N113DXAirbus A321-211 · S/N 10100N114DNAirbus A321-211 · S/N 10122N114SNIsrael Aircraft Industries ASTRA SPX · S/N 114N115DNAirbus A321-211 · S/N 10132N115WFCompagnie Daher TBM 700 · S/N 1425N116DNAirbus A321-211 · S/N 10121N116DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50035N117DXAirbus A321-211 · S/N 10133N1184NCessna T182T · S/N T18208696N118DYAirbus A321-211 · S/N 10140N118MTCanadair CL-600-2B16 · S/N 5077N119DNAirbus A321-211 · S/N 10182N11CAPiper PA-28-181 · S/N 28-8190077N1200KBoeing 767-332 · S/N 28457N1201PBoeing 767-332 · S/N 28458N120DNAirbus A321-211 · S/N 10185N121DZAirbus A321-211 · S/N 10233N122DNAirbus A321-211 · S/N 10183N12329Curtiss Wright TRAVEL AIR A-14-D · S/N 2009N123DWAirbus A321-211 · S/N 10234N124DXAirbus A321-211 · S/N 10251N125DNAirbus A321-211 · S/N 10252N125SBBritish Aerospace BAE 125 SERIES 800A · S/N 258046N126DNAirbus A321-211 · S/N 10297N127DNAirbus A321-211 · S/N 10236N128DNAirbus A321-211 · S/N 10300N129DNAirbus A321-211 · S/N 10315N129DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50048N129GTGeorgia Institute Of Tech AIRBOOK2 · S/N 002N12JWBell 206-L4 · S/N 52193N130DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50049
Back to Atlanta, GA