Atlanta, GA

Cancelled registrations · 1,436

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'GA' AND d.registrant_city = 'ATLANTA'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N484AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49677Cancelled Mar 1, 2018 · Built 1988 · Delta Material Services LLCN485AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49678Cancelled Mar 1, 2018 · Built 1988 · Delta Material Services LLCN486AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49679Cancelled Mar 1, 2018 · Built 1988 · Delta Material Services LLCN564AAMcdonnell Douglas DC-9-83(MD-83) · S/N 49346Cancelled Mar 1, 2018 · Built 1987 · Delta Material Services LLCN568AAMcdonnell Douglas DC-9-83(MD-83) · S/N 49349Cancelled Mar 1, 2018 · Built 1987 · Delta Material Services LLCN570AAMcdonnell Douglas DC-9-83(MD-83) · S/N 49352Cancelled Mar 1, 2018 · Built 1987 · Delta Material Services LLCN571AAMcdonnell Douglas DC-9-83(MD-83) · S/N 49353Cancelled Mar 1, 2018 · Built 1987 · Delta Material Services LLCN53JKSmith AEROSTAR 601P · S/N 61P-0303-078Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1976 · Briarcliff Aircraft LLCN518NDArbc Inc DBA Lindstrand 69A · S/N 5180Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 2001 · Balloonpong Enterprises LLCN7579NCessna T210N · S/N 21063238Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Freeman David SN6376AAerostar International RAVEN S57-A · S/N S57A-3132Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1992 · Admax IncN665CDCirrus Design SR22 · S/N 1774Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2006 · Auala LLCN127DLBoeing 767-332 · S/N 24077Cancelled Jan 24, 2018 · Second renewal notice · Built 1988 · Delta Air Lines IncN129DLBoeing 767-332 · S/N 24079Cancelled Jan 24, 2018 · Second renewal notice · Built 1988 · Delta Air Lines IncN136DLBoeing 767-332 · S/N 25146Cancelled Jan 24, 2018 · Second renewal notice · Built 1991 · Delta Air Lines IncN303EVMcdonnell Douglas MD-90 · S/N 53554Cancelled Jan 24, 2018 · Third renewal notice · Delta Air Lines IncN315USAirbus Industrie A320-211 · S/N 171Cancelled Jan 24, 2018 · Built 1991 · Delta Air Lines IncN664USBoeing 747-451 · S/N 23819Cancelled Jan 24, 2018 · Second renewal notice · Built 1989 · Delta Air Lines IncN6PXBinkley Richard 2 PLACE · S/N 566Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 2006 · Noble Morrell EN34243Cessna 177RG · S/N 177RG0987Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1976 · Holderness SidneyN3735PPiper PA-22 · S/N 22-3455Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1955 · Cousar Robert W JrN144DDAerospatiale/Aeritalia ATR 42-300 · S/N 074Cancelled Jan 11, 2018 · Registration expired, pending cancellation · International Airline Support Group IncN323GLBoeing 737-73V · S/N 30242Cancelled Jan 10, 2018 · Delta Material Services LLCN87NFPiper PA-46-310P · S/N 4608099Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1987 · Culbair LLCN3471VCessna 150M · S/N 15076512Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1974 · Versaggi Lauren CadeN467AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49597Cancelled Dec 26, 2017 · Built 1988 · Delta Material Services LLCN479AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49654Cancelled Dec 26, 2017 · Built 1988 · Delta Material Services LLCN569AAMcdonnell Douglas DC-9-83(MD-83) · S/N 49351Cancelled Dec 26, 2017 · Built 1987 · Delta Material Services LLCN883ASBombardier CL-600-2B19 · S/N 7504Cancelled Dec 26, 2017 · Built 2001 · Delta Material Services LLCN519USBoeing 757-251 · S/N 23207Cancelled Nov 3, 2017 · Built 1986 · Delta Air Lines IncN533USBoeing 757-251 · S/N 24264Cancelled Nov 3, 2017 · Built 1988 · Delta Air Lines IncN534USBoeing 757-251 · S/N 24265Cancelled Nov 3, 2017 · Built 1988 · Delta Air Lines IncN757ATBoeing 757-212 · S/N 23127Cancelled Nov 3, 2017 · Built 1984 · Delta Air Lines IncN319KABoeing 747-4B5 · S/N 27177Cancelled Oct 30, 2017 · Delta Material Services LLCN3219ACessna 170B · S/N 25863Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1953 · Scott Luke WN7540YPiper PA-30 · S/N 30-604Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1964 · Mckee YuriN4029JRobinson Helicopter R44 · S/N 2487Cancelled Sep 25, 2017 · Exported to Panama · Rotor Corp LLCN513UABoeing 757-222 · S/N 24810Cancelled Sep 12, 2017 · Built 1990 · Delta Material Services LLCN173DNBoeing 767-332 · S/N 24800Cancelled Sep 6, 2017 · First renewal notice · Built 1990 · Delta Air Lines IncN132DNBoeing 767-332 · S/N 24981Cancelled Aug 17, 2017 · Built 1991 · Delta Air Lines IncN133DNBoeing 767-332 · S/N 24982Cancelled Aug 17, 2017 · Built 1991 · Delta Air Lines IncN134DLBoeing 767-332 · S/N 25123Cancelled Aug 17, 2017 · Built 1991 · Delta Air Lines IncN316KABoeing 747-400 · S/N 27341Cancelled Jul 31, 2017 · Delta Material Services LLCN131DNBoeing 767-332 · S/N 24852Cancelled Jul 21, 2017 · Built 1990 · Delta Air Lines IncN135DLBoeing 767-332 · S/N 25145Cancelled Jul 21, 2017 · Built 1991 · Delta Air Lines IncN516USBoeing 757-251 · S/N 23204Cancelled Jul 21, 2017 · Built 1986 · Delta Air Lines IncN522USBoeing 757-251 · S/N 23616Cancelled Jul 21, 2017 · Built 1987 · Delta Air Lines IncN523USBoeing 757-251 · S/N 23617Cancelled Jul 21, 2017 · Built 1987 · Delta Air Lines IncN526USBoeing 757-251 · S/N 23620Cancelled Jul 21, 2017 · Built 1987 · Delta Air Lines IncN528USBoeing 757-251 · S/N 23843Cancelled Jul 21, 2017 · Built 1987 · Delta Air Lines Inc
Back to Atlanta, GA