OpenAirDocs.org
Chamblee, GA

Cancelled registrations · 36

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 = 'CHAMBLEE'
  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.

N20HXEurocopter AS 350 B3 · S/N 3193Cancelled Mar 17, 2025 · Exported to Canada · Built 1999 · Helicopter Express LLCN32HXEurocopter AS 350 B3 · S/N 4551Cancelled Jan 7, 2025 · Exported to Canada · Helicopter Express LLCN6296JPiper PA-28-151 · S/N 28-7615360Cancelled Jan 9, 2021 · Exported to Argentina · Built 1976 · All2fly LLCN504WACessna 150M · S/N 15077354Cancelled Dec 3, 2019 · Exported to Argentina · Built 1975 · Bessegato Marcelo P DBAN25HXEurocopter AS 350 B3 · S/N 4355Cancelled Apr 11, 2018 · Exported to Canada · Built 2007 · Helicopter Express IncN123GWWalker-Greg B-8M · S/N 1Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1979 · Reed John RN4354MPiper PA-12 · S/N 12-3292Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1947 · Reinhardt Robert DN8792SCessna 150F · S/N 15062092Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1966 · Porter Tommy JN3929KPiper PA-28-140 · S/N 28-23802Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1967 · Poole Joseph D JrN66894Piper PA-31-350 · S/N 31-7405193Cancelled Oct 23, 2013 · Revoked, canceled · Built 1974 · Yates Air IncN8299FCessna 401 · S/N 401-0246Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1968 · Spirit Of The South IncN7958KBeech 95-B55 (T42A) · S/N TC-896Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1965 · Commercial Credit Equipment CorpN7451FHughes 269C · S/N 660514Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1976 · Commercial Credit Equipment CorpN7619VAero Commander CALLAIR A-9B · S/N 1347Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1967 · Corporate Jet AvnN914SSWhite John H STORCH · S/N SS4-047Cancelled Feb 14, 2013 · Sale reported, canceled · Built 1999N21HXBell 407 · S/N 53194Cancelled Feb 5, 2013 · Exported to Australia · Built 1997 · Helicopter Express IncN29276Cessna 210L · S/N 21059851Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1973 · Wilson Charles RN3880UCessna 336 · S/N 336-0180Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1964N868Bell 206B · S/N 4249Cancelled Sep 2, 2009 · Exported to Canada · Built 1992 · Helicopter Express IncN184AABeech 76 · S/N ME-400Cancelled Jul 24, 2009 · Triennial form not returned · Aviation Atlanta IncN681MPRobinson Helicopter R22 BETA · S/N 3345Cancelled Jul 9, 2004 · Built 2002 · Prestige Helicopters IncN5532QCessna 152 · S/N 15285119Cancelled Jan 10, 1995 · Triennial form not returned · Peachtree Dekalb Flt Academy IncN2315ARobinson Helicopter R22 BETA · S/N 2035Cancelled Nov 24, 1993 · Exported to Canada · Spares Leasing IncN7503QSchweizer HUGHES 269C · S/N S1185Cancelled Mar 6, 1991 · Exported to Sweden · Dooley Helicopters IncN5661ECessna 172N · S/N 17271915Cancelled Jun 7, 1985 · Exported to Canada · Comercial Credit Equipment CorpN25843Cessna 152 · S/N 15280814Cancelled Mar 2, 1982 · Built 1977 · Peachtree Dekalb Flight Academy IncN9110UCessna 150M · S/N 150-78061Cancelled Oct 14, 1981 · Peachtree Dekalb Flight Academy IncN63330Cessna 150M · S/N 15077239Cancelled May 7, 1981 · Peachtree Dekalb Flight Academy IncN355BYCurtiss Wright C-46 · S/N 30243Cancelled Nov 15, 1980 · Registration expired, pending cancellation · Built 1943 · B W I LeasingN751RPiper PA-28R-200 · S/N 28R-7535163Cancelled Jun 24, 1980 · B H Wade & Associates LtdN1447CPiper PA-22-135 · S/N 22-1199Cancelled Jun 6, 1975 · Collins Donald MN4384TPiper PA-28R-200 · S/N 28R-7235027Cancelled Jun 22, 1973 · Built 1972 · Epps Air Service IncN7857VMooney M20C · S/N 2820Cancelled Feb 17, 1972 · Sidney W Riley & Gordon L BaggettN5870RCessna 172G · S/N 17253539Cancelled Mar 16, 1971 · Epps Air Service IncN88907Douglas C-54B · S/N 18363Cancelled May 23, 1967 · Exported to Panama · Jet International CorpN55791Fairchild PT-23A-SL · S/N 260SLCancelled May 25, 1965 · Hamrick William B
Back to Chamblee, GA