OpenAirDocs.org
Malden, MO

Cancelled registrations · 39

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

N929DMAero Commander 200D · S/N 304Cancelled May 1, 2023 · Registration expired, pending cancellation · Built 1966 · Meyers 200 LLCN6600KGrumman Acft ENG Cor-Schweizer G-164B · S/N 383BCancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1978 · Krepps KurtisN37858Porterfield FP-65 · S/N 1005Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Turman PreyearN15213Waco YOC · S/N 4302Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1935 · Mitchell Charles L JrN8008JAg-Cat G-164BT500 · S/N 001BT500Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Ag-Cat CorpN519KCessna 310G · S/N 310G0154Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1962 · Nicks Aircraft Sales IncN10264Grumman G-164 · S/N 64Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1960 · Malden Ag-Craft IncN5307Grumman Acft ENG Cor-Schweizer G-164A · S/N 591Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1969 · S E M O Aviation IncN80361Beech D18S · S/N A-158Cancelled Oct 23, 2013 · Revoked, canceled · Built 1946 · Semo Aviation IncN633DNBeech E18S · S/N BA-100Cancelled Aug 6, 2013 · Revoked, canceled · Built 1955 · Semo Aviation IncN653GBeech D18S · S/N A-589Cancelled Aug 6, 2013 · Revoked, canceled · Built 1952 · Semo Aviation IncN7246Grumman Acft ENG Cor-Schweizer G-164A · S/N 917Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1972 · Semo Aviation IncN5914YPiper PA-23-250 · S/N 27-3072Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1965 · Nicks Aircraft Sales IncN4466YPiper PA-25-235 · S/N 25-4118Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1966 · Kelley Frank DN22942Cessna 150H · S/N 15068634Cancelled Aug 8, 2011 · Sale reported, pending cancellation · Built 1968N427SPSwearingen SA-226AT · S/N AT018Cancelled Oct 21, 2010 · Exported to Canada · River City Aviation IncN541EBeech D18S · S/N A-188Cancelled Aug 29, 2006 · Triennial form not returned · Built 1946 · Semco Aviation IncN103RCMitsubishi MU-2B-36 · S/N 673Cancelled Dec 30, 2005 · Built 1975 · River City Aviation IncN31XLPiper PA-31T2 · S/N 31T-8166003Cancelled Aug 3, 2004 · Triennial form not returned · Built 1981 · Falcon Communications IncN472TLBeech 58 · S/N TH1112Cancelled Dec 7, 1999 · Triennial form not returned · Ross Charlie F DBAN6MYWsk-Pzl-Mielec PZL-M-18 · S/N 1Z00502Cancelled Dec 3, 1996 · Exported to Chile · Krepps Kurtis MN63117Cessna 150M · S/N 15077115Cancelled Jun 3, 1991 · Triennial form not returned · Kraft RobertN55224Piper PA-34-200 · S/N 347350189Cancelled Mar 28, 1991 · Triennial form not returned · Nicks Aircraft Sales IncN7877QCessna 310Q · S/N 310Q0656Cancelled Nov 24, 1986 · Exported to Panama · Hopwood Reggie SN7519WPiper PA-28-180 · S/N 28-1436Cancelled Sep 13, 1982 · Norrid William EN297BKBeech D18S · S/N A-109Cancelled May 18, 1976 · Semo Aviation IncN6614BBeech G18S · S/N BA487Cancelled Sep 12, 1975 · Semo Aviation IncN313ABeech D18S · S/N A-257Cancelled Apr 11, 1974 · Built 1946 · Semo Aviation IncN28WBeech D18S · S/N A-185Cancelled Mar 31, 1974 · Semo Aviation IncN56058Boeing A75N1 · S/N 75-901Cancelled Dec 18, 1972 · Exported to Costa Rica · Kelley Frank D DBA American AviationN5371NBoeing A75N1 · S/N 754728Cancelled Dec 7, 1972 · Exported to Costa Rica · Kelley Frank D DBA American AviationN4650TEast V A RUSSELL GYROPL BR1 · S/N 1ECancelled Dec 10, 1970 · Registration revoked · Built 1964 · East V AN85342Aeronca 7AC · S/N 7AC-4081Cancelled Sep 8, 1970 · Built 1946 · Widner Guy LN5420NBoeing B75N1 · S/N 75-1188Cancelled Jun 30, 1970 · Semo Aviation IncN62179Consolidated Vultee BT-13A · S/N 5340Cancelled Jun 30, 1970 · Semo Aviation IncN3529NPiper J3C-65 · S/N 22760Cancelled Jun 22, 1970 · Tapley Harold CN1601SSnow S2C · S/N 1139-CCancelled Sep 10, 1964 · Semo Aviation IncN9717HSchweizer TG3A · S/N 72Cancelled May 2, 1957 · Exported to Canada · Dewald Robert MN65677Cessna T-50 · S/N 2426Cancelled Feb 17, 1956 · Built 1942 · Hay G Clifford
Back to Malden, MO