AD 2018-16-08

Registered aircraft · 109

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:2018-16-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-16-08')
  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.

N45BZLogistics Business Services LLC · Cheshire, CTBuilt 2012 · S/N 22284N45SHSunflower Aviation LLC · Greenleaf, KSBuilt 2007 · S/N 22046N48SHIndiana Helicopters LLC · Fort Wayne, INBuilt 2010 · S/N 22214N508CFAerotrust Services Corp Trustee · Wilmington, DEBuilt 2001 · S/N 11103N50BReina Capital II LLC · Miami, FLBuilt 2011 · S/N 22234N517QAAltus Aviation Management · Las Vegas, NVBuilt 2018 · S/N 22708N530KSBristow LLC · Lake Charles, LABuilt 2006 · S/N 11694N531HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2016 · S/N 22366N567HBCj Leasing LLC Trustee · Lakeland, FLBuilt 2010 · S/N 11780N57HRSeminole Tribe Of Florida DBA · Davie, FLBuilt 2013 · S/N 22317N59PDiesel Acquisitions LLC · Milpitas, CABuilt 2007 · S/N 22036N59ZXAs 355 LLC · Gay, GABuilt 2006 · S/N 11683N5UVPortlock Aviation LLC · Mansfield, TXS/N 11150N613HAHa 109e LLC · Flushing, NYBuilt 2006 · S/N 11674N618HRBoardwalk Air I LLC · Atlantic City, NJBuilt 2020 · S/N 22419N621SCSouth Bay Helicopter Service Inc · Hayward, CAS/N 22078N631HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2016 · S/N 22349N65CJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 11051N68NMNorth Memorial Healthcare · Brooklyn Center, MNBuilt 2008 · S/N 22076N69KGBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2006 · S/N 22021N6JEEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11095N6VZLeonardo Helicopters US Corp · Philadelphia, PABuilt 2000 · S/N 11099N71NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2009 · S/N 22146N72HRSeminole Tribe Of Florida DBA · Davie, FLBuilt 2019 · S/N 22396N731HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2025 · S/N 22474N73AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 22004N749SDRocklyn 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 11088N80NYWgb 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 11145N890PAAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedS/N 22422N901CMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11611N901EMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11614N901LFLifeflight 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 11627
Back to AD 2018-16-08