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.

N4064JCessna 150G · S/N 15065364Cancelled Jun 4, 2012 · Revoked, canceled · Built 1966 · Peachtree Flying Club IncN116YBeech C-45H · S/N AF-641Cancelled May 24, 2012 · Sale reported, canceled · Built 1960N468GMRaytheon 58 · S/N TH-2051Cancelled May 23, 2012 · Exported to Paraguay · Qm Air LLCN1044YCessna 180 · S/N 32833Cancelled Nov 2, 2011 · Sale reportedN24692Beech C23 · S/N M-1418Cancelled Sep 12, 2011 · Sale reported, pending cancellation · Built 1973N2379QBeech 23 · S/N M-459Cancelled Aug 26, 2011 · Sale reported, pending cancellation · Built 1963N6015FBeech C23 · S/N M-2134Cancelled Jul 23, 2011 · Triennial form not returned · Built 1979 · Quality Aviation IncN3513GNorth American TB-25N · S/N 4431489ACancelled Jul 5, 2011 · Revoked, canceled · Hughes Aviation And Engine CoN22EGCessna 421 · S/N 421-0018Cancelled Jun 28, 2011 · Registration pending, canceled · Built 1967N91048Cessna 207 · S/N 20700035Cancelled Apr 27, 2011 · Registration pending, pending cancellation · Built 1969N861CEBritish Aerospace BAE 125 SERIES 800A · S/N 258181Cancelled Apr 14, 2011 · Exported to Canada · Built 1990 · Coca-Cola Refreshments USA IncN191DDCessna P210N · S/N P21000399Cancelled Mar 30, 2011 · Exported to Mexico · Built 1979 · Rbc Bank (USA)N1154JRockwell International 112TC · S/N 13091Cancelled Mar 9, 2011 · Second renewal notice · Built 1976 · Kalunji Aviation Group LLCN751NWMcdonnell Douglas DC-9-41 · S/N 47115Cancelled Feb 9, 2011 · Built 1968 · Delta Air Lines IncN752NWDouglas DC-9-41 · S/N 47116Cancelled Feb 9, 2011 · Built 1968 · Delta Air Lines IncN760NWMcdonnell Douglas DC-9-41 · S/N 47288Cancelled Feb 9, 2011 · Built 1968 · Delta Air Lines IncN762NWMcdonnell Douglas DC-9-41 · S/N 47395Cancelled Feb 9, 2011 · Built 1969 · Delta Air Lines IncN763NWMcdonnell Douglas DC-9-41 · S/N 47396Cancelled Feb 9, 2011 · Built 1969 · Delta Air Lines IncN8926EDouglas DC-9-31 · S/N 45863Cancelled Nov 23, 2010 · Built 1967 · Delta Air Lines IncN759NWMcdonnell Douglas DC-9-41 · S/N 47287Cancelled Nov 22, 2010 · Built 1968 · Delta Air Lines IncN706EVBombardier CL-600-2C10 · S/N 10054Cancelled Nov 4, 2010 · Triennial form not returned · Built 2002 · Atlantic Southeast Airlines IncN613NWMcdonnell Douglas DC-9-32 · S/N 47438Cancelled Sep 23, 2010 · Built 1969 · Delta Air Lines IncN8928EDouglas DC-9-31 · S/N 45865Cancelled Sep 23, 2010 · Built 1967 · Delta Air Lines IncN8945EDouglas DC-9-31 · S/N 47181Cancelled Sep 23, 2010 · Built 1968 · Delta Air Lines IncN926NWDouglas DC-9-32 · S/N 47425Cancelled Sep 23, 2010 · Built 1970 · Delta Air Lines IncN8933EDouglas DC-9-31 · S/N 47142Cancelled Aug 31, 2010 · Delta Air Lines IncN9333Douglas DC-9-31 · S/N 47246Cancelled Aug 23, 2010 · Built 1968 · Delta Air Lines IncN945NMcdonnell Douglas DC-9-32 · S/N 47664Cancelled Aug 17, 2010 · Built 1975 · Delta Air Lines IncN925USMcdonnell Douglas DC-9-32 · S/N 47472Cancelled Aug 12, 2010 · Delta Air Lines IncN1799UDouglas DC-9-31 · S/N 47370Cancelled Aug 11, 2010 · Built 1969 · Delta Air Lines IncN7016ZBalloon Works FIREFLY 7-15 · S/N F7-1057Cancelled Aug 9, 2010 · Triennial form not returned · Built 1998 · Zirnheld Peter MN354TMMoran Thomas R HORIZON I · S/N H01178Cancelled Aug 2, 2010 · Second triennial mailing, no response · Built 2007 · Moran Thomas RN967NMcdonnell Douglas DC-9-32 · S/N 47573Cancelled Jul 29, 2010 · Built 1973 · Delta Air Lines IncN8923EDouglas DC-9-31 · S/N 45838Cancelled Jul 28, 2010 · Built 1967 · Delta Air Lines IncN9338Douglas DC-9-31 · S/N 47347Cancelled Jul 20, 2010 · Built 1969 · Delta Air Lines IncN1332UMcdonnell Douglas DC-9-31 · S/N 47404Cancelled Jul 13, 2010 · Built 1969 · Delta Air Lines IncN118WCessna 182T · S/N 18281201Cancelled Jun 21, 2010 · Exported to Brazil · Built 2003 · Hill Aircraft & Leasing CorpN1459CCirrus Design SR22 · S/N 0548Cancelled May 12, 2010 · Exported to South Africa · Built 2003 · Jenna Air LLCN916RWDouglas DC-9-31 · S/N 47144Cancelled Apr 22, 2010 · Built 1967 · Delta Air Lines IncN2791FRaven S-60A · S/N S60A-366Cancelled Jan 20, 2010 · Triennial form not returned · Built 1985 · Pyron Brigham AsburyN401SWGlaser-Dirks DG-400 · S/N 4-143Cancelled Jan 6, 2010 · Exported to Brazil · Wood Steven BN227RDDiamond Aircraft Ind DA20-C1 · S/N C0009Cancelled Dec 21, 2009 · Sale reported · Built 1998N153MCessna 180 · S/N 32314Cancelled Oct 29, 2009 · Exported to Mexico · Built 1955N9373LAmerican AA-1A · S/N AA1A-0073Cancelled Sep 18, 2009 · Registration revoked · Built 1971 · Dealer Data CorporationN791Cessna 180E · S/N 18051090Cancelled Sep 11, 2009 · Sale reported · Built 1961N6499DCessna 172N · S/N 17272833Cancelled Aug 25, 2009 · Exported to Panama · Built 1979 · T J Aviation IncN3035SDouglas A-26B · S/N 28034Cancelled Aug 19, 2009 · Registration revoked · Built 1944 · Rebel Aviation IncN964RTRaytheon B200 · S/N BB-1928Cancelled Aug 3, 2009 · Exported to France · Rt Ventures LLCN28828Luscombe 8A · S/N 1570Cancelled Jul 23, 2009 · Registration revoked · Built 1940 · Flood Jules CN23NDouglas DC-7C · S/N 45130Cancelled Jul 13, 2009 · Registration revoked · Built 1957 · American Air Express Leasing Company
Back to Atlanta, GA