Skip to content

Air Methods LLC

Registered aircraft · 342

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'AIR METHODS LLC' OR list_contains(g.other_registrant_names, 'AIR METHODS LLC') ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'AIR METHODS LLC' OR list_contains(g.other_registrant_names, 'AIR METHODS LLC')
  ORDER BY g.n_number"

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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'AIR METHODS LLC' OR list_contains(g.other_registrant_names, 'AIR METHODS LLC')
ORDER BY g.n_number

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.

N101HFBell Helicopter Textron Canada 407 · S/N 53463Built 2000 · Greenwood Village, CO N101VUEurocopter Deutschland MBB-BK 117 C-2 · S/N 9039Built 2003 · Greenwood Village, CO N102HNEurocopter Deutschland EC135P1 · S/N 0159Built 2000 · Greenwood Village, CO N103VUEurocopter Deutschland MBB-BK 117 C-2 · S/N 9054Greenwood Village, CO N104VUEurocopter Deutschland EC 135 T2+ · S/N 0704Built 2008 · Greenwood Village, CO N105AMBell Helicopter Textron Canada 407 · S/N 54024Built 2010 · Greenwood Village, CO N105VUEurocopter Deutschland EC 135 T2+ · S/N 0724Built 2008 · Greenwood Village, CO N106VUAirbus Helicopters EC 130 T2 · S/N 7996Built 2014 · Greenwood Village, CO N108LNEurocopter AS 350 B3 · S/N 3959Greenwood Village, CO N108VUEurocopter Deutschland EC 135 P2+ · S/N 0509Built 2006 · Greenwood Village, CO N109LNEurocopter AS 350 B3 · S/N 3995Built 2005 · Greenwood Village, CO N110SLEurocopter Deutschland MBB-BK 117 C-2 · S/N 9302Built 2009 · Greenwood Village, CO N110VUEurocopter Deutschland EC 135 T2+ · S/N 0605Built 2007 · Greenwood Village, CO N113AMBell Helicopter Textron Canada 407 · S/N 54027Built 2010 · Greenwood Village, CO N116SKPilatus PC-12 · S/N 116Built 1995 · Greenwood Village, CO N118LNEurocopter AS 350 B3 · S/N 4214Built 2007 · Greenwood Village, CO N11FQEurocopter EC 130 T2 · S/N 7571Built 2013 · Greenwood Village, CO N11KQEurocopter EC 130 T2 · S/N 7723Built 2013 · Greenwood Village, CO N11UQAirbus Helicopters EC 130 T2 · S/N 8053Built 2015 · Greenwood Village, CO N11XQAirbus Helicopters EC 130 T2 · S/N 8113Built 2015 · Greenwood Village, CO N11YQAirbus Helicopters EC 130 T2 · S/N 8156Built 2015 · Greenwood Village, CO N120AMAirbus Helicopters AS350B3 · S/N 9596Built 2024 · Greenwood Village, CO N124LNEurocopter AS 350 B2 · S/N 4130Built 2006 · Greenwood Village, CO N129ARAgusta A109E · S/N 11125Built 2001 · Greenwood Village, CO N129JWPilatus PC-12/45 · S/N 129Built 1996 · Greenwood Village, CO N130KREurocopter EC 130 B4 · S/N 7317Built 2012 · Greenwood Village, CO N131LNEurocopter EC 130 B4 · S/N 4090Greenwood Village, CO N132LNEurocopter EC 130 B4 · S/N 3970Built 2005 · Greenwood Village, CO N133HNEurocopter France EC 130 B4 · S/N 7293Built 2011 · Greenwood Village, CO N133LNEurocopter EC 130 B4 · S/N 3983Built 2005 · Greenwood Village, CO N134AMEurocopter Deutschland EC 135 P2 · S/N 0324Built 2004 · Greenwood Village, CO N134LNEurocopter EC 130 B4 · S/N 3985Built 2005 · Greenwood Village, CO N135AMBell Helicopter Textron Canada 407 · S/N 54385Built 2013 · Greenwood Village, CO N135CJEurocopter Deutschland EC135T2 · S/N 0495Built 2006 · Greenwood Village, CO N135CMEurocopter Deutschland EC 135 P2+ · S/N 0706Built 2008 · Greenwood Village, CO N135EDEurocopter Deutschland EC 135 P2 · S/N 0335Built 2004 · Greenwood Village, CO N135LCEurocopter Deutschland EC135T2 · S/N 0296Built 2003 · Greenwood Village, CO N135LFEurocopter Deutschland EC 135 T2+ · S/N 0647Built 2008 · Greenwood Village, CO N135NKEurocopter Deutschland EC 135 P2+ · S/N 0480Built 2006 · Greenwood Village, CO N135TGEurocopter Deutschland EC135T2 · S/N 0298Built 2003 · Greenwood Village, CO N135TJEurocopter Deutschland EC 135 P2 · S/N 0329Built 2004 · Greenwood Village, CO N135WJEurocopter Deutschland EC 135 P2 · S/N 0287Built 2003 · Greenwood Village, CO N136KYEurocopter Deutschland EC 135 P2 · S/N 0494Greenwood Village, CO N136MFEurocopter Deutschland EC135T2 · S/N 0384Built 2005 · Greenwood Village, CO N136VAEurocopter Deutschland EC135T2 · S/N 0281Built 2003 · Greenwood Village, CO N137AMEurocopter Deutschland EC 135 P2 · S/N 0326Built 2004 · Greenwood Village, CO N137HNEurocopter EC 130 B4 · S/N 7371Built 2012 · Greenwood Village, CO N138HNEurocopter Deutschland EC 135 P2+ · S/N 0288Built 2003 · Greenwood Village, CO N138LNEurocopter Deutschland EC 135 P2+ · S/N 0352Built 2004 · Greenwood Village, CO N139TJEurocopter Deutschland EC 135 P2+ · S/N 0322Built 2004 · Greenwood Village, CO

Back to Air Methods LLC