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.

N56982Piper PA-32-260 · S/N 327400013Cancelled Sep 15, 1992N4688BCessna 208B · S/N 208B0169Cancelled Jun 24, 1992N170Cessna 180 · S/N 50700Cancelled May 27, 1992 · Triennial form not returned · State Of GeorgiaN20AZSocata TB 10 · S/N 484Cancelled Apr 27, 1992 · Triennial form not returned · Bailey Donald EN7261ZPiper PA-25-235 · S/N 253197Cancelled Apr 10, 1992N525CWCessna 210M · S/N 21062438Cancelled Apr 6, 1992N4073WRobinson Helicopter R22 BETA · S/N 1887Cancelled Mar 27, 1992 · Exported to South Africa · Prestige HelicoptersN757EJCessna 152 · S/N 15279678Cancelled Nov 19, 1991N74651Grumman American Avn. AA-5B · S/N AA5B0324Cancelled Oct 17, 1991 · Triennial form not returned · Tiger Services IncN98427Cessna 421C · S/N 421C0032Cancelled Oct 7, 1991 · Triennial form not returned · Lag Air IncN3068BPiper PA-34-200T · S/N 347970013Cancelled Aug 29, 1991 · Hill Aircraft And Leasing CorpN4084KRobinson Helicopter R22 BETA · S/N 1860Cancelled Aug 23, 1991 · Exported to South Africa · Prestige HelicoptersN4195ERaven S55A · S/N S55A925Cancelled Aug 15, 1991 · Triennial form not returned · Wright William CN270ASEmbraer EMB-120RT · S/N 120218Cancelled Jul 30, 1991 · Atlantic Southeast Airlines IncN54629Mcdonnell-Douglas DC-10-30 · S/N 46852Cancelled Jun 11, 1991 · Triennial form not returned · Interlease IncN1894FCessna 210F · S/N 21058794Cancelled May 29, 1991N122BASemco Balloon T · S/N SEM122Cancelled Apr 8, 1991 · Triennial form not returned · First National Bk Of AtlantaN62866Beech 95-B55 (T42A) · S/N TC2441Cancelled Feb 14, 1991 · Exported to Brazil · Hangar One IncN821DFBeech A36 · S/N E2533Cancelled Feb 14, 1991 · Exported to Brazil · Hangar One IncN713DBBeech F90 · S/N LA225Cancelled Feb 7, 1991 · Exported to Brazil · Hangar One IncN1545NBeech F33A · S/N CE1326Cancelled Dec 14, 1990 · Exported to Brazil · Hangar One IncN7438FHughes 269C · S/N 360479Cancelled Apr 3, 1986 · Exported to Sweden · Mid States Helicopter IncN726DALockheed L-1011-385-1 · S/N 193C-1163Cancelled Jan 23, 1986 · Delta Air Lines IncN36782Piper PA-32RT-300T · S/N 32R-7887077Cancelled Dec 11, 1984 · Administratively canceled · Hill Aircraft & Lsg CorpN2954KCessna 180K · S/N 18053137Cancelled Nov 15, 1983 · Administratively canceled · State Of GeorgiaN67432Beech 95-B55 · S/N TC-2312Cancelled Oct 28, 1983 · Exported to Paraguay · Hangar One IncN62TABoeing 707-123B · S/N 17640Cancelled Jul 7, 1983 · Tigerair IncN8091ECessna 172N · S/N 17272139Cancelled Jun 6, 1983N3087KAyres S2R-600 · S/N 2568RCancelled May 13, 1983 · Exported to Canada · Built 1982 · Hangar One IncN5171MBeech C23 · S/N M2045Cancelled May 13, 1983 · Hangar One IncN25683Beech 58 · S/N TH-377Cancelled Mar 21, 1983 · Exported to Trinidad and Tobago · Built 1973 · Hangar One IncN2325XCessna 182H · S/N 18256225Cancelled Feb 24, 1983 · Commander Aviation IncN738FECessna 172N · S/N 17269937Cancelled Dec 13, 1982 · Voss Richard PN37149Beech 77 · S/N WA-189Cancelled Oct 29, 1982 · Built 1980 · Hangar One IncN5576XRockwell International S-2R · S/N 1776RCancelled Oct 8, 1982 · Exported to Honduras · Hangar One IncN211BJAero Commander 680-E · S/N 680E-681-14Cancelled Sep 28, 1982 · Built 1968 · Hill Aircraft & Leasing CorpN30893Ayres S-2R · S/N 2570RCancelled Sep 13, 1982 · Exported to Costa Rica · Built 1982 · Hangar One IncN29913Beech 200 · S/N BB-617Cancelled Aug 4, 1982 · Exported to Panama · Built 1980 · Hangar One IncN9943SGulfstream AM Corp Comm Div 695A · S/N 96023Cancelled Jan 27, 1982 · Exported to South Africa · Adastral CorpN9564UGrumman American Avn. AA-1C · S/N AA1C-0063Cancelled Dec 17, 1981 · Rice Charles LN4589PPiper PA-23-250 · S/N 27-98Cancelled Dec 2, 1981 · Exported to Bolivia · Built 1960 · Draper Fontaine YN751TABoeing 707-123B · S/N 17649Cancelled Dec 1, 1981 · Tigerair IncN69594Cessna 310Q · S/N 310Q0902Cancelled Oct 1, 1981 · Exported to Canada · Business Aircraft CorpN223KDBeech 65-A90 · S/N LJ181Cancelled Sep 3, 1981 · Exported to Brazil · Built 1966 · Hangar One IncN728MAMitsubishi MU-2B-26 · S/N 343Cancelled Sep 2, 1981 · Exported to Canada · Business Aircraft CorpN6158DCessna 172N · S/N 17272615Cancelled Jul 30, 1981 · Clendenin JohnN1857LBeech A65 · S/N LC-275Cancelled Jul 27, 1981 · Exported to Honduras · Built 1967 · Hangar One IncN6764YPiper PA-23-250 · S/N 27-4094Cancelled May 26, 1981 · Exported to Canada · Built 1968 · Business Aircraft CorpN583SMartin 404 · S/N 14111Cancelled May 8, 1981 · Southern Airways IncN89417Cessna 152 · S/N 152-82738Cancelled May 4, 1981 · Exported to Canada · Hangar One Inc
Back to Atlanta, GA