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.

N2809WBoeing 727-247 · S/N 20581Cancelled Feb 29, 2000 · Triennial form not returned · Delta Air Lines InceN485DABoeing 727-232 · S/N 20865Cancelled Feb 14, 2000 · Triennial form not returned · Delta Air Lines IncN2810WBoeing 727-247 · S/N 20648Cancelled Feb 1, 2000 · Triennial form not returned · Delta Air Lines IncN2811WBoeing 727-247 · S/N 20649Cancelled Feb 1, 2000 · Triennial form not returned · Delta Air Lines IncN481DABoeing 727-232 · S/N 20861Cancelled Dec 7, 1999 · Triennial form not returned · Delta Air Lines IncN484DABoeing 727-232 · S/N 20864Cancelled Dec 7, 1999 · Triennial form not returned · Delta Air Lines IncN483DABoeing 727-232 · S/N 20863Cancelled Nov 23, 1999 · Triennial form not returned · Delta Air Lines IncN455UEEmbraer EMB-120RT · S/N 120.163Cancelled Sep 1, 1999 · Exported to Australia · International Airline Support Group IncN1999LBoeing 737-205 · S/N 21184Cancelled Jun 4, 1999 · Exported to Mexico · Ataircraft One CorpN210NEBoeing 727-31 · S/N 18903Cancelled May 7, 1999 · Exported to Mauritius · International Airline Support Group IncN751DALockheed L-1011-385-3 · S/N 193W-1166Cancelled Feb 10, 1999 · Triennial form not returned · Delta Air Lines IncN920VVMcdonnell Douglas DC-9-32 · S/N 47262Cancelled Aug 22, 1998 · Airtran Airlines IncN14493Reims CESSNA FR172J · S/N 0444Cancelled Jun 4, 1998 · Allison William BN2853KLuscombe 8A · S/N 5580Cancelled Apr 29, 1998 · Triennial form not returned · Gill Michael TN8MQGates Lear Jet 25B · S/N 085Cancelled Apr 28, 1998 · Sale reportedN715DALockheed L-1011-385-1 · S/N 193C1092Cancelled Nov 8, 1997 · Triennial form not returned · Delta Air Lines IncN72710National Ballooning 858 · S/N 122Cancelled Sep 30, 1997 · Triennial form not returned · General Cinema Beveraages DBAN908VJDouglas DC-9-32 · S/N 47321Cancelled Sep 11, 1997 · Triennial form not returned · Valujet Airlines IncN8054UBeech F33A · S/N CE1662Cancelled Jul 11, 1997 · Exported to Brazil · Laurel Flying Service IncN904VJDouglas DC-9-32 · S/N 47377Cancelled Mar 17, 1997 · Valujet Airlines IncN785DLLockheed L-1011-385-1 · S/N 193A1121Cancelled Dec 12, 1996 · Triennial form not returned · Delta Air Lines IncN713DALockheed L-1011-385-1 · S/N 193C1089Cancelled Aug 22, 1996 · Triennial form not returned · Delta Air Lines IncN3086TBeech A36 · S/N E2309Cancelled Jun 13, 1996 · Triennial form not returned · 3086 Tango IncN1865DBeech B200 · S/N BB1119Cancelled Jun 5, 1996 · R And B LeasingN31SECessna 208B · S/N 208B0303Cancelled Feb 22, 1996 · Exported to Zimbabwe · Screaming Eagle IncN781DLLockheed L-1011-385-1 · S/N 193A1003Cancelled Jan 25, 1996 · Triennial form not returned · Delta Air Lines IncN256ASEmbraer EMB-120 · S/N 120122Cancelled Nov 15, 1995 · Triennial form not returned · Atlantic Southeast Airlines IncN59869Piper PA-31-325 · S/N 317612070Cancelled Aug 17, 1995 · Exported to British Virgin Islands · Everett Willis M IIIN530DABoeing 727-232 · S/N 21813Cancelled Aug 14, 1995 · Triennial form not returned · Delta Air Lines IncN65DAEmbraer EMB-110P1 · S/N 110389Cancelled May 18, 1995 · Triennial form not returned · Atlantic Southeast Airlines IncN36LCBeech 58P · S/N TJ28Cancelled Apr 4, 1995 · Dagley Leasing CoN8994FHughes 269C · S/N 830228Cancelled Apr 4, 1995 · Triennial form not returned · City Of AtlantaN551TJPdps Pzl-Bielsko SZD-55-1 · S/N 551192029Cancelled Nov 1, 1994 · Exported to Canada · Ware Robert RN7557NCessna TU206G · S/N U20603670Cancelled Sep 22, 1994 · Exported to South Africa · Owens Foundation Wildlife ConservatnN9340DCessna 172RG · S/N 172RG1127Cancelled Sep 15, 1994 · Charlie Brown Flying Club IncN301DEBoeing 737-332 · S/N 25994Cancelled Aug 18, 1994 · Exported to Turkmenistan · Delta Air Lines IncN302DEBoeing 737-332 · S/N 25995Cancelled Aug 18, 1994 · Exported to Turkmenistan · Delta Air Lines IncN86CEBell 206L-3 · S/N 51400Cancelled Apr 19, 1994 · Johnston Coca Cola Bottling Co IncN200ELBeech 200 · S/N BB870Cancelled Nov 12, 1993 · Exported to Argentina · Cashiers Planning Group IncN23577Beech A36 · S/N E1091Cancelled Nov 12, 1993 · Exported to Brazil · United Beechcraft IncN304DEBoeing 737-332 · S/N 25997Cancelled Nov 12, 1993 · Exported to China · Delta Air Lines IncN305DEBoeing 737-332 · S/N 25998Cancelled Nov 12, 1993 · Exported to China · Delta Air Lines IncN250MCBeech D18S · S/N A94Cancelled Aug 19, 1993N8855VBellanca 17-31A · S/N 3249Cancelled May 13, 1993N3010CMcdonnell Douglas DC-9-82(MD-82) · S/N 49903Cancelled Apr 15, 1993 · Exported to Netherlands · Global Aircraft Leasing IncN145PDDietrick Paul A ROTORWAY EXEC · S/N 2943Cancelled Jan 11, 1993 · Triennial form not returned · Dietrick Paul AllenN5545BBeech B200 · S/N BB1334Cancelled Dec 23, 1992 · Exported to Turkey · Hangar One IncN7138KDehavilland DHC-6-300 · S/N 477Cancelled Oct 9, 1992 · Exported to Colombia · Satair USA IncN4589VBeech 35 · S/N D1060Cancelled Sep 23, 1992 · Triennial form not returned · Chapman Alan TN49449Cessna 152 · S/N 15281276Cancelled Sep 15, 1992 · Hogue L Lynn
Back to Atlanta, GA