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.

N750LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 5096N751LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5244N757RRDirectional Capital LLC · Cleveland, OHBuilt 2016 · S/N 6213N75CCNbi 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 5333N75VBParamount Pictures Corp · Van Nuys, CABuilt 2007 · S/N 9247N765ATSapphire 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 5623N770AGUnited States Air Force · Hanscom Afb, MABuilt 2009 · S/N 9355N770KFKw770 LLC · Bozeman, MTBuilt 2016 · S/N 9749N771BKKaiser Aviation LLC · Waterford, MIBuilt 2010 · S/N 9382N772BETvpx 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 585N7777UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9591N777KLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5421N777YJBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5403N777ZHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6240N778ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6289N77NZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 9144N780CRCmr 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 655N787KJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2015 · S/N 9741N787NBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9527N788MMBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9599N789LRNordlys LLC · Bedford, NHBuilt 2006 · S/N 5100N78SDLiquid Aviation Inc · Del Mar, CABuilt 2017 · S/N 9765N793APCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 9454N793MGHaupt LLC · Jupiter, FLBuilt 2009 · S/N 5263N793XInvolo LLC · New York, NYBuilt 2014 · S/N 9605N795CRTime 2 Fly 2.0 LLC · Richmond, VABuilt 2014 · S/N 5474N795SPLockton Enterprises Inc · Kansas City, MOBuilt 2013 · S/N 5448N797CTCaterpillar Inc · Fort Worth, TXBuilt 2012 · S/N 9435N797KBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 9290N79999Bank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 6256N799BCDelta Air Lines Inc · Atlanta, GAS/N 55170N799GSSms 111 LLC · New York, NYBuilt 2006 · S/N 9192N799JRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60032
Back to AD 2011-22-01