OpenAirDocs.org
Jackson, MS

Cancelled registrations · 160

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 = 'MS' AND d.registrant_city = 'JACKSON'
  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.

N3998BBoeing E75 · S/N 75-5292Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1942 · Mississippi Agri & Forest Mus FdnN43489Piper PA-28-180 · S/N 28-7405199Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1974N61219Cessna 150J · S/N 15070894Cancelled Oct 3, 2012 · Sale reported, pending cancellation · Built 1969N30976Piper J4A · S/N 4-1250Cancelled Sep 26, 2012 · Registration expired, pending cancellation · Built 1940 · Burris James LN45197Cessna 150M · S/N 15076780Cancelled Aug 13, 2012 · Sale reported, pending cancellation · Built 1975N4814RCessna A188B · S/N 18802334TCancelled Aug 7, 2012 · Revoked, canceled · Built 1975 · King CleoN4497QCessna A188B · S/N 18800897Cancelled Jul 19, 2012 · Revoked, canceled · Built 1972 · Massengale KennethN50HFFrakes Harold PITTS S-I-D · S/N 7-0468Cancelled May 23, 2011 · Exported to Australia · Mccain William AN6755ZPiper PA-25-235 · S/N 25-2375Cancelled May 16, 2011 · Registration pending, pending cancellation · Built 1963N1715XCessna 210L · S/N 21060737Cancelled Apr 27, 2011 · Sale reported, pending cancellation · Built 1975N12PDContinental Copters TOMCAT MK6B · S/N 56-2175Cancelled Jan 21, 2011 · Sale reported, pending cancellation · Built 1956N134NJLockheed 18 · S/N 2080Cancelled Jul 13, 2009 · Registration revoked · Built 1941 · Hankins Ariways IncN9772NChampion Sid S JR JURCA MJ5 · S/N 175Cancelled Aug 10, 2007 · Triennial form not returned · Built 1989 · Champion Sid S JrN2625HCessna 310 · S/N 35025Cancelled Jul 24, 2007 · Built 1955 · Joseph William P JrN5543JCessna 172N · S/N 17273815Cancelled Jul 25, 2005 · Exported to Thailand · Built 1980 · Just Plane Stuff IncN190WCBritish Aerospace HS 125-700A · S/N NA0329Cancelled Nov 18, 2004 · Exported to Nigeria · Built 1982 · Walker Aviation IncN202DNDassault FALCON 100 · S/N 202Cancelled Mar 30, 2004 · Triennial form not returned · Built 1984 · Air Del IncN116KHHilton Ken RALLY RB3 · S/N 25565Cancelled Aug 7, 2003 · Second triennial mailing, no response · Hilton KenN842MBDouglas C-47 · S/N 19741Cancelled Mar 19, 2003 · Triennial form not returned · Built 1943 · Jim Hankins Air Service InN2005MCameron Balloons O-77 · S/N 5354Cancelled Mar 28, 2002 · Second triennial mailing, no response · Built 1987 · Summer Breeze IncN26801Gulfstream American AA-5A · S/N AA5A0736Cancelled May 5, 2000 · Triennial form not returned · Kyle Patrick BN8193BBeech A36 · S/N E-2671Cancelled Mar 15, 1999 · Triennial form not returned · Davis Charles RN90309Hogan James E SCORPION 133 · S/N 12125Cancelled Jan 12, 1998 · Triennial form not returned · Hogan James EN200FHBeech 200 · S/N BB231Cancelled May 27, 1997 · Exported to Canada · Mcraes IncN97121Embraer EMB-110P1 · S/N 110334Cancelled Mar 10, 1997 · Triennial form not returned · Flight Line IncN166FCessna 172 · S/N 36987Cancelled Sep 17, 1996 · Triennial form not returned · Capitol Front End ServiceN19239Cessna 150L · S/N 15074264Cancelled Sep 9, 1996 · Exported to Switzerland · Rogers Jimmie AN7165HHarrell Charles E GYROPLANE · S/N 1Cancelled Jun 11, 1996 · Triennial form not returned · Harrell Charles EN912LBeech 58 · S/N TH222Cancelled Feb 24, 1996 · Triennial form not returned · Jim Hankins Air Service IncN2992CEmbraer EMB-110P1 · S/N 110395Cancelled Nov 21, 1995 · Exported to Canada · Flight Line IncN38BTThompson William I S BUSHBY MUSTANG II · S/N 1234Cancelled May 4, 1994 · Triennial form not returned · Thompson William I SN81454Rockwell International 500-S · S/N 3276Cancelled Jul 6, 1984 · Administratively canceled · Laurel Fuel CompanyN1884JPiper PA-28-140 · S/N 28-24328Cancelled Jul 3, 1984 · Administratively canceled · Thompson J LamarN5756GCessna A188B · S/N 18801147Cancelled Jun 6, 1984 · Ashford Aerial ApplicationsN3553RBeech A23 · S/N M724Cancelled Nov 9, 1983 · Built 1965 · Williams Charles KN5163HCessna 152 · S/N 15284067Cancelled Mar 31, 1983 · Mississippi School Of Aviation IncN1808LBeech 58 · S/N TH-1264Cancelled Nov 9, 1982 · Sale reported, pending cancellation · Built 1981N6963UMooney M20C · S/N 2714Cancelled Oct 28, 1982 · Beach Stephen L IIIN28649Grumman American Avn. AA-5B · S/N AA5B-0722Cancelled Jul 29, 1982 · Mississippi School Of Aviation IncN80211Beech D18S · S/N A-191Cancelled Mar 31, 1982 · Hankins Airways IncN4559QCessna 402A · S/N 402A0059Cancelled Dec 23, 1981 · Built 1969 · Miller Air Transporters IncN6754DBeech 77 · S/N WA-100Cancelled Nov 2, 1981 · Miller-Wills Aviation IncN94388Engineering & Research 415-C · S/N 1611Cancelled Sep 19, 1980 · Exported to Canada · Ratliff Fabricating Co IncN54513Curtiss Wright C-46 · S/N 4477511Cancelled Oct 31, 1979 · Exported to Philippines · Craft WayneN54512Curtiss Wright C-46 · S/N 4477509ACancelled Jul 27, 1978 · Exported to Philippines · Craft WayneN54518Curtiss Wright C-46 · S/N 4478025Cancelled Jul 27, 1978 · Exported to Philippines · Craft WayneN2194NCessna 140 · S/N 12553Cancelled Oct 28, 1977 · Built 1947 · Turner Lawrence HN5814BCessna 182 · S/N 33814Cancelled Jul 12, 1977 · Circle M Sport Parachute Club IncN1956EAeronca 7AC · S/N 7AC-5523Cancelled Mar 4, 1977 · Sale reported · Built 1946N700SPBeech A100 · S/N B-92Cancelled Mar 22, 1976 · Built 1971 · Stribling-Puckett Inc
Back to Jackson, MS