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.

N43682Godfrey Fred K CELEBRITY · S/N AV1020Cancelled Aug 22, 2013 · Sale reported, canceledN1847DBeech C35 · S/N D-3096Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1952N348MHHodges Mac TIERRA II · S/N 3488528Cancelled Aug 21, 2013 · Sale reported, canceledN737NZCessna 172N · S/N 17269558Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1977N8762HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1517Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1975N9497BCessna 172RG · S/N 172RG0838Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1981N6006SBeech B-60 · S/N P-346Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1975N2847TPiper PA-28-140 · S/N 28-7225252Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1972N3908LCessna 172G · S/N 17254077Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1966N45618Cessna 150M · S/N 15076992Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1975N6922TPiper PA-28-181 · S/N 28-7790072Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1976N8392XCessna 172C · S/N 17248892Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1961N100LCPiper PA-23-250 · S/N 27-4658Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1971N18891Beech C24R · S/N MC-515Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1977N5682MRaven S55A · S/N S55A-506Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Simmons CompanyN723CDCirrus Design SR22 · S/N 0059Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 2001 · Airshares Elite IncN995Ernst JEENIE TEENIE TWO · S/N 1330Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Reeves Robert WN50929Air Tractor AT-602 · S/N 602-0461Cancelled Aug 14, 2013 · Sale reported, canceled · Built 1997N18960Beech 76 · S/N ME-10Cancelled Aug 12, 2013 · Sale reported, canceled · Built 1978N48959Cessna 152 · S/N 15283394Cancelled Aug 12, 2013 · Sale reported, canceled · Built 1979N6932WPiper PA-28-140 · S/N 28-21290Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1965N93908Cessna 152 · S/N 15285570Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1982N1768FCessna 172H · S/N 17255163Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1966N410JSCessna 150F · S/N 15062498Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1965N6479VHelio H-295 · S/N 1433Cancelled Aug 6, 2013 · Revoked, canceled · Built 1970 · Beeco CorporationN2990MCameron Balloons US N-105 · S/N 5165Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1986 · Wright WilliamN4090ZJohannessen Gene RANS -S14 · S/N 0792034Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1994N50635Cessna 150J · S/N 15069451Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1968 · Moody Roy WN734PRCessna 172N · S/N 17269011Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1977N8726MBeech 23 · S/N M-515Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1963N164FBeech E18S · S/N BA-90Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1955 · Wilson V LN78MXWalker-Cassutt II · S/N 1Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1969 · Walker Rexford DN93BEAero Commander 1121 · S/N 27Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1965 · Business Aircraft CorpN2908RCessna 310G · S/N 310G0108Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1962 · Harris JoeN124DGDehavilland CARIBOU DHC-4A · S/N 120Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1967 · Base Documental De La Empresa Of Georgia IncN50472Cessna 150J · S/N 15069328Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1968N551CCCessna 208 · S/N 208-00017Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1985 · Air Carriers Express Services IncN74182Balloon Works FIREFLY 7 · S/N F7-321Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Bellsouth Mobility Inc.N2484SHead Balloons AX7-77 · S/N 103Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Fraenckel Judith IN74CCBeech C90 · S/N LJ-620Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1974N95394Piper PA-28-140 · S/N 28-25890Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1969N35919Aerostar International RAVEN S-55A · S/N S55A-3041Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1988N4061QCessna 402 · S/N 402-0161Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1967N6180VConsolidated Aeronautics LAKE LA-4-200 · S/N 833Cancelled May 31, 2013 · Sale reported, canceled · Built 1977N353RKHughes 369A · S/N 701435Cancelled May 30, 2013 · Registration expired, pending cancellation · Freelance Air IncN4099JPiper PA-31-310 · S/N 31-8212001Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1981 · American Inter-Coastal Properties InN8340YPiper PA-32R-301T · S/N 32R-8129042Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1981 · Vector CorpN9901AThunder Balloons AX7-77 · S/N 151Cancelled May 30, 2013 · Registration expired, pending cancellation · Fuller Steven H JrN9907LGrumman American Avn. AA-1B · S/N AA1B-0207Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1973 · Merlin Leasing IncN477QBKavanagh Balloons EX-60 · S/N EX60-435Cancelled May 29, 2013 · Exported to Japan · Built 2011 · Balloonpong Enterprises LLC
Back to Atlanta, GA