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.

N521USBoeing 757-251 · S/N 23209Cancelled Dec 6, 2018 · Built 1986 · Delta Air Lines IncN531USBoeing 757-251 · S/N 23846Cancelled Dec 6, 2018 · Built 1988 · Delta Air Lines IncN600TRMcdonnell Douglas DC-9-51 · S/N 47783Cancelled Dec 6, 2018 · Built 1979 · Delta Air Lines IncN644DLBoeing 757-232 · S/N 23998Cancelled Dec 6, 2018 · Built 1989 · Delta Air Lines IncN645DLBoeing 757-232 · S/N 24216Cancelled Dec 6, 2018 · Built 1989 · Delta Air Lines IncN648DLBoeing 757-232 · S/N 24372Cancelled Dec 6, 2018 · Built 1989 · Delta Air Lines Inc.N665USBoeing 747-451 · S/N 23820Cancelled Dec 6, 2018 · Built 1989 · Delta Air Lines IncN670MCMcdonnell Douglas DC-9-51 · S/N 47659Cancelled Dec 6, 2018 · First renewal notice · Built 1976 · Delta Air Lines IncN676MCMcdonnell Douglas DC-9-51 · S/N 47652Cancelled Dec 6, 2018 · First renewal notice · Built 1975 · Delta Air Lines IncN677MCMcdonnell Douglas DC-9-51 · S/N 47756Cancelled Dec 6, 2018 · First renewal notice · Built 1977 · Delta Air Lines IncN760NCMcdonnell Douglas DC-9-51 · S/N 47708Cancelled Dec 6, 2018 · First renewal notice · Built 1976 · Delta Air Lines IncN761NCMcdonnell Douglas DC-9-51 · S/N 47709Cancelled Dec 6, 2018 · First renewal notice · Built 1976 · Delta Air Lines IncN762NCMcdonnell Douglas DC-9-51 · S/N 47710Cancelled Dec 6, 2018 · First renewal notice · Built 1976 · Delta Air Lines IncN764RDBoeing 767-3Y0 · S/N 26204Cancelled Dec 6, 2018 · Second renewal notice · Built 1992 · Delta Air Lines IncN765NCMcdonnell Douglas DC-9-51 · S/N 47718Cancelled Dec 6, 2018 · First renewal notice · Built 1976 · Delta Air Lines IncN769NCMcdonnell Douglas DC-9-51 · S/N 47757Cancelled Dec 6, 2018 · First renewal notice · Built 1978 · Delta Air Lines IncN772NCMcdonnell Douglas DC-9-51 · S/N 47774Cancelled Dec 6, 2018 · First renewal notice · Built 1978 · Delta Air Lines IncN774NCMcdonnell Douglas DC-9-51 · S/N 47776Cancelled Dec 6, 2018 · First renewal notice · Built 1978 · Delta Air Lines IncN776NCMcdonnell Douglas DC-9-51 · S/N 47786Cancelled Dec 6, 2018 · First renewal notice · Built 1979 · Delta Air Lines IncN777NCMcdonnell Douglas DC-9-51 · S/N 47787Cancelled Dec 6, 2018 · First renewal notice · Built 1979 · Delta Air Lines IncN778NCMcdonnell Douglas DC-9-51 · S/N 48100Cancelled Dec 6, 2018 · First renewal notice · Built 1979 · Delta Air Lines IncN783NCMcdonnell Douglas DC-9-51 · S/N 48108Cancelled Dec 6, 2018 · First renewal notice · Built 1979 · Delta Air Lines IncN909DLMcdonnell Douglas MD-88 · S/N 49540Cancelled Dec 6, 2018 · Built 1987 · Delta Air Lines IncN3507AMcdonnell Douglas DC-9-82(MD-82) · S/N 49801Cancelled Nov 19, 2018 · First renewal notice · Built 1989 · Delta Air Lines IncN3159XAir Tractor AT-301 · S/N 301-0475Cancelled Nov 2, 2018 · Sale reported, canceled · Built 1983N646DLBoeing 757-232 · S/N 24217Cancelled Oct 30, 2018 · Built 1989 · Delta Air Lines IncN656DLBoeing 757-232 · S/N 24396Cancelled Oct 30, 2018 · Built 1990 · Delta Air Lines IncN677DLBoeing 757-232 · S/N 25982Cancelled Oct 30, 2018 · Built 1992 · Delta Air Lines IncN666USBoeing 747-451 · S/N 23821Cancelled Oct 25, 2018 · Built 1989 · Delta Air Lines IncN669USBoeing 747-451 · S/N 24224Cancelled Oct 25, 2018 · Built 1990 · Delta Air Lines IncN322GLBoeing 737-76N · S/N 28580Cancelled Oct 23, 2018 · Sale reportedN548WVAeromao AEROMAPPER 300 · S/N AM300-009Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Vision Services Group LLCN551CVDJI S900 · S/N 756FAF9FCE324498AC5F83D56E84D9Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Vision Services Group LLCN318USAirbus Industrie A320-211 · S/N 206Cancelled Sep 28, 2018 · First renewal notice · Built 1991 · Delta Air Lines IncN310NWAirbus Industrie A320-211 · S/N 121Cancelled Sep 27, 2018 · Built 1990 · Delta Air Lines IncN311USAirbus Industrie A320-211 · S/N 125Cancelled Sep 27, 2018 · Built 1990 · Delta Air Lines IncN313USAirbus Industrie A320-211 · S/N 153Cancelled Sep 27, 2018 · First renewal notice · Built 1990 · Delta Air Lines IncN334WRBeech A65 · S/N LC-262Cancelled Sep 13, 2018 · Revoked, canceled · Built 1967 · Orkin Extermainating Co IncN730SAAibotix AIBOT X6 V2 · S/N 02792014Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Solusia Air LLCN2715VBeech 35 · S/N D-91Cancelled Aug 28, 2018 · Sale reported, canceled · Built 1947N667USBoeing 747-451 · S/N 24222Cancelled Aug 22, 2018 · Built 1990 · Delta Air Lines IncN668USBoeing 747-451 · S/N 24223Cancelled Aug 22, 2018 · Built 1990 · Delta Air Lines IncN670USBoeing 747-451 · S/N 24225Cancelled Aug 22, 2018 · Built 1990 · Delta Air Lines IncN320GLBoeing 737-76N · S/N 32574Cancelled Aug 21, 2018 · Delta Material Services LLCN603DLBoeing 757-232 · S/N 22810Cancelled Aug 21, 2018 · Built 1984 · Delta Air Lines IncN628DLBoeing 757-232 · S/N 22918Cancelled Aug 21, 2018 · Built 1987 · Delta Air Lines IncN653DLBoeing 757-232 · S/N 24393Cancelled Aug 21, 2018 · Built 1990 · Delta Air Lines IncN844ASBombardier CL-600-2B19 · S/N 7317Cancelled Jul 30, 2018 · Built 1999 · Delta Material Services LLCN847ASBombardier CL-600-2B19 · S/N 7335Cancelled Jul 30, 2018 · Built 1999 · Delta Material Services LLCN848ASBombardier CL-600-2B19 · S/N 7339Cancelled Jul 30, 2018 · Built 1999 · Delta Material Services LLC
Back to Atlanta, GA