OpenAirDocs.org
Columbus, GA

Cancelled registrations · 79

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

N599TGGiles Tommy H III ZNTH ZODIAC CH601HDS · S/N 001Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Giles Tommy H IIIN510CPBell OH-58A · S/N 70-15183Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Columbus Police DeptN4457TPiper PA-28R-200 · S/N 28R-7235057Cancelled Apr 2, 2022 · Registration expired, pending cancellation · J W Culpepper LLCN9178TAerostar International RX 8 · S/N RX8-3190Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1994 · Hiben Eric CN760GHDJI PHANTOM 2 VISION + · S/N PH645466329Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Hecht Burdeshaw Architects IncN149AMMcleod Alan FW-190 1/2 SCALE · S/N M2649Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Wade George AN38554Piper J3F-65 · S/N 7122Cancelled Nov 22, 2017 · Revoked, canceled · Built 1941 · Johnson Walter BN6047PPiper PA-24-250 · S/N 24-1143Cancelled Nov 21, 2017 · Revoked, canceled · Built 1959 · Mchale Joseph LN381JGLux Lewis CGS HAWK ARROW II · S/N H-875-SSAP-TRI-2706Cancelled May 31, 2017 · Registration expired, pending cancellation · Gandy Jeremy SN1344ZLaroque Raymond E VARI-EZE · S/N 847Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Dominguez KennethN9490SBeech 95-C55 · S/N TE-80Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1966 · Melody Maid Ice Cream CoN90115Whitten Robert G III J4 SPORTSTER · S/N HSI0010440Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Whitten Robert GN3723SCessna 172E · S/N 17250923Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1963 · Ellison Robert R JrN2456UCessna 172D · S/N 17250056Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1963 · Toole David BN1755TPiper PA-28-140 · S/N 28-7125072Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Built 1970 · Johnson 55tango LLCN6071YPiper PA-23-250 · S/N 27-3269Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1966 · Colquitt Walter RN6880SAero Commander 680 · S/N 680-403-80Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1956 · H & R Surveying IncN697LSchempp-Hirth NIMBUS 3 · S/N 43Cancelled Apr 1, 2013 · Sale reported, canceled · Built 1983N8157FCessna 150F · S/N 15064257Cancelled Feb 27, 2013 · Sale reported, canceledN64574Mccann EASYRISER · S/N 0M-777Cancelled Feb 13, 2013 · Sale reported, canceledN304RMCessna T210M · S/N 21061793Cancelled Dec 10, 2012 · Exported to Mexico · Built 1977 · Southernaire Aviation LLCN4287HMooney M20J · S/N 24-0695Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1978 · Shumate Robert E LN27CPMartin Theodore G VARIEZE · S/N 1195Cancelled Jun 27, 2012 · Registration pending, canceled · Built 1979N39DXO'Bert James VARI-EZE · S/N 311Cancelled Mar 26, 2010 · Built 1994 · Edmonds Gerald MN2740NCessna 140 · S/N 12998Cancelled Jul 20, 2009 · Registration revoked · Built 1947 · Barbery Harry J JrN28BZNorth American T-28C · S/N 140637Cancelled Mar 29, 2005 · Built 1958 · Serrato Daniel H MdN41948Raven S55A · S/N S55A-922Cancelled Dec 2, 2004 · Triennial form not returned · Built 1982 · Schley Philip TN18931Beech C23 · S/N M-1995Cancelled Sep 8, 2000 · Jain Ashish KN9319CPiper PA-28R-201 · S/N 28R7837190Cancelled Dec 16, 1994 · Triennial form not returned · Sunny Skies IncN614ECBeech B-60 · S/N P549Cancelled Dec 5, 1994 · Exported to Germany · G T Aviation IncN4482PPiper PA-23-160 · S/N 232004Cancelled Oct 3, 1994 · Corporate Air Transport IncN8819ZCessna 172H · S/N 17255469Cancelled May 24, 1994 · Corporate Air Transport IncN69069Cessna 152 · S/N 15282471Cancelled Nov 3, 1993 · Triennial form not returned · Fairchild Donald RN985CAPiper PA-31T · S/N 31T8020003Cancelled Jun 21, 1993 · Exported to Guatemala · Buck Industries IncN7523CPiper PA-28R-200 · S/N 28R7635101Cancelled Sep 22, 1992 · Triennial form not returned · Sunny Skies IncN2993ECessna 172N · S/N 17271397Cancelled Apr 8, 1991 · Exported to Germany · Butler James E JrN3964QWatkins Cham ROTEC RALLY 3A · S/N 25125Cancelled Jun 10, 1983 · Built 1983 · Watkins ChamN40977Piper PA-28-151 · S/N 28-7415125Cancelled Dec 23, 1981 · Built 1974 · Evans James F JrN7234XCessna 150A · S/N 15059334Cancelled Oct 19, 1981 · Dart Manufacturing CoN2271SCessna 210L · S/N 21061214Cancelled May 6, 1981 · Built 1976 · Woodruff Brown Co EtalN1874GChampion 7ECA · S/N 598Cancelled Jun 9, 1978 · Built 1968 · Panacea EnterprisesN310ZCessna 310F · S/N 310-0123Cancelled Jul 12, 1977 · Billy Meadows Ent IncN7680CNorth American T-28A · S/N 49-1493Cancelled Aug 8, 1974 · Melody Maid Pizza Co IncN6303TNorth American F-51D · S/N 44-63481Cancelled Aug 14, 1972 · Pizza On Call Franchise Co IncN100RCAero Commander 1121 · S/N 60Cancelled Feb 4, 1971 · Royal Crown Cola CoN65672Cessna T-50 · S/N 1752Cancelled Oct 9, 1970 · Kings School Of Aviation IncN8600JCessna 150G · S/N 15066500Cancelled Jun 25, 1970 · Kozel Frank IIIN7901ZCessna 150C · S/N 15060001Cancelled Feb 17, 1965 · Helms Air Services IncN7506EChampion 7FC · S/N 7FC-226Cancelled Oct 18, 1961 · Exported to Canada · Kings School Of Aviation IncN3829PPiper PA-22-150 · S/N 22-3519Cancelled Feb 18, 1957 · Built 1956 · Kings School Of Aviation Inc
Back to Columbus, GA