AD 2016-08-20

Registered aircraft · 309

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-20')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-20')
  ORDER BY 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.

N195GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9974N19NLWabel Brad · Boerne, TXBuilt 2018 · S/N 8593N204WBAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9965N208SHAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7644N209LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4960N211LPHeliquest LLC · Greenville, SCBuilt 2015 · S/N 8181N212HKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4703N213SHAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7651N216AHBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2024 · S/N 9665N216SHAir Methods LLC · Greenwood Village, COS/N 7674N222SHAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7943N223DECdv Se Properties LLC · Grand Rapids, MIBuilt 2019 · S/N 8693N223SHAir Methods LLC · Greenwood Village, COS/N 7953N22TZKestrel Holdings LLC · Portland, ORBuilt 2014 · S/N 8016N230TJAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7966N231SHAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7993N232TLAirbus Helicopters Inc · Grand Prairie, TXS/N 10011N237SHAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 8005N239SHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8100N240SHAir Methods LLC · Greenwood Village, COS/N 8105N242SHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8120N244SHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8157N245AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7154N247KD130h LLC · Springville, UTBuilt 2013 · S/N 7758N252TFFertitta Entertainment Holdings LLC · Houston, TXBuilt 2019 · S/N 8665N254DMBarnyard LLC · Missoula, MTBuilt 2022 · S/N 9211N254GRMed-Trans Corp · Denton, TXBuilt 2025 · S/N 9742N255RMCgcpr LLC · Canovanas, PRBuilt 2009 · S/N 4855N259AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7050N267RCBank Of Utah Trustee · Salt Lake City, UTS/N 7393N301ATAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2022 · S/N 9213N301BFEclipse One LLC · Lindon, UTBuilt 2016 · S/N 8245N302SCUsaircraft Inc · Newark, DEBuilt 2002 · S/N 3564N306LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7116N30EZHover Air LLC · Anchorage, AKFirst renewal noticeBuilt 2011 · S/N 7285N317AMAir Methods LLC · Greenwood Village, COBuilt 2002 · S/N 3506N322GMAdrenaline Rush LLC · Missoula, MTBuilt 2015 · S/N 8159N325AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4631N325WFWfp Aviation Holdings LLC · Midland, TXBuilt 2015 · S/N 8168N327CHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8095N328CHAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7328N329AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4645N331MMHelicopter Holdings LLC · Hennepin, ILFirst renewal noticeS/N 8379N332AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4658N335AMAir Methods LLC · Greenwood Village, COFirst renewal noticeBuilt 2010 · S/N 7040N336AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4785N339AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7267N341AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7232N344AMFirst Citizens Bank & Trust Company · Morristown, NJBuilt 2011 · S/N 7235N353AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4996
Back to AD 2016-08-20