OpenAirDocs.org
Columbus, MS

Cancelled registrations · 58

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

N12267Cessna 172M · S/N 17261911Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1973 · Onvoi LLCN798LSStark Aerospace ARROW LITE · S/N AL-58Cancelled May 29, 2020 · Registration expired, pending cancellation · Stark Aerospace IncN779CGStark Aerospace AHL-CA-110-00000-04 · S/N AL-59Cancelled May 2, 2020 · Registration expired, pending cancellation · Stark Aerospace IncN779ESStark Aerospace AHL-CA-110-00000-04 · S/N AL-28Cancelled May 2, 2020 · Registration expired, pending cancellation · Stark Aerospace IncN779GGStark Aerospace AHL-CA-110-00000-04 · S/N AL-13Cancelled May 2, 2020 · Registration expired, pending cancellation · Stark Aerospace IncN798NSStark Aerospace ARROW LITE · S/N AL-21Cancelled May 2, 2020 · Registration expired, pending cancellation · Stark Aerospace IncN724CSStark Aerospace HM100 · S/N 106205150003Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Stark Aerospace IncN6256RDJI Innovations PHANTOM 2 VISION + · S/N PH645512602Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Reed Henry F IIIN8062NM Squared BREEZE II · S/N 000588Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Built 2003 · Ellis Charles DN18MLCessna 182P · S/N 18261745Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Built 1973 · Dixie Equipment LLCN729ARSchafer Rick W FOXTROT 4 · S/N F-008Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 2014 · Schafer Rick WN214BTNorth American NA-64 · S/N 64-2217Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1940 · Roszell Casey RN421SDCessna 421B · S/N 421B0127Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1971 · S And D Aviation LLCN65084Mccormick Patrick DOUBLE EAGLE · S/N 049Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Mccormick PatrickN7154VMooney M20C · S/N 20-0041Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1974 · Brown Thiess MN6973BPiper PA-18A 150 · S/N 18-5093Cancelled Sep 3, 2014 · Revoked, canceled · Built 1956 · Simmons Charles KN71959Hawker Beechcraft 3000 · S/N PT-373Cancelled Aug 29, 2013 · Sale reported, canceled · Built 2007N72074Hawker Beechcraft 3000 · S/N PT-372Cancelled Aug 29, 2013 · Sale reported, canceled · Built 2007N73891Hawker Beechcraft 3000 · S/N PT-371Cancelled Aug 29, 2013 · Sale reported, canceled · Built 2007N4447LWeedhopper WEEDHOPPER 2C · S/N WH-2-43Cancelled Aug 28, 2013 · Sale reported, canceled · Built 2008N7020CHawker Beechcraft 3000 · S/N PT-370Cancelled Aug 27, 2013 · Sale reported, canceled · Built 2007N70869Hawker Beechcraft 3000 · S/N PT-369Cancelled Aug 27, 2013 · Sale reported, canceled · Built 2007N87211Ercoupe 415-C · S/N 384Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1946 · Betts James AN4793PPiper PA-23-250 · S/N 27-351Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1960 · Snapp Edward A JrN48798Haynes Dean A CASSUTT 3M · S/N 1Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1984N5219CBeech B35 · S/N D-2564Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1950 · Thielen Scott DavidN87678Lockheed T-33A · S/N 58-3689Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1958N4627LCessna 172G · S/N 17254622Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Peek Allie CN5899HPiper PA-16 · S/N 16-521Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1949N7009GSabre SABRE TRIKE · S/N M5441091Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1999N87871Piper L-21B · S/N 18-3598Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Golden Triangle Vocational Technical CenterN707RFCessna 172M · S/N 17263964Cancelled Nov 26, 2012 · Exported to Brazil · Built 1974 · Flight Levels LLCN4892HCessna 152 · S/N 152-84003Cancelled Jan 6, 2011 · Exported to Argentina · Ras IncN54SBBateson C Owen PITTS EAGLE · S/N 1-99Cancelled Mar 11, 2010 · Exported to Canada · Built 1999 · Cloudchasers LLCN757FMCessna 152 · S/N 15279705Cancelled Mar 4, 2009 · Exported to Philippines · Built 1977 · Taloney Air Service IncN7302CAir Tractor AT-301 · S/N 301-0592Cancelled Jun 20, 2008 · Built 1984 · Lowry IncN45205Air Tractor AT-401 · S/N 401-0756Cancelled May 2, 2002 · Triennial form not returned · Lowry IncN4080UCessna 150E · S/N 15061480Cancelled Jun 4, 1997 · Triennial form not returned · Hardy Thomas WN59228Let BLANIK L-13 · S/N 173310Cancelled Sep 22, 1993 · Triennial form not returned · State College Glider Club IncN757WXCessna 152 · S/N 15280072Cancelled Mar 20, 1990 · Triennial form not returned · Taloney Air Service IncN1327QCessna 150L · S/N 15072627Cancelled Jun 25, 1983 · Administratively canceled · Jim Ratliff Air Service IncN5193CCessna 310R · S/N 310R1513Cancelled Apr 1, 1983 · Jim Ratliff Air Service IncN7272FPiper PA-32R-300 · S/N 32R7780061Cancelled Jan 17, 1983 · Jim Ratliff Air Service IncN8985FHughes 269C · S/N 830233Cancelled Sep 23, 1982 · Administratively canceled · Mackay Jack DBAN14779Bellanca 17-30A · S/N 74-30683Cancelled Aug 12, 1982 · Administratively canceled · Shelton David CN7339PPiper PA-24 · S/N 24-2518Cancelled Oct 29, 1980 · Exported to Canada · Napper Russell EN9756WPiper PA-28-140 · S/N 28-23240Cancelled Nov 21, 1975 · Exported to Canada · Built 1967 · Farus James EN3575SCessna 172E · S/N 17250775Cancelled Sep 15, 1975 · Exported to Canada · Burnette William W Jr Poynor John WN2640Taylorcraft BC12-D · S/N 7672Cancelled Jun 25, 1975 · Exported to Canada · Furr Donald LN9261YPiper PA-31-310 · S/N 31-341Cancelled Nov 22, 1972 · Saunders B Carson
Back to Columbus, MS