Skip to content

Air Methods Corp

Earlier aircraft under this name · 55

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 = 'AIR METHODS CORP' OR list_contains(d.other_registrant_names, 'AIR METHODS CORP') 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 = 'AIR METHODS CORP' OR list_contains(d.other_registrant_names, 'AIR METHODS CORP')
  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 = 'AIR METHODS CORP' OR list_contains(d.other_registrant_names, 'AIR METHODS CORP')
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.

N546AMEurocopter AS 350 B2 · S/N 4321Cancelled Apr 18, 2023 · Exported to India · Built 2007 · Greenwood Village, CO N558AMEurocopter France AS350B2 · S/N 4377Cancelled Dec 5, 2022 · Exported to Brazil · Built 2007 · Greenwood Village, CO N511SLAgusta A119 · S/N 14028Cancelled Nov 1, 2022 · Exported to Canada · Built 2002 · Greenwood Village, CO N556AMEurocopter AS 350 B2 · S/N 4369Cancelled Oct 6, 2022 · Exported to New Zealand · Built 2007 · Greenwood Village, CO N126LNEurocopter AS 350 B2 · S/N 4147Cancelled Jun 9, 2022 · Exported to Canada · Built 2006 · Greenwood Village, CO N397LGEurocopter AS 350 B3 · S/N 3268Cancelled Feb 9, 2022 · Exported to Papua New Guinea · Built 2000 · Greenwood Village, CO N129LNEurocopter France AS350B2 · S/N 4011Cancelled Dec 20, 2021 · Exported to Canada · Built 2005 · Greenwood Village, CO N430UHBell 430 · S/N 49056Cancelled Nov 18, 2021 · Exported to South Africa · Built 1999 · Greenwood Village, CO N549AMEurocopter AS 350 B2 · S/N 4339Cancelled Nov 15, 2021 · Exported to Canada · Built 2007 · Greenwood Village, CO N127LNEurocopter AS 350 B2 · S/N 4149Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 2006 · Greenwood Village, CO N394LGEurocopter AS 350 B3 · S/N 3134Cancelled Aug 26, 2021 · Exported to Canada · Built 1998 · Greenwood Village, CO N165AMEurocopter AS 350 B3 · S/N 3686Cancelled Apr 14, 2021 · Exported to Canada · Built 2003 · Greenwood Village, CO N135LGEurocopter Deutschland EC 135 P2+ · S/N 0731Cancelled Nov 12, 2019 · Built 2008 · Greenwood Village, CO N74317Eurocopter AS 350 B3 · S/N 4317Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2007 · Englewood, CO N238BKMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7238Cancelled Jul 16, 2019 · Registration expired, pending cancellation · Built 1991 · Greenwood Village, CO N620PABell Helicopter Textron Canada 407 · S/N 54610Cancelled May 1, 2019 · Registration expired, pending cancellation · Built 2015 · Englewood, CO N557UHBell 430 · S/N 49120Cancelled Mar 28, 2019 · Exported to Canada · Built 2006 · Greenwood Village, CO N123LNEurocopter AS 350 B2 · S/N 4115Cancelled Dec 7, 2018 · Exported to New Zealand · Built 2006 · Greenwood Village, CO N202AEEurocopter AS 350 B2 · S/N 3343Cancelled Nov 20, 2018 · Exported to New Zealand · Built 2000 · Greenwood Village, CO N41299Eurocopter AS 350 B2 · S/N 3806Cancelled Oct 22, 2018 · Exported to New Zealand · Built 2004 · Greenwood Village, CO N122SLMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7207Cancelled May 10, 2018 · Built 1989 · Greenwood Village, CO N135MEEurocopter Deutschland EC135P1 · S/N 0009Cancelled May 4, 2018 · First renewal notice · Built 1996 · Englewood, CO N352LNEurocopter AS 350 B2 · S/N 3728Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 2003 · Englewood, CO N911MZMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7098Cancelled Dec 20, 2017 · Exported to New Zealand · Built 1986 · Greenwood Village, CO N125ECMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7065Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1986 · Englewood, CO N350GREurocopter AS 350 B2 · S/N 3140Cancelled Aug 28, 2017 · Exported to New Zealand · Built 1998 · Englewood, CO N390LGAmerican Eurocopter AS350B3 · S/N 7595Cancelled Jun 6, 2016 · First renewal notice · Built 2013 · Englewood, CO N912TGMesserschmitt BK 117 B-1 · S/N 7174Cancelled Dec 23, 2015 · Exported to New Zealand · Built 1988 · Englewood, CO N163BKMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7063Cancelled Dec 7, 2015 · Exported to New Zealand · Englewood, CO N911KDMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7237Cancelled Oct 1, 2015 · Exported to New Zealand · Built 1991 · Englewood, CO N117CJMesserschmitt-Boelkow-Blohn MBB-BK117 A-4 · S/N S-7051Cancelled May 18, 2015 · Built 1984 · Englewood, CO N9024ZMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7134Cancelled Mar 10, 2015 · Exported to Colombia · Englewood, CO N211SLMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7201Cancelled Dec 23, 2014 · Exported to New Zealand · Built 1989 · Englewood, CO N222MNBell 222U · S/N 47534Cancelled Dec 9, 2014 · Exported to Australia · Built 1984 · Englewood, CO N952AMEurocopter AS 350 B2 · S/N 3574Cancelled Jun 23, 2014 · Exported to New Zealand · Built 2002 · Englewood, CO N330SLMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7216Cancelled Jun 2, 2014 · Exported to New Zealand · Built 1990 · Englewood, CO N117LNEurocopter AS 350 B2 · S/N 3700Cancelled Apr 15, 2014 · Exported to New Zealand · Built 2003 · Englewood, CO N911SXMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7232Cancelled Mar 25, 2014 · Exported to New Zealand · Built 1991 · Englewood, CO N419MABell 222UT · S/N 47518Cancelled Sep 10, 2013 · Built 1984 · Englewood, CO N431MABell 222U · S/N 47504Cancelled Jun 11, 2013 · Built 1983 · Englewood, CO N569AMBell 222U · S/N 47569Cancelled Jun 11, 2013 · Built 1988 · Englewood, CO N10UMMesserschmitt BK 117 B-1 · S/N 7231Cancelled Jun 5, 2013 · Built 1990 · Englewood, CO N118WSMesserschmitt BK 117 · S/N S-7030Cancelled Jun 5, 2013 · First renewal notice · Built 1984 · Englewood, CO N601EHMesserschmitt BK 117 B-1 · S/N 7181Cancelled Jun 5, 2013 · First renewal notice · Built 1988 · Englewood, CO N587MGBell 222U · S/N 47566Cancelled Feb 22, 2013 · Built 1987 · Englewood, CO N913AMMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7068Cancelled Feb 12, 2013 · Built 1985 · Englewood, CO N136AEMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7234Cancelled Mar 14, 2012 · Exported to Canada · Built 1991 · Englewood, CO N550SLEurocopter Deutschland MBB-BK 117-B2 · S/N 7139Cancelled Aug 18, 2011 · Built 1987 · Englewood, CO N412LGBell 412 · S/N 33209Cancelled Mar 22, 2011 · Exported to Germany · Built 1990 · Englewood, CO N404EMBell 222UT · S/N 47514Cancelled Nov 18, 2010 · Built 1984 · Englewood, CO

Back to Air Methods Corp