Skip to content

Mtw Aerospace Inc

Earlier aircraft under this name · 50

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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_name = 'MTW AEROSPACE INC' OR list_contains(d.other_registrant_names, 'MTW AEROSPACE INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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_name = 'MTW AEROSPACE INC' OR list_contains(d.other_registrant_names, 'MTW AEROSPACE INC')
  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.

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_name = 'MTW AEROSPACE INC' OR list_contains(d.other_registrant_names, 'MTW AEROSPACE INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N811AMBritish Aerospace BAE 125 SERIES 800A · S/N NA0444Cancelled Jan 7, 2026 · Montgomery, AL N750FCBeech 100 · S/N B-58Cancelled Sep 18, 2024 · Montgomery, AL N376MWRaytheon B300 · S/N FL376Cancelled Jun 10, 2024 · Montgomery, AL N21NVLearjet 60 · S/N 268Cancelled Feb 1, 2021 · Montgomery, AL N7734TLearjet 60 · S/N 139Cancelled Feb 1, 2021 · Built 1998 · Montgomery, AL N24GJBeech C90 · S/N LJ-769Cancelled Jan 22, 2019 · Built 1978 · Montgomery, AL N539BALearjet 31 · S/N 033DCancelled Dec 15, 2018 · Built 1995 · Montgomery, AL N333PPiper PA-31T · S/N 31T-8020002Cancelled Apr 3, 2018 · Built 1979 · Montgomery, AL N1900LBeech 1900D · S/N UE-185Cancelled Dec 7, 2017 · Built 1995 · Montgomery, AL N3KFBeech C90 · S/N LJ-530Cancelled Jun 27, 2017 · Registration expired, pending cancellation · Built 1971 · Montgomery, AL N8783Learjet 60 · S/N 006Cancelled Jun 27, 2017 · Built 1993 · Montgomery, AL N900LHDornier Luftfahrt DO 328-100 · S/N 3014Cancelled Jun 27, 2017 · Built 1994 · Montgomery, AL N801BBCessna 550 · S/N 550-0801Cancelled Dec 28, 2016 · Built 1997 · Montgomery, AL N1900KBeech 1900D · S/N UE-152Cancelled Nov 2, 2016 · Built 1995 · Montgomery, AL N1900TRaytheon 1900D · S/N UE-246Cancelled Nov 2, 2016 · Built 1996 · Montgomery, AL N224SWEmbraer EMB-120ER · S/N 120.294Cancelled Nov 1, 2016 · Exported to Isle Of Man · Built 1995 · Montgomery, AL N561HHCessna 560XL · S/N 560-5161Cancelled Oct 27, 2016 · Montgomery, AL N6FRCessna 550 · S/N 550-0828Cancelled Oct 27, 2016 · Built 1997 · Montgomery, AL N157PABeech 1900C · S/N UB56Cancelled Mar 18, 2016 · First renewal notice · Built 1986 · Montgomery, AL N190YVBeech 1900D · S/N UE-190Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1995 · Montgomery, AL N550AKGates Learjet 55 · S/N 045Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1982 · Montgomery, AL N522EMBeech C90 · S/N LJ-902Cancelled Oct 2, 2014 · Built 1980 · Montgomery, AL N122GLBeech 1900C · S/N UC-122Cancelled Sep 5, 2014 · Built 1990 · Montgomery, AL N159YVBeech 1900D · S/N UE-159Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1995 · Montgomery, AL N139LCFairchild SA227-AC · S/N AC-732Cancelled Jul 16, 2012 · Built 1989 · Montgomery, AL N386PHFairchild SA227-AC · S/N AC-597Cancelled Jul 16, 2012 · Built 1984 · Montgomery, AL N16GHBritish Aerospace BAE 125 SERIES 800A · S/N 258065Cancelled May 14, 2012 · Built 1986 · Montgomery, AL N237YVBeech 1900D · S/N UE-237Cancelled Feb 10, 2012 · Built 1996 · Montgomery, AL N163YVBeech 1900D · S/N UE-163Cancelled Jun 9, 2010 · Built 1995 · Montgomery, AL N98GFPiper PA-31T1 · S/N 31T-8004009Cancelled Sep 16, 2008 · Montgomery, AL N218ASEmbraer EMB-120ER · S/N 120.015Cancelled Jul 18, 2008 · Built 1986 · Montgomery, AL N151ASCessna 500 · S/N 500-0183Cancelled Aug 24, 2007 · Triennial form not returned · Montgomery, AL N238ASEmbraer EMB-120RT · S/N 120.053Cancelled Aug 24, 2007 · Triennial form not returned · Built 1987 · Montgomery, AL N345DFPiper PA-31T · S/N 31T-7820088Cancelled Aug 24, 2007 · Built 1978 · Montgomery, AL N77VJLearjet 23 · S/N 23-041Cancelled May 19, 2007 · Triennial form not returned · Built 1965 · Montgomery, AL N36HJLearjet 35A · S/N 427Cancelled Mar 28, 2007 · Built 1981 · Montgomery, AL N264CAEmbraer EMB-120RT · S/N 120.256Cancelled Oct 5, 2006 · Built 1992 · Montgomery, AL N31168Fairchild SA227-AC · S/N AC-599Cancelled Jun 1, 2006 · Triennial form not returned · Montgomery, AL N4392WBeech A100 · S/N B-192Cancelled Apr 6, 2006 · Triennial form not returned · Built 1974 · Montgomery, AL N196CFLearjet 24B · S/N 186Cancelled Feb 21, 2006 · Triennial form not returned · Built 1969 · Montgomery, AL N915USLearjet 24B · S/N 24-189Cancelled Feb 21, 2006 · Triennial form not returned · Built 1976 · Montgomery, AL N229EMBeech C-12C · S/N 77-22948Cancelled Feb 3, 2006 · Triennial form not returned · Montgomery, AL N95ACSwearingen SA226-T(B) · S/N T-381Cancelled Dec 16, 2005 · Built 1980 · Montgomery, AL N66MFPiper PA-42-720 · S/N 42-5501009Cancelled Oct 26, 2005 · Triennial form not returned · Built 1983 · Montgomery, AL N740EJGates Lear Jet 24B · S/N 222Cancelled Jul 19, 2005 · Triennial form not returned · Built 1970 · Montgomery, AL N120AXEmbraer EMB-120ER · S/N 120.164Cancelled May 12, 2005 · Triennial form not returned · Built 1989 · Montgomery, AL N28CKLearjet 25 · S/N 045Cancelled Apr 7, 2005 · Triennial form not returned · Montgomery, AL N263ASEmbraer EMB-120RT · S/N 120.157Cancelled Mar 23, 2005 · Built 1989 · Montgomery, AL N3034BLearjet 24 · S/N 176Cancelled Jan 31, 2005 · Triennial form not returned · Montgomery, AL N234UMCessna 500 · S/N 500-0105Cancelled Nov 23, 2004 · Triennial form not returned · Built 1973 · Montgomery, AL

Back to Mtw Aerospace Inc