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.

N481DNMcdonnell Douglas DC-9-82(MD-82) · S/N 53315Cancelled Aug 4, 2014 · Delta Air Lines IncN459BCMcdonnell Douglas MD-90-30 · S/N 53570Cancelled Jul 24, 2014 · Delta Air Lines IncN483DNMcdonnell Douglas DC-9-82 · S/N 49382Cancelled Jul 24, 2014 · Delta Air Lines IncN484DNMcdonnell Douglas DC-9-82 · S/N 49999Cancelled Jul 24, 2014 · Delta Air Lines IncN485DNMcdonnell Douglas DC-9-82(MD-82) · S/N 49380Cancelled Jul 24, 2014 · Delta Air Lines IncN486DNMcdonnell Douglas DC-9-82(MD-82) · S/N 53001Cancelled Jul 24, 2014 · Delta Air Lines IncN487DNMcdonnell Douglas DC-9-82 · S/N 53002Cancelled Jul 24, 2014 · Delta Air Lines IncN488DNMcdonnell Douglas DC-9-82(MD-82) · S/N 53000Cancelled Jul 23, 2014 · Delta Air Lines IncN496DNMcdonnell Douglas DC-9-82 · S/N 49603Cancelled Jul 23, 2014 · Delta Air Lines IncN368PDHughes OH-6A · S/N 1180900Cancelled Jul 8, 2014 · First renewal notice · Built 1967 · Atlanta Police DepartmentN764NCMcdonnell Douglas DC-9-51 · S/N 47717Cancelled Jun 17, 2014 · Built 1976 · Delta Air Lines IncN766NCMcdonnell Douglas DC-9-51 · S/N 47739Cancelled Jun 17, 2014 · Built 1977 · Delta Air Lines IncN770NCMcdonnell Douglas DC-9-51 · S/N 47758Cancelled Jun 17, 2014 · Built 1978 · Delta Air Lines IncN773NCMcdonnell Douglas DC-9-51 · S/N 47775Cancelled Jun 17, 2014 · Built 1978 · Delta Air Lines IncN775NCMcdonnell Douglas DC-9-51 · S/N 47785Cancelled Jun 17, 2014 · Built 1979 · Delta Air Lines IncN780NCMcdonnell Douglas DC-9-51 · S/N 48102Cancelled Jun 17, 2014 · Built 1979 · Delta Air Lines IncN784NCMcdonnell Douglas DC-9-51 · S/N 48109Cancelled Jun 17, 2014 · Built 1980 · Delta Air Lines IncN786NCMcdonnell Douglas DC-9-51 · S/N 48148Cancelled Jun 17, 2014 · Built 1980 · Delta Air Lines IncN787NCMcdonnell Douglas DC-9-51 · S/N 48149Cancelled Jun 17, 2014 · Built 1980 · Delta Air Lines IncN936CACanadair CL-600-2B19 · S/N 7043Cancelled Apr 28, 2014 · Built 1994 · Delta Air Lines IncN877LXArbc Inc DBA Lindstrand 60X · S/N 5417Cancelled Jan 22, 2014 · Exported to Poland · Built 2008 · Balloonpong Enterprises LLCN1608DMcdonnell Douglas Helicopter 369E · S/N 0434ECancelled Dec 20, 2013 · Built 1990 · Freelance AirN303RBeech D35 · S/N D-3530Cancelled Dec 11, 2013 · Sale reported · Built 1953N1309TDouglas DC-9-31 · S/N 47316Cancelled Nov 19, 2013 · Third renewal notice · Built 1968 · Delta Air Lines IncN3324LDouglas DC-9-32 · S/N 47103Cancelled Nov 19, 2013 · Third renewal notice · Built 1967 · Delta Air Lines IncN8920EDouglas DC-9-31 · S/N 45835Cancelled Nov 19, 2013 · Third renewal notice · Built 1967 · Delta Air Lines IncN8921EDouglas DC-9-31 · S/N 45836Cancelled Nov 19, 2013 · Third renewal notice · Built 1967 · Delta Air Lines IncN8929EDouglas DC-9-31 · S/N 45866Cancelled Nov 19, 2013 · Third renewal notice · Built 1967 · Delta Air Lines IncN8938EDouglas DC-9-31 · S/N 47161Cancelled Nov 19, 2013 · Third renewal notice · Built 1968 · Delta Air Lines IncN89SDouglas DC-9-31 · S/N 47042Cancelled Nov 19, 2013 · Third renewal notice · Built 1969 · Delta Air Lines IncN915RWDouglas DC-9-31 · S/N 47139Cancelled Nov 19, 2013 · Third renewal notice · Built 1967 · Delta Air Lines IncN921RWDouglas DC-9-31 · S/N 47164Cancelled Nov 19, 2013 · Third renewal notice · Built 1968 · Delta Air Lines IncN923RWDouglas DC-9-31 · S/N 47183Cancelled Nov 19, 2013 · Third renewal notice · Built 1968 · Delta Air Lines IncN9332Douglas DC-9-31 · S/N 47264Cancelled Nov 19, 2013 · Third renewal notice · Built 1968 · Delta Air Lines IncN9341Douglas DC-9-31 · S/N 47390Cancelled Nov 19, 2013 · Third renewal notice · Built 1969 · Delta Air Lines IncN9343Douglas DC-9-31 · S/N 47439Cancelled Nov 19, 2013 · Third renewal notice · Built 1969 · Delta Air Lines IncN9344Douglas DC-9-31 · S/N 47440Cancelled Nov 19, 2013 · Third renewal notice · Built 1969 · Delta Air Lines IncN9347Mcdonnell Douglas DC-9-32 · S/N 45827Cancelled Nov 19, 2013 · Third renewal notice · Built 1967 · Delta Air Lines IncN9348Douglas DC9-15 · S/N 45787Cancelled Nov 19, 2013 · Third renewal notice · Built 1967 · Delta Air Lines IncN943NMcdonnell Douglas DC-9-32 · S/N 47647Cancelled Nov 19, 2013 · Third renewal notice · Built 1975 · Delta Air Lines IncN2286DGates Learjet 35A · S/N 482Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1982 · Rhm Trust Bank LtdN377TWScott O V JR WITTMAN TAILWIND W-8 · S/N 103Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Scott O V JrN2012TCessna 172N · S/N 17273550Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Air East Services LLCN9046HAerostar International RAVEN S57-A · S/N S57A-3140Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1992 · Corporate Leasing CorpN22398Aeronca 65-LA · S/N L-3979Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1939 · Garvey Michael DN9071MBalloon Works FIREFLY 7 · S/N F7-638Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Bellsouth Mobility IncN9416MCessna 210M · S/N 21062074Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1977 · Binder TonyN973NAAerospatiale/Aeritalia ATR 42-300 · S/N 065Cancelled Sep 12, 2013 · Registration expired, pending cancellation · International Airline Support Group IncN420ZAZenair CH 2000 · S/N 200042Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1999N67544Cessna 152 · S/N 15281903Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1978
Back to Atlanta, GA