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.

N954DLMcdonnell Douglas MD-88 · S/N 49885Cancelled Jan 24, 2020 · Built 1990 · Delta Air Lines IncN4NRGulfstream Aerospace G1159B · S/N 255Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1979 · Okland Aviation LLCN32687Piper PA-28-140 · S/N 28-7525098Cancelled Dec 5, 2019 · Registration expired · Built 1974 · Mccarty Joseph PN324GLBoeing 737-76N · S/N 28613Cancelled Dec 4, 2019 · Delta Air Lines IncN767NCMcdonnell Douglas DC-9-51 · S/N 47724Cancelled Nov 12, 2019 · Built 1977 · Delta Air Lines IncN400PMDJI INSPIRE 1 · S/N W13DCD16030551Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Proper Medium IncN724KSDJI INSPIRE 1 · S/N W13DCA13020413Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Shaw Steven MN753ZXDJI PHANTOM 2 · S/N PH645389250Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Habitat For Humanity InternationalN1201ADJI INSPIRE 1 · S/N W13DCB05020556Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Airtacc Aerial Video System LLCN914DEMcdonnell Douglas MD-88 · S/N 49957Cancelled Sep 16, 2019 · Built 1993 · Delta Air Lines IncN917DEMcdonnell Douglas MD-88 · S/N 49958Cancelled Sep 16, 2019 · Built 1993 · Delta Air Lines IncN924DLMcdonnell Douglas MD-88 · S/N 49711Cancelled Sep 16, 2019 · Built 1988 · Delta Air Lines IncN932DLMcdonnell Douglas MD-88 · S/N 49719Cancelled Sep 16, 2019 · Built 1989 · Delta Air Lines IncN933DLMcdonnell Douglas MD-88 · S/N 49720Cancelled Sep 16, 2019 · First renewal notice · Built 1989 · Delta Air Lines IncN937DLMcdonnell Douglas MD-88 · S/N 49810Cancelled Sep 16, 2019 · Built 1989 · Delta Air Lines IncN940DLMcdonnell Douglas MD-88 · S/N 49813Cancelled Sep 16, 2019 · Built 1989 · Delta Air Lines IncN943DLMcdonnell Douglas MD-88 · S/N 49816Cancelled Sep 16, 2019 · Built 1989 · Delta Air Lines IncN946DLMcdonnell Douglas MD-88 · S/N 49819Cancelled Sep 16, 2019 · Built 1989 · Delta Air Lines IncN26NBeech B35 · S/N D-2459Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1950 · Galfas Louise CN376FDJI INSPIRE 1 · S/N W13DCC07020066Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Molla Roman VN377FDJI INSPIRE 1 · S/N W13DCB05020457Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Molla Roman VN379FDJI S1000 PREMIUM · S/N 02Q0020739Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Molla Roman VN651WJJosh L Lewis IV MATRIX-S · S/N JL4-1Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Jl4 Inc DBAN699LKDJI PHANTOM 3 PROFESSION · S/N P76DCF28017017Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Simmonds Jason PN977DLMcdonnell Douglas MD-88 · S/N 53258Cancelled Sep 6, 2019 · Built 1991 · Delta Air Lines IncN143DABoeing 767-332 · S/N 25991Cancelled Aug 22, 2019 · Built 1998 · Delta Air Lines IncN919DEMcdonnell Douglas MD-88 · S/N 53422Cancelled Aug 22, 2019 · Built 1993 · Delta Air Lines IncN921DLMcdonnell Douglas MD-88 · S/N 49645Cancelled Aug 22, 2019 · Built 1988 · Delta Air Lines IncN931DLMcdonnell Douglas MD-88 · S/N 49718Cancelled Aug 22, 2019 · Built 1988 · Delta Air Lines IncN934DLMcdonnell Douglas MD-88 · S/N 49721Cancelled Aug 22, 2019 · Built 1989 · Delta Air Lines IncN948DLMcdonnell Douglas MD-88 · S/N 49879Cancelled Aug 22, 2019 · Built 1989 · Delta Air Lines IncN505GFGulfstream Aerospace G-IV · S/N 1275Cancelled Aug 21, 2019 · Built 1995 · Wh Air IncN950DLMcdonnell Douglas MD-88 · S/N 49881Cancelled Aug 13, 2019 · First renewal notice · Built 1990 · Delta Air Lines IncN13318Fairchild PT-26 · S/N FT814Cancelled Aug 5, 2019 · Revoked, canceled · Built 1943 · Raitch Frederick A UsnN675MCMcdonnell Douglas DC-9-51 · S/N 47651Cancelled Jul 26, 2019 · Third renewal notice · Built 1975 · Delta Air Lines IncN781NCMcdonnell Douglas DC-9-51 · S/N 48121Cancelled Jul 26, 2019 · Third renewal notice · Built 1979 · Delta Air Lines IncN996SBCessna 172K · S/N 17258251Cancelled Jul 15, 2019 · Registration expired, pending cancellation · Built 1969 · Skyfusion II LLCN84855Aeronca 7AC · S/N 7AC3574Cancelled Jul 8, 2019 · Revoked, canceled · Built 1946 · Johnson James DN528CABombardier CL-600-2B19 · S/N 7841Cancelled Jun 26, 2019 · Exported to United Kingdom · Built 2003 · Delta Material Services LLCN77828Luscombe 8A · S/N 3555Cancelled May 6, 2019 · Revoked, canceled · Built 1946 · Patterson Frederick W JrN612FQDJI PHANTOM 3 PROFESSION · S/N P76DCG17016631Cancelled May 1, 2019 · Registration expired, pending cancellation · Thyssenkrupp Industrial Solutions (USA) IncN918DLMcdonnell Douglas MD-88 · S/N 49583Cancelled Apr 8, 2019 · Second renewal notice · Built 1988 · Delta Air Lines IncN923DLMcdonnell Douglas MD-88 · S/N 49705Cancelled Apr 8, 2019 · Built 1988 · Delta Air Lines IncN926DLMcdonnell Douglas MD-88 · S/N 49713Cancelled Apr 8, 2019 · Built 1988 · Delta Air Lines IncN927DAMcdonnell Douglas MD-88 · S/N 49714Cancelled Apr 8, 2019 · Built 1988 · Delta Air Lines IncN634DLBoeing 757-232 · S/N 23615Cancelled Mar 23, 2019 · Sale reported · Built 1988N396KABoeing 747-4B5 · S/N 28096Cancelled Mar 20, 2019 · Sale reportedN920DLMcdonnell Douglas MD-88 · S/N 49644Cancelled Mar 19, 2019 · Built 1988 · Delta Air Lines IncN925DLMcdonnell Douglas MD-88 · S/N 49712Cancelled Mar 19, 2019 · Built 1988 · Delta Air Lines IncN928DLMcdonnell Douglas MD-88 · S/N 49715Cancelled Mar 19, 2019 · First renewal notice · Built 1988 · Delta Air Lines Inc
Back to Atlanta, GA