AD 2011-22-01

Registered aircraft · 1,167

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

N588DZGrowth Holdings LLC · Broken Arrow, OKBuilt 2010 · S/N 5272N588GGulfstream Aerospace Corporation · Savannah, GABuilt 2014 · S/N 5488N588PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5467N588TNTannjets Aerospace II LLC · Fort Lauderdale, FLBuilt 2006 · S/N 5109N590EAurora Aircraft LLC · Waterford, MIBuilt 2001 · S/N 9105N590MSMartin Sprocket & Gear Inc · Arlington, TXBuilt 2000 · S/N 9042N591BCInternational Bank Of Commerce · Laredo, TXBuilt 1999 · S/N 577N595ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9588N595EXTiny Bronco LLC · Newark, DEBuilt 2007 · S/N 5179N595MPEoc Consulting LLC · Salt Lake City, UTBuilt 2018 · S/N 9822N595TGPlatinum Equity LLC · Beverly Hills, CABuilt 2016 · S/N 6246N599CETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9515N599HRegistered aircraftBuilt 2003 · S/N 5016N599HGSunshine Sky Aviation LLC · Doral, FLBuilt 2000 · S/N 599N599TRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 668N59DBConstellation Productions Inc · Jacksonville, FLBuilt 2000 · S/N 9073N59JEIn59je LLC · New York, NYBuilt 1998 · S/N 559N5BLBlm Aviation LLC · Dover, DEBuilt 2009 · S/N 5227N5PDMid-Atlantic Aviation III LLC · Saint Petersburg, FLBuilt 2012 · S/N 5410N5SNDodson International Parts Inc · Rantoul, KSBuilt 2006 · S/N 5134N600JVJsv Leasing III LLC · Orlando, FLBuilt 2014 · S/N 9664N600NBCisco Aero - N9781 LLC · Cisco, TXBuilt 2016 · S/N 9781N600WGWeldon Granger J · Houston, TXBuilt 1998 · S/N 545N603ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55127N603BGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 5249N603JRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5535N608CLCassandra Lee Flight Operations LLC · Las Vegas, NVBuilt 2009 · S/N 5262N609AKPeck Ventures LLC · Henderson, NVBuilt 2009 · S/N 9346N609RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9653N60BJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9402N60CCRegistered aircraftBuilt 2016 · S/N 9762N60EWSolomon Mark Trustee · Wilmington, DEBuilt 1999 · S/N 501-0319N60PASun Meridian Riverside LLC · Brea, CABuilt 1998 · S/N 561N610AWMs Hawker LLC · Farmington Hills, MIBuilt 2004 · S/N 9143N610CXGlobal 9066 LLC · Wilmington, DEBuilt 2000 · S/N 9066N610SWSteel Services Ltd · New York, NYBuilt 2016 · S/N 9733N611BFAmb Group LLC · Atlanta, GABuilt 2016 · S/N 9774N611GJBank Of Utah Trustee · Salt Lake City, UTS/N 9569N611JMJfm Inc · Oak Brook, ILBuilt 2003 · S/N 5001N612MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5159N61318Wilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 650N613AQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 5181N613BRRegistered aircraftBuilt 1997 · S/N 531N613HBSigma Equity LLC · San Francisco, CABuilt 2016 · S/N 6232N615TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9675N616AFAmeriprise Financial Inc · Oxford, CTBuilt 2010 · S/N 5295N616CAPioneer Hi-Bred International Inc · Wilmington, DEBuilt 2019 · S/N 5601N616DCDjw Aviation III LLC · Monterey, CABuilt 2008 · S/N 9296N616RKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5361N617EAMeridien Aircraft Holdings LLC · Greenwich, CTBuilt 2002 · S/N 693
Back to AD 2011-22-01