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.
N131DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50050N131EVBombardier CL-600-2D24 · S/N 15217N132DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50051N132EVBombardier CL-600-2D24 · S/N 15219N132TDCirrus Design SR22T · S/N 10896N133DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50052N133EVBombardier CL-600-2D24 · S/N 15222N133LLBRM Aero S R O BRISTELL LSA · S/N 384/2019N133PEPilatus PC-12/47E · S/N 1018N134DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50053N134EVBombardier CL-600-2D24 · S/N 15223N1356SCessna 182P · S/N 18264919N135DQAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50054N135EVBombardier CL-600-2D24 · S/N 15225N136DQAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50055N136EVBombardier CL-600-2D24 · S/N 15226N137DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50056N137EVBombardier CL-600-2D24 · S/N 15227N138BAIcon A5 · S/N 00055N138DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50057N138EVBombardier CL-600-2D24 · S/N 15235N139DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50058N140DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50059N140SBPiper PA-28-140 · S/N 28-25681N141DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50061N142DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50060N143DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50063N143FSJonker Sailplanes JS3 RES · S/N 03-143N143KBeech S35 · S/N D-7664N144CNPiper PA-23-250 · S/N 27-8054036N144DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50064N144XXAero Vodochody L39C · S/N 530619N14572Stinson SR-5A · S/N 9308-AN145DQAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50065N145MGGulfstream Aerospace GV-SP (G550) · S/N 5004N146PQBombardier CL-600-2D24 · S/N 15146N147PQBombardier CL-600-2D24 · S/N 15147N14956Ryan Aeronautical ST-A · S/N 112N1498LBeech A23 · S/N M-898N1516MBeech A36 · S/N E-2459N153PQBombardier CL-600-2D24 · S/N 15153N1561GBeech A36 · S/N E-2854N1566WBeech 58 · S/N TH-1713N156JBLancair LC-40-550FG · S/N 40019N157NSBombardier CL-600-2B16 · S/N 5859N158NSEmbraer S A EMB-545 · S/N 55010056N159NSEmbraer S A EMB-545 · S/N 55010062N15RACessna 172L · S/N 17259568N1602Boeing 767-332 · S/N 29694N1603Boeing 767-332 · S/N 29695
Back to Atlanta, GA