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.

N199THTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5113N1AMMeruelo Group LLC · Downey, CABuilt 2000 · S/N 623N1ARAl Rushaid Aviation Ltd · Jacksonville, FLBuilt 2000 · S/N 9061N1BBBollinger Enterprises LLC · New Orleans, LABuilt 2001 · S/N 660N1CCTonkawa Inc · Minnetonka, MNBuilt 2013 · S/N 5419N1CFNorthern Holdings LLC · Queensbury, NYBuilt 2012 · S/N 9519N1DCBlue Star Management Services Corp · Frisco, TXBuilt 2001 · S/N 651N1FEFederal Express Leasing Corp · Memphis, TNBuilt 2017 · S/N 9815N1HCHardesty-Gulfstream LLC · Tulsa, OKBuilt 2003 · S/N 5009N1NKBase Aviation LLC · Jupiter, FLBuilt 2015 · S/N 5534N1PGProcter & Gamble Leasing LLC · Cincinnati, OHBuilt 2017 · S/N 6260N1RPPts As LLC · Reading, PABuilt 2013 · S/N 5458N1WWAmbleur II LLC · Palm Beach Gardens, FLBuilt 2017 · S/N 9808N2000STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6133N200KPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5170N203BHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 60184N204AMercury International Holdings LLC · Salt Lake City, UTBuilt 2011 · S/N 5341N205ELInvemed Securities Inc · New York, NYBuilt 2006 · S/N 9201N20RCBristol Air LLC · Missoula, MTBuilt 2017 · S/N 6300N20RGBsr Aviation LLC · Crestwood, KYBuilt 2006 · S/N 9190N20SQFlying Plane LLC · Purchase, NYBuilt 2012 · S/N 9491N2120Wilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 5468N2121JSbij LLC · Wilmington, DEBuilt 2015 · S/N 9685N212APOneida II LLC · Wilmington, DEBuilt 2000 · S/N 9063N214MDHdb Aviation LLC · Farmers Branch, TXBuilt 2004 · S/N 9152N215BBBl Charter LLC · Pittsfield, MABuilt 2000 · S/N 610N215TMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 9719N218ALCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 9260N218HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5587N218JJRegistered aircraftBuilt 2010 · S/N 9403N219BYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 9775N219GXCmc 9256 LLC · Lewes, DEBuilt 2007 · S/N 9256N21EHRegistered aircraftBuilt 2007 · S/N 5141N21UGiven To Fly Holdings LLC · West Chicago, ILS/N 5379N21UCUnited Co · Bristol, VABuilt 2014 · S/N 5484N220FBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 9011N221FFGayas LLC · Lowell, MABuilt 2009 · S/N 5221N222GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5222N222LXTrans Exec Air Service Inc · Van Nuys, CABuilt 2001 · S/N 633N223AEmmanuel Group · North Wilkesboro, NCS/N 5583N225BKCxair Holdings Inc · Stuart, FLBuilt 2018 · S/N 9876N225ELThesun LLC · Miami, FLBuilt 1999 · S/N 587N226SJSsc Asset Co II LLC · Irvine, CABuilt 2001 · S/N 9095N226SLSpencer Talia Aviation LLC · Los Angeles, CABuilt 2001 · S/N 628N228SKSkechers U S A Inc · Manhattan Beach, CABuilt 2014 · S/N 9643N228SSSws Venture Capital Services LLC · Los Angeles, CABuilt 2003 · S/N 9124N228ZDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6126N2291RIngersoll Rand Inc · Davidson, NCBuilt 2017 · S/N 5565N229KMMike Post Productions Inc · Burbank, CABuilt 1996 · S/N 504N22TRegistered aircraftBuilt 2015 · S/N 6151
Back to AD 2011-22-01