AD 2016-25-20

Registered aircraft · 1,263

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-25-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-25-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.

N11QZNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2008 · S/N 4663N11TQNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2014 · S/N 8044N11UQAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8053N11XQAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8113N11YQAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8156N120AMAir Methods LLC · Greenwood Village, COBuilt 2024 · S/N 9596N120PDCity Of Albuquerque · Albuquerque, NMBuilt 2024 · S/N 9503N121RGLone Star Land & Cattle Co · Livingston, MTBuilt 2018 · S/N 8517N1228HAirbus Helicopters Inc · Grand Prairie, TXS/N 9951N122AHNorton Basin Services · Nome, AKBuilt 2023 · S/N 9509N1231ATiny Bubbles Aviation Inc · Pacoima, CABuilt 2003 · S/N 3682N123RTMather Air LLC · Paris, KYBuilt 2004 · S/N 3841N124LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4130N124TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4405N125APAustin Police Dept · Pflugerville, TXBuilt 2022 · S/N 9282N125CLHillsboro Aviation Inc · Hillsboro, ORBuilt 2015 · S/N 7987N125DAPayne David L Trustee · Saint Louis, MOBuilt 2022 · S/N 9154N125EPEnbridge Energy Co Inc · Houston, TXBuilt 2019 · S/N 8650N125HDUS Helicopters Inc · Marshville, NCBuilt 2014 · S/N 7899N125NBCisco Aero LLC · Grass Range, MTBuilt 2022 · S/N 9318N125NYOffice Of Vector Surveillance And Control · New York, NYBuilt 2019 · S/N 8745N125PDCity Of Albuquerque · Albuquerque, NMBuilt 2019 · S/N 8667N125SCStandard Aero (Alliance) Inc · Maryville, TNBuilt 2005 · S/N 3904N126BHBhi Holdings #2 LLC · Ontario, ORBuilt 2012 · S/N 7403N126PJHelibro LLC · Red Bluff, CABuilt 2010 · S/N 7039N127ABApexheli Oregon Inc · Florence, ORBuilt 2000 · S/N 3331N127BHBhi Holdings #3 LLC · Ontario, ORBuilt 2013 · S/N 7675N127CHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 8189N127PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 7180N129NBPathfinder Leasing LLC · Anchorage, AKBuilt 2017 · S/N 8397N129TVUS Helicopters Inc · Marshville, NCBuilt 1996 · S/N 2897N12FQN12fq LLC · Helena, MTBuilt 2003 · S/N 3726N12NNAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2008 · S/N 4579N12NYNew York Aircam Corp · Woodbury, NYBuilt 2018 · S/N 8594N12YJTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4443N130Red Skies LLC · Kalispell, MTBuilt 2014 · S/N 8019N1302TTemsco Helicopters Inc · Ketchikan, AKBuilt 2016 · S/N 8258N1303TTemsco Helicopters Inc · Ketchikan, AKBuilt 2016 · S/N 8260N1308TNs Air Leasing LLC · Wilmington, DEBuilt 2016 · S/N 8193N1309TNs Air Leasing LLC · Wilmington, DEBuilt 2016 · S/N 8215N130ADEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 3515N130AHHelio Helicopter Co LLC · Manchester, NHS/N 3862N130BUOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7132N130CLOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7499N130CRRomana Aircraft Inc · High Point, NCBuilt 2007 · S/N 4271N130CSIndiana Helicopters LLC · Fort Wayne, INBuilt 2013 · S/N 7660N130CZOrbic Air LLC · Burbank, CABuilt 2006 · S/N 4060N130EEBuckeye Leasing LLC · Shreveport, LABuilt 2011 · S/N 7190N130GBBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8742N130GCMonarch Enterprises Inc · Kirkland, WABuilt 2002 · S/N 3562
Back to AD 2016-25-20