OpenAirDocs.org
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.

N908DLMcdonnell Douglas MD-88 · S/N 49539Cancelled Nov 29, 2022 · Built 1987 · Delta Air Lines IncN912DNMcdonnell Douglas MD-90-30 · S/N 53392Cancelled Nov 29, 2022 · Built 1996 · Delta Air Lines IncN913DNMcdonnell Douglas MD-90-30 · S/N 53393Cancelled Nov 29, 2022 · Built 1996 · Delta Air Lines IncN917DNMcdonnell Douglas MD-90-30 · S/N 53552Cancelled Nov 29, 2022 · Built 1996 · Delta Air Lines IncN919DNMcdonnell Douglas MD-90-30 · S/N 53576Cancelled Nov 29, 2022 · Built 1997 · Delta Air Lines IncN920DEMcdonnell Douglas MD-88 · S/N 53423Cancelled Nov 29, 2022 · Built 1993 · Delta Air Lines IncN922DXMcdonnell Douglas MD-90-30 · S/N 53584Cancelled Nov 29, 2022 · First renewal notice · Delta Air Lines IncN923DNBoeing MD-90-30 · S/N 53585Cancelled Nov 29, 2022 · Delta Air Lines IncN924DNBoeing MD-90-30 · S/N 53586Cancelled Nov 29, 2022 · Delta Air Lines IncN925DNBoeing MD-90-30 · S/N 53587Cancelled Nov 29, 2022 · Delta Air LinesN934DNMcdonnell Douglas MD-90-30 · S/N 53462Cancelled Nov 29, 2022 · Built 1996 · Delta Air Lines IncN935DNMcdonnell Douglas MD-90-30 · S/N 53460Cancelled Nov 29, 2022 · Built 1996 · Delta Air Lines IncN942DNMcdonnell Douglas MD-90-30 · S/N 53556Cancelled Nov 29, 2022 · Built 1997 · Delta Air Lines IncN963DLMcdonnell Douglas MD-88 · S/N 49982Cancelled Nov 29, 2022 · Built 1990 · Delta Air Lines IncN967DLMcdonnell Douglas MD-88 · S/N 53116Cancelled Nov 29, 2022 · Built 1990 · Delta Air Lines IncN968DLMcdonnell Douglas MD-88 · S/N 53161Cancelled Nov 29, 2022 · First renewal notice · Built 1990 · Delta Air Lines IncN991DLMcdonnell Douglas MD-88 · S/N 53343Cancelled Nov 29, 2022 · Built 1991 · Delta Air Lines IncN998DLMcdonnell Douglas MD-88 · S/N 53370Cancelled Nov 29, 2022 · First renewal notice · Built 1992 · Delta Air Lines IncN999DNMcdonnell Douglas MD-88 · S/N 53371Cancelled Nov 29, 2022 · First renewal notice · Built 1992 · Delta Air Lines IncN910DEMcdonnell Douglas MD-88 · S/N 53419Cancelled Nov 23, 2022 · Built 1992 · Delta Air Lines IncN960DLMcdonnell Douglas MD-88 · S/N 49979Cancelled Nov 23, 2022 · Built 1990 · Delta Air Lines IncN908DEMcdonnell Douglas MD-88 · S/N 53417Cancelled Nov 8, 2022 · Built 1992 · Delta Air Lines IncN909DEMcdonnell Douglas MD-88 · S/N 53418Cancelled Nov 8, 2022 · Built 1992 · Delta Air Lines IncN916DNMcdonnell Douglas MD-90-30 · S/N 53396Cancelled Oct 26, 2022 · First renewal notice · Built 1996 · Delta Air Lines IncN920DNMcdonnell Douglas MD-90-30 · S/N 53582Cancelled Oct 26, 2022 · First renewal notice · Delta Air Lines IncN995DLMcdonnell Douglas MD-88 · S/N 53362Cancelled Oct 26, 2022 · First renewal notice · Built 1991 · Delta Air Lines IncN922DLMcdonnell Douglas MD-88 · S/N 49646Cancelled Sep 20, 2022 · Built 1988 · Delta Air Lines IncN926DHBoeing MD-90-30 · S/N 53588Cancelled Sep 20, 2022 · Delta Air Lines IncN951DNMcdonnell Douglas MD-90-30 · S/N 53361Cancelled Sep 20, 2022 · Built 1997 · Delta Air Lines IncN27GBPiper PA-32RT-300 · S/N 32R-7885203Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Asterix Aviation LLCN760BNSikorsky S-76C · S/N 760674Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 2007 · Precision Heliparts IncN915DNMcdonnell Douglas MD-90-30 · S/N 53395Cancelled Jul 20, 2022 · First renewal notice · Built 1996 · Delta Air Lines IncN914DNMcdonnell Douglas MD-90-30 · S/N 53394Cancelled Jul 19, 2022 · First renewal notice · Built 1996 · Delta Air Lines IncN921DNMcdonnell Douglas MD-90-30 · S/N 53583Cancelled Jul 19, 2022 · First renewal notice · Delta Air Lines IncN670UCDJI INSPIRE 1 · S/N W13DCH14040478Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Carbon Films LLCN911DEMcdonnell Douglas MD-88 · S/N 49967Cancelled Jun 13, 2022 · Second renewal notice · Built 1992 · Delta Air Lines IncN607GTHorizon Hobby 1/4 SCALE J-3 CUB · S/N J3-04Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Georgia Institute Of TechnologyN608GTHorizon Hobby 1/4 SCALE J-3 CUB · S/N J3-05Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Georgia Institute Of TechnologyN637HGAscending Technologies ASCTEC PELICAN · S/N GTUAV-010Cancelled May 9, 2022 · Registration expired, pending cancellation · Georgia Institute Of TechnologyN825LUPiper PA-32-300 · S/N 32-7340139Cancelled May 3, 2022 · Exported to South Africa · Buchman Barry JN961DLMcdonnell Douglas MD-88 · S/N 49980Cancelled Apr 27, 2022 · Second renewal notice · Built 1990 · Delta Air Lines IncN904DLMcdonnell Douglas MD-88 · S/N 49535Cancelled Apr 25, 2022 · Built 1987 · Delta Air Lines IncN905DAMcdonnell Douglas MD-90-30 · S/N 53385Cancelled Apr 25, 2022 · Built 1995 · Delta Air Lines IncN911DAMcdonnell Douglas MD-90-30 · S/N 53391Cancelled Apr 25, 2022 · First renewal notice · Built 1995 · Delta Air Lines IncN918DEMcdonnell Douglas MD-88 · S/N 49959Cancelled Apr 25, 2022 · Built 1993 · Delta Air Lines IncN947DLMcdonnell Douglas MD-88 · S/N 49878Cancelled Apr 25, 2022 · First renewal notice · Built 1989 · Delta Air Lines IncN949DLMcdonnell Douglas MD-88 · S/N 49880Cancelled Apr 25, 2022 · Built 1990 · Delta Air Lines IncN955DLMcdonnell Douglas MD-88 · S/N 49886Cancelled Apr 25, 2022 · Second renewal notice · Built 1990 · Delta Air Lines IncN956DLMcdonnell Douglas MD-88 · S/N 49887Cancelled Apr 25, 2022 · Second renewal notice · Built 1990 · Delta Air Lines IncN958DLMcdonnell Douglas MD-88 · S/N 49977Cancelled Apr 25, 2022 · Built 1990 · Delta Air Lines Inc
Back to Atlanta, GA