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.

N1980KBeech A36 · S/N E1758Cancelled May 24, 2004 · Triennial form not returned · Built 1980 · Rogers P DN259KMaule M-7-235B · S/N 23016CCancelled May 4, 2004 · Exported to Canada · Built 1995 · American Beta CorporationN7030Sikorsky CH-19E · S/N 130160Cancelled Jan 16, 2004 · Triennial form not returned · Atlanta Technical CollegeN79BJAero Commander 680T · S/N 1610-46Cancelled Jan 16, 2004 · Triennial form not returned · Built 1966 · Atlanta Area Technical SchoolN4074APiper L-18C · S/N 18-2118Cancelled Jan 15, 2004 · Triennial form not returned · Atlanta Technical CollegeN1738DLockheed L-1011-385-1-15 · S/N 193C-1234Cancelled Oct 27, 2003 · Exported to Jordan · Built 1982 · Delta Air Lines IncN467DABoeing 727-232 · S/N 20744Cancelled Sep 5, 2003 · Triennial form not returned · Built 1973 · Delta Air Lines IncN474DABoeing 727-232 · S/N 20751Cancelled Aug 21, 2003 · Triennial form not returned · Built 1973 · Delta Air Lines IncN237ASEmbraer EMB-120RT · S/N 120.051Cancelled Aug 14, 2003 · Exported to Brazil · Atlantic Southeast Airlines IncN240ASEmbraer EMB-120RT · S/N 120.060Cancelled Aug 14, 2003 · Exported to Brazil · Built 1987 · Atlantic Southeast Airlines IncN22807Cessna 150H · S/N 15068529Cancelled Jul 28, 2003 · Sale reported · Built 1968N960CTDiamond Aircraft Ind DA20-C1 · S/N C0120Cancelled Jul 14, 2003 · Sale reported · Built 2000N239ASEmbraer EMB-120RT · S/N 120.057Cancelled Jun 27, 2003 · Exported to Brazil · Built 1987 · Atlantic Southeast Airlines IncN704WZCessna 150M · S/N 15078944Cancelled Mar 19, 2003 · Second triennial mailing, no response · Built 1976 · Siegelman Scott AN308BXCanadair CL-600-2B16 · S/N 5110Cancelled Oct 9, 2002 · Exported to Turkey · Built 1992 · Commercial Finance Efd 2002-I LLCN767DALockheed L-1011-385-3 · S/N 193H1209Cancelled May 30, 2002 · Exported to Democratic Republic of the Congo · Built 1981 · Delta Air Lines IncN90AGBombardier CL-600-2B16 · S/N 5414Cancelled Apr 18, 2002 · Built 1999 · Fleet National BankN740DALockheed L-1011-385-1-15 · S/N 193C-1244Cancelled Feb 8, 2002 · Exported to Sierra Leone · Built 1983 · Delta Air Lines IncN1509FBalloon Works FIREFLY 8-24 · S/N F8-073Cancelled Jan 8, 2002 · Triennial form not returned · Bayman William AN142DDAerospatiale/Aeritalia ATR 42-300 · S/N 040Cancelled Jan 2, 2002 · Exported to Canada · International Airline Support Group IncN8253EPiper PA-28-161 · S/N 28-8216183Cancelled Nov 8, 2001 · Triennial form not returned · Built 1982 · Epps Air Service IncN784DALockheed L-1011-385-1 · S/N 193A-1038Cancelled Jun 14, 2001 · Delta Air Lines IncN6116HFuller Stuart HOMBUILT 101 · S/N GRH 2749Cancelled May 17, 2001 · Horne Glen RolandN765DALockheed L-1011-385-3 · S/N 193H-1206Cancelled Apr 23, 2001 · Exported to Portugal · Delta Air Lines IncN1542CBalloon Works FIREFLY 7-B · S/N 10286Cancelled Mar 27, 2001 · Triennial form not returned · Zirnheld Peter MN2814WBoeing 727-247 · S/N 20870Cancelled Mar 27, 2001 · Triennial form not returned · Delta Air Lines IncN1734DLockheed L-1011-385-1 · S/N 193C-1225Cancelled Mar 12, 2001 · Exported to Cambodia · Delta Air Lines IncN414DABoeing 727-232 · S/N 21256Cancelled Feb 27, 2001 · Triennial form not returned · Delta Air Lines IncN497DABoeing 727-232 · S/N 21077Cancelled Feb 22, 2001 · Triennial form not returned · Delta Air Lines IncN404DABoeing 727-232 · S/N 21148Cancelled Feb 16, 2001 · Triennial form not returned · Delta Air Lines IncN406DABoeing 727-232 · S/N 21150Cancelled Feb 16, 2001 · Triennial form not returned · Delta Air Lines IncN409DABoeing 727-232 · S/N 21153Cancelled Feb 16, 2001 · Triennial form not returned · Delta Air Lines IncN411DABoeing 727-232 · S/N 21223Cancelled Feb 16, 2001 · Triennial form not returned · Delta Air Lines IncN420DABoeing 727-232 · S/N 21273Cancelled Feb 16, 2001 · Triennial form not returned · Delta Air Lines IncN490DABoeing 727-232 · S/N 21020Cancelled Feb 16, 2001 · Triennial form not returned · Delta Air Lines IncN495DABoeing 727-232 · S/N 21075Cancelled Feb 16, 2001 · Triennial form not returned · Delta Air Lines IncN496DABoeing 727-232 · S/N 21076Cancelled Feb 16, 2001 · Triennial form not returned · Delta Air Lines IncN1731DLockheed L-1011-385-1 · S/N 193C-1200Cancelled Feb 2, 2001 · Exported to Cambodia · Delta Air Lines IncN407DABoeing 727-232 · S/N 21151Cancelled Jan 31, 2001 · Triennial form not returned · Delta Air Lines IncN408DABoeing 727-232 · S/N 21152Cancelled Jan 31, 2001 · Triennial form not returned · Delta Air Lines IncN736DYLockheed L-1011-385-1-15 · S/N 193C-1227Cancelled Dec 8, 2000 · Exported to Democratic Republic of the Congo · Delta Air Lines IncN412DABoeing 727-232 · S/N 21232Cancelled Oct 24, 2000 · Triennial form not returned · Delta Air Lines IncN4001HMooney M20K · S/N 25-0452Cancelled Oct 16, 2000 · Exported to Canada · Aig Aviation IncN8447YPiper PA-28-161 · S/N 28-8216026Cancelled Oct 3, 2000 · American Air Flight Training IncN415DABoeing 727-232 · S/N 21257Cancelled Sep 26, 2000 · Triennial form not returned · Delta Air Lines IncN179DZBoeing 767-332 · S/N 30597Cancelled Jul 21, 2000 · Exported to China · Delta Air Lines IncN4072HMooney M20J · S/N 24-1051Cancelled Jul 6, 2000 · R And D Aviation CorpN94GSBoeing 727-44 · S/N 18892Cancelled May 12, 2000 · Exported to Angola · International Airline Support Group IncN315KBeech 95-B55 (T42A) · S/N TC-865Cancelled Mar 7, 2000 · Triennial form not returned · Jamgochian John JrN2807WBoeing 727-247 · S/N 20579Cancelled Feb 29, 2000 · Triennial form not returned · Delta Air Lines Inc
Back to Atlanta, GA