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.

N14824Bell 206B · S/N 853Cancelled Jul 1, 2009 · Registration revoked · Built 1972 · Atlanta Vertol CorporationN14549Semco Balloon MARK V · S/N SEM-145Cancelled Jun 30, 2009 · Registration revoked · Built 1974 · Hartline Edward GeorgeN15328Taylor E-2 · S/N 248Cancelled Jun 30, 2009 · Registration revoked · Built 1935 · Newsom Neal HN142JFBell 206B · S/N 2849Cancelled May 29, 2009 · Exported to Costa Rica · Built 1979 · Arguedas RobertoN90454Aerostar International RAVEN S57-A · S/N S57A-3139Cancelled May 15, 2009 · Triennial form not returned · Built 1992 · Corporate Leasing CorpN36MPBeech A36 · S/N E-1979Cancelled Apr 9, 2009 · Second triennial mailing, no response · Built 1981 · General Electric Capital CorpN623CQBeech A36 · S/N E-1382Cancelled Mar 12, 2009 · Triennial form not returned · Built 1978 · C & S Aviation IncN772DAMitsubishi MU-2B-60 · S/N 772 S.A.Cancelled Nov 19, 2008 · Exported to Brazil · Built 1980 · Epps Air Service IncN601DLBoeing 757-232 · S/N 22808Cancelled Jul 17, 2008 · Triennial form not returned · Built 1985 · Delta Air Lines IncN232ASEmbraer EMB-120RT · S/N 120.036Cancelled Jul 14, 2008 · Exported to Turks and Caicos Islands · Built 1987 · Delta Air Lines IncN540WDFrank James H F1 ROCKET · S/N 035Cancelled Jun 11, 2008 · Frank James HN9916UGrumman American Avn. AA-5A · S/N AA5A0316Cancelled Jun 3, 2008 · Triennial form not returned · Built 1977 · Hartmann Aviation IncN824AMRobinson Helicopter R44 II · S/N 10029Cancelled Apr 14, 2008 · Exported to Italy · Built 2003 · Island Helicopters LLCN1CRRaytheon 390 · S/N RB-146Cancelled Mar 31, 2008 · Exported to Isle Of Man · Roberts Properties IncN236WABoeing 737-247 · S/N 23184Cancelled Nov 21, 2007 · Exported to Mexico · Built 1984 · Delta Air Lines IncN237WABoeing 737-247 · S/N 23185Cancelled Nov 21, 2007 · Exported to Mexico · Built 1984 · Delta Air Lines IncN238WABoeing 737-247 · S/N 23186Cancelled Nov 21, 2007 · Exported to Mexico · Built 1984 · Delta Air Lines IncN239WABoeing 737-247 · S/N 23187Cancelled Nov 21, 2007 · Exported to Mexico · Built 1984 · Delta Air Lines IncN324DLBoeing 737-232 · S/N 23096Cancelled Nov 21, 2007 · Exported to Mexico · Built 1984 · Delta Air Lines IncN325DLBoeing 737-232 · S/N 23097Cancelled Nov 21, 2007 · Exported to Mexico · Built 1984 · Delta Air Lines IncN2061DSchweizer 269D · S/N 0034ACancelled Aug 30, 2007 · Exported to Poland · Built 2001 · Beeler DianeN2494LBell 206L · S/N 45028Cancelled Aug 6, 2007 · Exported to Canada · Built 1976 · Beeler RudenzN404SSDornier Luftfahrt 328-100 · S/N 3090Cancelled Jul 25, 2007 · Exported to Germany · Built 1997 · Bellsouth Corporate Aviation And Travel Svcs IncN250SEEllsworth Scott P SKYBOLT · S/N 1Cancelled Jun 29, 2007 · Triennial form not returned · Built 2000 · Bernden Jon DN46WQHawker Siddeley HS.125 SERIES 700A · S/N NA0334Cancelled Jun 5, 2007 · Exported to Benin · Built 1983 · International Jet Markets IncN104EXExtra Flugzeugbau EA-300 · S/N 010Cancelled May 1, 2007 · Exported to Australia · Galliot Bond LLCN46491Cessna 172K · S/N 17257302Cancelled Apr 18, 2007 · Triennial form not returned · Built 1968 · Lodwick Stephen LN503ASEmbraer EMB-120ER · S/N 120-275Cancelled Apr 11, 2007 · Exported to Turks and Caicos Islands · Built 1992 · Delta Air Lines IncN45FSCessna 501 · S/N 501-0102Cancelled Mar 28, 2007 · Exported to Australia · Built 1979 · Vanguard Investment And Consulting LLCN26174Cessna 172R · S/N 17280556Cancelled Mar 13, 2007 · Exported to France · Built 1998 · Atlantic Aviation Systems IncN264ASEmbraer EMB-120ER · S/N 120.165Cancelled May 31, 2006 · Exported to Angola · Built 1989 · Delta Air Lines IncN272AMCessna 172N · S/N 17269224Cancelled Jan 27, 2006 · Exported to Canada · Built 1977 · Airshares Elite IncN3450RPiper PA-28-180 · S/N 28-5684Cancelled Jan 5, 2006 · Sale reported · Built 1969N107MGBeech B200 · S/N BB-924Cancelled Jul 7, 2005 · Triennial form not returned · Built 1981 · Bk AssociatesN737DLockheed L-1011-385-1-15 · S/N 193C-1228Cancelled May 25, 2005 · Exported to Kyrgyzstan · Built 1982 · Delta Air Lines IncN838DWCessna 177B · S/N 17701607Cancelled May 13, 2005 · Exported to Canada · Built 1970 · Williamson James PN567SMLemon Richard AVID MARK IV · S/N 1401Cancelled May 6, 2005 · Sale reported · Built 2001N1739DLockheed L-1011-385-1-15 · S/N 193C-1237Cancelled Mar 31, 2005 · Exported to Kyrgyzstan · Built 1982 · Delta Air Lines IncN8807LPiper PA-25-235 · S/N 25-5304Cancelled Feb 16, 2005 · Exported to Bolivia · Built 1971N755AFMitsubishi MU-2B-60 · S/N 755SACancelled Feb 3, 2005 · Triennial form not returned · Epps Air Service IncN26486Cessna 172R · S/N 17280538Cancelled Dec 6, 2004 · Triennial form not returned · Built 1998 · T J Aviation IncN741DALockheed L-1011-385-1 · S/N 193C-1245Cancelled Dec 3, 2004 · Exported to Kyrgyzstan · Built 1983 · Delta Air Lines IncN283UEEmbraer EMB-120RT · S/N 120.139Cancelled Nov 24, 2004 · Exported to Switzerland · Built 1989 · International Airline Support Group IncN2521DCessna 170B · S/N 20673Cancelled Oct 17, 2004 · Built 1952 · Pease David EN960VVDouglas DC-9-31 · S/N 47067Cancelled Sep 30, 2004 · Triennial form not returned · Built 1977 · Airtran Airlines IncN230ASEmbraer EMB-120RT · S/N 120.032Cancelled Sep 17, 2004 · Triennial form not returned · Built 1987 · Atlantic Southeast Airlines IncN269UEEmbraer EMB-120RT · S/N 120.194Cancelled Jul 29, 2004 · Exported to South Africa · Built 1990 · International Airline Support Group IncN8078VEmbraer EMB-120 · S/N 120242Cancelled Jul 22, 2004 · Exported to Angola · Built 1991 · International Airline Support Group IncN150EFEagle EAGLE 150B · S/N 030Cancelled Jul 20, 2004 · Exported to Malaysia · Built 2000 · Airshares Elite IncN151EFEagle EAGLE 150B · S/N 036Cancelled Jul 20, 2004 · Exported to Malaysia · Built 2001 · Airshares Elite Inc
Back to Atlanta, GA