AD 2016-18-18

Registered aircraft · 146

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-18-18')
    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-18-18')
  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.

N716LPTurbines Ltd · West Point, NES/N 7167N71NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2009 · S/N 22146N7242NMaverick Jet Leasing Inc · Wilmington, DEBuilt 1986 · S/N 7355N72HRSeminole Tribe Of Florida DBA · Davie, FLBuilt 2019 · S/N 22396N731HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2025 · S/N 22474N737PGGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1991 · S/N 7659N73AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 22004N745HAPrivate LLC · Kalispell, MTRegistration ineffective or invalidS/N 7413N749SDRocklyn Leasing LLC · Duluth, GABuilt 2002 · S/N 11155N75GGA109s LLC · Pinecrest, FLBuilt 2009 · S/N 22141N770PATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 22022N786MKAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 22394N789RTIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 22257N7ADEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11098N7UCRegistration Pending · Greenwood Village, CORegistration pendingBuilt 2000 · S/N 11088N800WKDiamond Helicopters LLC · Los Angeles, CAFirst renewal noticeS/N 7341N80NYWgb Holdings LLC · Sparta, NJS/N 11214N814WFRed Hawk Management LLC · Ocilla, GABuilt 2011 · S/N 22237N81NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2008 · S/N 22086N820FTBristow LLC · Lake Charles, LABuilt 2007 · S/N 11701N827KUEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11609N85KVKhosla Ventures LLC · San Jose, CABuilt 2002 · S/N 11145N876RJTre Aviation Corp · Wilmington, DES/N 7291N890PAAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedS/N 22422N897BCIntersouth Inc · Santo DomingoS/N 7631N8UFIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1985 · S/N 7268N901CMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11611N901EMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11614N901HCIhc Health Services Inc DBA · Salt Lake City, UTBuilt 1988 · S/N 10033N901LFLifeflight Of Maine LLC · Bangor, MEBuilt 2019 · S/N 22400N901WMLifeflight Of Maine · Bangor, MEBuilt 2021 · S/N 22429N901XMLifeflight Of Maine LLC · Bangor, MEBuilt 2020 · S/N 22422N901YMLifeflight Of Maine LLC · Bangor, MEBuilt 2018 · S/N 22375N90NMNorth Memorial Health Care · Minneapolis, MNBuilt 2007 · S/N 22044N910LBBristow LLC · Lake Charles, LABuilt 2006 · S/N 11682N91LFInternational Defense & Aerospace Group LLC · Glen Mills, PABuilt 2002 · S/N 11509N91SVSaint Vincent Mercy Medical Center · Toledo, OHS/N 11627N921LFLife Flight Network LLC · Aurora, ORBuilt 2002 · S/N 11142N922LFEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11149N923LFEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2003 · S/N 11220N92LFEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2004 · S/N 11604N94AHEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11081N95RZSt Vincent Mercy Medical Center · Toledo, OHBuilt 2002 · S/N 11147N962JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 22047N963JERegistered aircraftAssigned (import), pending cancellationS/N 22016N9CWGran Cosecha LLC · Lake Wales, FLBuilt 2008 · S/N 11732
Back to AD 2016-18-18