AD 2006-18-13

Registered aircraft · 572

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

N721KJBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 5299N721MCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 691N721RHRh · Wilmington, DEBuilt 2003 · S/N 5010N727PRCorporate Wings LLC · Cleveland, OHBuilt 2000 · S/N 613N727SJDataone Systems LLC · Dallas, TXBuilt 2012 · S/N 5388N727TEMillrock Aviation Financial LLC · Danbury, CTBuilt 2008 · S/N 5223N728ECChouest Air Inc · Cut Off, LABuilt 2013 · S/N 5439N73RPTransportation Holdings IV LLC · Dallas, TXBuilt 2015 · S/N 5528N73ZZGlobal Aircraft II LLC · Eden Prairie, MNBuilt 1999 · S/N 593N740SS740ss LLC · Tooele, UTBuilt 1997 · S/N 532N74VZRegistered aircraftBuilt 2020 · S/N 5619N750LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 5096N751LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5244N75CCNbi LLC · New Bremen, OHBuilt 2005 · S/N 5065N75RPTransportation Holdings III LLC · Dallas, TXBuilt 2014 · S/N 5460N75TFBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 5333N765ATSapphire No5 LLC · Westlake Village, CABuilt 2004 · S/N 5063N766PSPts Air LLC · Richmond Heights, OHBuilt 1997 · S/N 509N767CHAi5278 LLC · Southlake, TXBuilt 2010 · S/N 5278N767CWN767cw LLC · Camden, DEBuilt 1997 · S/N 520N768JJBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 5217N769WECd 321 LLC · Austin, TXBuilt 2004 · S/N 5048N76VZRegistered aircraftBuilt 2020 · S/N 5623N772BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5582N776MAGlf5 629 LLC · Wilmington, DEBuilt 2001 · S/N 629N776RBFlower In The Field Av LLC · Santa Monica, CABuilt 1999 · S/N 585N777KLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5421N777YJBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5403N780CRCmr III LLC · Chicago, ILBuilt 2019 · S/N 5594N780EAkfl3 LLC · Farmingdale, NYBuilt 2009 · S/N 5258N780KSMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2005 · S/N 5091N780WGulfstream Gv-530 LLC · Wilmington, DEBuilt 1997 · S/N 530N785QSSavannah Belle LLC · Santa Cruz, CABuilt 2007 · S/N 5157N786JMPated LLC · Wilmington, DEBuilt 1999 · S/N 502N786NMCd 321 LLC · Austin, TXBuilt 1997 · S/N 522N787GPMalibu Consulting Corp · Beverly Hills, CABuilt 2001 · S/N 655N789LRNordlys LLC · Bedford, NHBuilt 2006 · S/N 5100N793MGHaupt LLC · Jupiter, FLBuilt 2009 · S/N 5263N795CRTime 2 Fly 2.0 LLC · Richmond, VABuilt 2014 · S/N 5474N795SPLockton Enterprises Inc · Kansas City, MOBuilt 2013 · S/N 5448N799SPPnc Bank National Association · Boise, IDBuilt 2017 · S/N 5568N7SESteven Brothers Aviation LLC · Wichita, KSBuilt 2005 · S/N 5088N800JHJ&J Aviation LLC · Crested Butte, COBuilt 2005 · S/N 5073N801ASRegistered aircraftBuilt 2005 · S/N 5097N801HHHogs Head Air II LLC · New York, NYBuilt 2001 · S/N 656N803HHHogs Head Air III LLC · New York, NYBuilt 2002 · S/N 665N803TMTai Leasing Inc · Mckinney, TXBuilt 2008 · S/N 5226N808JGTwo Weeks Notice LLC · Miami Lakes, FLBuilt 2000 · S/N 598N809DATrt Equity Advisors LLC · Dallas, TXBuilt 2010 · S/N 5269N80ADArcadia Leasing LLC · Arcadia, WIBuilt 2016 · S/N 5539
Back to AD 2006-18-13