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.

N929DLMcdonnell Douglas MD-88 · S/N 49716Cancelled Mar 19, 2019 · First renewal notice · Built 1988 · Delta Air Lines IncN930DLMcdonnell Douglas MD-88 · S/N 49717Cancelled Mar 19, 2019 · First renewal notice · Built 1988 · Delta Air Lines IncN942DLMcdonnell Douglas MD-88 · S/N 49815Cancelled Mar 19, 2019 · Built 1989 · Delta Air Lines IncN326GLBoeing 737-73A · S/N 28499Cancelled Mar 13, 2019 · Delta Material Services LLCN327GLBoeing 737-73A · S/N 28500Cancelled Mar 13, 2019 · Delta Material Services LLCN623DLBoeing 757-232 · S/N 22913Cancelled Mar 6, 2019 · Sale reported · Built 1987N525USBoeing 757-251 · S/N 23619Cancelled Feb 12, 2019 · Built 1987 · Delta Air Lines IncN527USBoeing 757-251 · S/N 23842Cancelled Feb 12, 2019 · Built 1987 · Delta Air Lines IncN609DLBoeing 757-232 · S/N 22816Cancelled Feb 12, 2019 · Built 1985 · Delta Air Lines IncN610DLBoeing 757-232 · S/N 22817Cancelled Feb 12, 2019 · Built 1985 · Delta Air Lines IncN617DLBoeing 757-232 · S/N 22907Cancelled Feb 12, 2019 · Built 1986 · Delta Air Lines IncN618DLBoeing 757-232 · S/N 22908Cancelled Feb 12, 2019 · Built 1986 · Delta Air Lines IncN625DLBoeing 757-232 · S/N 22915Cancelled Feb 12, 2019 · Built 1987 · Delta Air Lines IncN626DLBoeing 757-232 · S/N 22916Cancelled Feb 12, 2019 · Built 1987 · Delta Air Lines IncN657DLBoeing 757-232 · S/N 24419Cancelled Feb 12, 2019 · Built 1990 · Delta Air Lines IncN671USBoeing 747-451 · S/N 26477Cancelled Feb 6, 2019 · Built 1999 · Delta Air Lines IncN672USBoeing 747-451 · S/N 30267Cancelled Feb 6, 2019 · Built 1999 · Delta Air Lines IncN673USBoeing 747-451 · S/N 30268Cancelled Feb 6, 2019 · Built 1999 · Delta Air Lines IncN674USBoeing 747-451 · S/N 30269Cancelled Feb 6, 2019 · Built 1999 · Delta Air Lines IncN627DLBoeing 757-232 · S/N 22917Cancelled Jan 14, 2019 · Built 1987 · Delta Air Lines IncN919DLMcdonnell Douglas MD-88 · S/N 49584Cancelled Jan 14, 2019 · Built 1988 · Delta Air Lines IncN138DLBoeing 767-332 · S/N 25409Cancelled Jan 9, 2019 · Sale reported · Built 1991N14551Mcdonnell Douglas DC-9-82(MD-82) · S/N 53033Cancelled Jan 7, 2019 · Second renewal notice · Built 1991 · Delta Air Lines IncN298AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49310Cancelled Jan 7, 2019 · Second renewal notice · Built 1985 · Delta Air Lines IncN433AAMcdonnell Douglas DC-9-83(MD-83) · S/N 49451Cancelled Jan 7, 2019 · Second renewal notice · Built 1987 · Delta Air Lines IncN435AAMcdonnell Douglas DC-9-83(MD-83) · S/N 49453Cancelled Jan 7, 2019 · First renewal notice · Built 1987 · Delta Air Lines IncN552AAMcdonnell Douglas DC-9-82(MD-82) · S/N 53034Cancelled Jan 7, 2019 · First renewal notice · Built 1991 · Delta Air Lines IncN554AAMcdonnell Douglas DC-9-82(MD-82) · S/N 53084Cancelled Jan 7, 2019 · First renewal notice · Built 1991 · Delta Air Lines IncN593AAMcdonnell Douglas DC-9-83(MD-83) · S/N 53256Cancelled Jan 7, 2019 · First renewal notice · Built 1991 · Delta Air Lines IncN594AAMcdonnell Douglas DC-9-83(MD-83) · S/N 53284Cancelled Jan 7, 2019 · Second renewal notice · Built 1992 · Delta Air Lines IncN596AAMcdonnell Douglas DC-9-83(MD-83) · S/N 53286Cancelled Jan 7, 2019 · Second renewal notice · Built 1992 · Delta Air Lines IncN70524Mcdonnell Douglas DC-9-82(MD-82) · S/N 49916Cancelled Jan 7, 2019 · Second renewal notice · Built 1990 · Delta Air Lines IncN7506Mcdonnell Douglas DC-9-82(MD-82) · S/N 49800Cancelled Jan 7, 2019 · Second renewal notice · Built 1989 · Delta Air Lines IncN7512AMcdonnell Douglas DC-9-82(MD-82) · S/N 49806Cancelled Jan 7, 2019 · First renewal notice · Built 1989 · Delta Air Lines IncN7518AMcdonnell Douglas DC-9-82(MD-82) · S/N 49895Cancelled Jan 7, 2019 · First renewal notice · Built 1990 · Delta Air Lines IncN7521AMcdonnell Douglas DC-9-82(MD-82) · S/N 49898Cancelled Jan 7, 2019 · First renewal notice · Built 1990 · Delta Air Lines IncN7526AMcdonnell Douglas DC-9-82(MD-82) · S/N 49918Cancelled Jan 7, 2019 · First renewal notice · Built 1990 · Delta Air Lines IncN7540AMcdonnell Douglas DC-9-82(MD-82) · S/N 49994Cancelled Jan 7, 2019 · Second renewal notice · Built 1990 · Delta Air Lines IncN7542AMcdonnell Douglas DC-9-82(MD-82) · S/N 49996Cancelled Jan 7, 2019 · First renewal notice · Built 1990 · Delta Air Lines IncN7546AMcdonnell Douglas DC-9-82(MD-82) · S/N 53028Cancelled Jan 7, 2019 · First renewal notice · Built 1990 · Delta Air Lines IncN8500VAircraft Mfg & Development CH 2000 · S/N 200068Cancelled Jan 3, 2019 · Registration expired, pending cancellation · R&R Aero IncN51TVDJI PHANTOM 3 ADVANCED · S/N P76DCE26013338Cancelled Dec 27, 2018 · Registration expired, pending cancellation · Fox Television Station IncN728EFHawker Beechcraft 400A · S/N RK-598Cancelled Dec 21, 2018 · Exported to Poland · Holder Construction Group LLCN8DXCessna 500 · S/N 500-0303Cancelled Dec 20, 2018 · Registration expired, pending cancellation · Built 1976 · Shelter Charter Services IncN7509Mcdonnell Douglas DC-9-82(MD-82) · S/N 49803Cancelled Dec 18, 2018 · Second renewal notice · Built 1989 · Delta Air Lines IncN125DLBoeing 767-332 · S/N 24075Cancelled Dec 6, 2018 · Built 1988 · Delta Air Lines IncN401EAMcdonnell Douglas DC-9-51 · S/N 47682Cancelled Dec 6, 2018 · Built 1975 · Delta Air Lines IncN458BCMcdonnell Douglas MD-90-30 · S/N 53489Cancelled Dec 6, 2018 · First renewal notice · Delta Air Lines IncN502USBoeing 757-251 · S/N 23191Cancelled Dec 6, 2018 · Built 1985 · Delta Air Lines IncN503USBoeing 757-251 · S/N 23192Cancelled Dec 6, 2018 · Built 1985 · Delta Air Lines Inc
Back to Atlanta, GA