OpenAirDocs.org
Sikeston, MO

Cancelled registrations · 51

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 = 'MO' AND d.registrant_city = 'SIKESTON'
  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.

N815JBDJI PHANTOM 4 PRO · S/N OAXCE720B30241Cancelled Nov 8, 2022 · Bollinger John DN225MGJohn A Brewer MAGNI GYRO M16 · S/N 16116854Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Brewer John AN467RRBearer Ron JR BABY GREAT LAKES · S/N 09-1052Cancelled May 11, 2021 · Sale reported, pending cancellation · Built 2011N70556Piper J3C-65 · S/N 17565Cancelled Jan 24, 2020 · Revoked, canceled · Built 1946 · Cargile CoN8597CPiper PA-22-135 · S/N 22-1269Cancelled Aug 23, 2019 · Revoked, canceled · Built 1953 · Storey KennethN617DBByrd Danny WINDJAMMER II · S/N 6Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Byrd DannyN80011Brewer James H FLIGHTSTAR · S/N JB32Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1996 · Brewer James HN7298LRaven Industries RX6 · S/N RX6-129Cancelled Feb 4, 2017 · Revoked, canceled · Built 1974 · Presley H GN8293UCessna 172F · S/N 17252193Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Delta Standard IncN4845QCessna A188B · S/N 18802581TCancelled May 15, 2015 · Registration expired, pending cancellation · Built 1976 · Hoppe DonaldN6689GCessna 150L · S/N 15072189Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1970 · Jolliff Carlos PN7499Grumman Acft ENG Cor-Schweizer G-164A · S/N 977Cancelled Oct 22, 2014 · Revoked, pending cancellation · Built 1972 · Alberson KeithN71LHHornback KINGFISHER · S/N 71-LHCancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1975 · Hornback LarryN7076BBeech D-50 · S/N DH-36Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1956N7268Beech UC-45J · S/N 29591Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1944N3755VCessna 150M · S/N 15076611Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1975 · Jolliff PerryN5305WPiper PA-28 · S/N 28-356Cancelled Sep 18, 2012 · Sale reported, pending cancellation · Built 1962N6702KGrumman Acft ENG Cor-Schweizer G-164C · S/N 23CCancelled Aug 20, 2012 · Third renewal notice · Built 1978 · Haughey Hal W TrusteeN2625XCessna P206 · S/N P206-0125Cancelled Dec 19, 2011 · Built 1965 · Dorris Donald EN100ETPiper PA-31-325 · S/N 31-8012060Cancelled May 2, 2011 · Third renewal notice · Built 1980 · Lincoln James DBAN108MMWsk-Pzl-Mielec PZL-M-18 · S/N 1Z005-12Cancelled Apr 26, 2007 · Triennial form not returned · Built 1980 · Ag Air IncN91966Air Tractor AT-402 · S/N 402-0941Cancelled Feb 5, 2002 · Built 1994 · Bootheel Flying ServiceN48FSGrumman Acft ENG Cor-Schweizer G-164A · S/N 1660Cancelled Oct 25, 2000 · Triennial form not returned · Beeson Cecil TN7358Grumman Acft ENG Cor-Schweizer G-164A · S/N 927Cancelled Dec 16, 1999 · Beeson Cecil T DBAN459RFGrumman G-164 · S/N 121Cancelled Nov 20, 1997 · Triennial form not returned · Beeson Cecil T DBAN7304ZPiper PA-25-235 · S/N 253248Cancelled Jun 3, 1997 · Exported to Mexico · Crop Air HelicoptersN4685BWsk-Pzl-Mielec PZL-M-18 · S/N 1Z01210Cancelled Mar 1, 1995 · Triennial form not returned · Hall Flying Service IncN1189QCessna 210L · S/N 21059689Cancelled Apr 15, 1982 · Administratively canceled · Presley Calvin DBAN6943PPiper PA-24-250 · S/N 24-2078Cancelled Nov 12, 1980 · Sikeston Aero Club IncN4349YPiper PA-25-260 · S/N 254848Cancelled Nov 15, 1979 · Exported to Mexico · Built 1968 · Jolliff PerryN16922Bell 206L · S/N 45143Cancelled Jun 18, 1979 · Exported to Canada · Fabick Bros Equipment CoN7921ABoeing E75N1 · S/N 75-5306Cancelled Oct 7, 1974 · Cargile CoN8362LCessna 172I · S/N 17256562Cancelled Aug 2, 1974 · Exported to Canada · Built 1968 · Ward Aircraft Sales & Service IncN4918YPiper PA-25-235 · S/N 25-4721Cancelled Jun 17, 1974 · Ag-Air IncN4894YPiper PA-25-235 · S/N 25-4702Cancelled Mar 12, 1974 · Built 1968 · Ag Air IncN44CDDehavilland OTTER U-1A · S/N 57-6108Cancelled Jun 5, 1973 · City Of Sikestoncivil DefenseN5047YPiper PA-23-250 · S/N 272056Cancelled Jun 4, 1973 · Exported to Canada · Built 1962 · Holyfield Flying Service IncN4630YPiper PA-25-235 · S/N 25-4348Cancelled May 25, 1972 · Exported to Canada · Built 1967 · Holyfield Flying Service IncN5812NBoeing A75N1 · S/N 758521Cancelled Nov 24, 1971 · Registration revoked · Built 1943 · Holyfield HenryN98666Piper J3C-65 · S/N 18895Cancelled Oct 13, 1970 · James G MaloneN84611Aeronca 7AC · S/N 7AC-3323Cancelled Jul 10, 1970 · Hannah William EarlN7681ZPiper PA-25-235 · S/N 25-3832Cancelled Aug 23, 1968 · Holyfield HenryN49948Boeing A75L3 · S/N 75-2764Cancelled Jan 26, 1968 · Exported to Canada · Built 1941 · Holyfield HenryN60486Boeing E75 · S/N 75-255Cancelled Mar 19, 1958 · Exported to Canada · Servair IncN8063CPiper PA-18A · S/N 18-3414Cancelled Sep 16, 1955 · Cargile CoN136CStinson 108-2 · S/N 108-3136Cancelled Nov 3, 1954 · Gladney BillN85815Aeronca 11AC · S/N 11AC-225Cancelled Jul 25, 1949 · Built 1946 · Robinson Don EN73539Cessna T-50 · S/N 3423Cancelled May 10, 1949 · Martin George SN54875Consolidated Vultee BT-13A · S/N 8802Cancelled Dec 21, 1948 · Cravens Joseph MN846Waco 10 · S/N 853Cancelled Nov 27, 1929 · Boyer Air Service Inc
Back to Sikeston, MO