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.

N127BJMitsubishi MU-2B-36A · S/N 730SACancelled Apr 27, 1981 · Exported to Peru · Built 1978 · American Aviation Services IncN739PTCessna 172N · S/N 17270703Cancelled Apr 21, 1981 · Exported to Canada · Georgetown Capital CorpN44RKCessna 340A · S/N 340A0447Cancelled Mar 6, 1981 · Exported to South Africa · Built 1978 · Fulton Air Service IncN24016Beech C24R · S/N MC-481Cancelled Feb 23, 1981 · Built 1977 · Hangar One IncN4626XCessna 150G · S/N 15064676Cancelled Feb 19, 1981 · Atlanta Negro Airmen Intl Flying Club IncN38NRHughes Helicopters HUGHES 369D · S/N 570133DCancelled Feb 5, 1981 · Built 1977 · State Of GeorgiaN5359JCessna 421C · S/N 421C0672Cancelled Jan 16, 1981 · Exported to Germany · Ford Motor Credit CoN18458Beech 58TC · S/N TK-55Cancelled Dec 29, 1980 · Exported to Bolivia · Built 1977 · Hangar One IncN244BDouglas DC-7CF · S/N 44876Cancelled Dec 22, 1980 · Advance Aviation IncN40210Piper PA-23-250 · S/N 27-7305008Cancelled Dec 5, 1980 · Sale reported · Built 1973N4935XRockwell International S-2R · S/N 2143RCancelled Oct 14, 1980 · Exported to Honduras · Hanger One IncN67586Beech 58TC · S/N TK-130Cancelled Oct 6, 1980 · Exported to Bolivia · Hangar One IncN8792RBeech B-55 · S/N TC-1806Cancelled Sep 22, 1980 · Exported to Paraguay · Hangar One IncN4097ABeech 58 · S/N TH-16Cancelled Sep 9, 1980 · Exported to Paraguay · Built 1970 · Hangar One IncN6050UBeech 58P · S/N TH-199Cancelled Sep 4, 1980 · Exported to South Africa · Hangar One IncN3686NBeech 58TC · S/N TK-128Cancelled Aug 29, 1980 · Exported to Bolivia · Hangar One IncN66696Beech V35B · S/N D-10294Cancelled Aug 20, 1980 · Exported to Germany · Hangar One IncN6208FCessna 337 · S/N 337-0208Cancelled Aug 6, 1980 · Allen & Vickers IncN5450MBeech 200 · S/N BB209Cancelled Aug 5, 1980 · Exported to Bolivia · Hangar One IncN7319UCessna 411 · S/N 411-0019Cancelled Aug 4, 1980 · Epps Air Service IncN1341JRockwell International 112A · S/N 341Cancelled Jul 14, 1980 · Built 1975 · Mobleys School Of Aviation IncN302CBBellanca 17-30A · S/N 79-30911Cancelled Jul 2, 1980 · Exported to United Kingdom · Commercial Credit Equipment CorpN17855Beech E-55 · S/N TE-1119Cancelled Feb 8, 1980 · Exported to Venezuela · Built 1977 · Hangar One IncN9166QBeech 58 · S/N TH-132Cancelled Feb 4, 1980 · Exported to Guatemala · Hangar One IncN1277LDouglas DC-9-32 · S/N 47356Cancelled Jan 25, 1980 · Exported to Mexico · Built 1969 · Delta Air Lines IncN76TTPiper PA-28R-200 · S/N 28R-7635095Cancelled Oct 19, 1979 · Exported to Canada · Commander Aviation IncN6673ZBeech 95-B55 (T42A) · S/N TC-2272Cancelled Oct 18, 1979 · Exported to Argentina · Hangar One IncN54SPBell 47G-3B-1 · S/N 668100Cancelled Sep 20, 1979 · Department Of Public Safety Georgia State PatrolN60253Beech E-90 · S/N LW-321Cancelled Sep 5, 1979 · Exported to Iceland · Hangar One IncN66404Beech A36 · S/N E-1539Cancelled Jul 24, 1979 · Exported to Argentina · Hangar OneN35176Piper PA-31-350 · S/N 31-7952098Cancelled Jun 1, 1979 · Exported to United Kingdom · Built 1979 · Aviation Consultants IncN8660FHughes 269C · S/N 780700Cancelled Feb 20, 1979 · Exported to New Zealand · Executive Helicopters IncN182ZCessna 310A · S/N 38157Cancelled Nov 27, 1978 · Built 1958 · United States Department Of Agriculture Forest SvcN5870NRockwell International 114 · S/N 14415Cancelled Oct 16, 1978 · Exported to United Kingdom · Miller William Michael PN3912ABeech E-55 · S/N TE-784Cancelled Jul 13, 1978 · Exported to Paraguay · Built 1970 · Hangar One IncN91129Stomber KR-1 · S/N 1Cancelled Jul 12, 1978 · Stomber Michael TN2016GBeech 58 · S/N TH-945Cancelled Jun 30, 1978 · Exported to Bolivia · Built 1978 · Hangar One IncN5180GCessna 305A · S/N 22210Cancelled Jun 22, 1978 · Exported to Canada · Built 1951N18319Beech 95-B55 · S/N TC-2074Cancelled May 2, 1978 · Exported to Paraguay · Built 1977 · Hangar One IncN44548Piper PA-28-235 · S/N 28-7410094Cancelled Apr 20, 1978 · Exported to Australia · Built 1974 · Epps Air Service IncN18438Beech 95-B55 · S/N TC-2085Cancelled Feb 9, 1978 · Exported to Paraguay · Built 1977 · Hangar One IncN3EYBeech 95-A55 · S/N TC-484Cancelled Nov 18, 1977 · Built 1963 · Yates Air IncN16536Piper PA-28-140 · S/N 28-7325294Cancelled Oct 19, 1977 · Epps Air Service IncN91073Cessna 207 · S/N 20700057Cancelled Aug 30, 1977 · Built 1969 · Brown C WN1335UMcdonnell Douglas DC-9-31 · S/N 47393Cancelled Aug 25, 1977 · Built 1970 · Southern Airways IncN62843Piper PA-23-250 · S/N 27-7754058Cancelled Aug 23, 1977 · Exported to United Kingdom · Epps Air Service IncN735ZMCessna 182Q · S/N 18265815Cancelled Jul 25, 1977 · Exported to Venezuela · Fricano Stephen PN17743Beech 200 · S/N BB-273Cancelled Jul 18, 1977 · Exported to Venezuela · Built 1977 · Hangar One IncN8461QCessna U206F · S/N U20603319Cancelled Jun 17, 1977 · Exported to Norway · Built 1976 · Fulton Air Service IncN801EDouglas DC-8-51 · S/N 45408Cancelled May 27, 1977 · Delta Air Lines Inc
Back to Atlanta, GA