AD 2011-23-07

Registered aircraft · 219

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-23-07')
    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-23-07')
  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.

N428JDDewberry Air LLC · Atlanta, GABuilt 2006 · S/N 210N42DH58dh LLC · Atlanta, GABuilt 2011 · S/N 250N445STNp Aviation II LLC · Atlanta, GABuilt 2005 · S/N 114N449BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 274N454THG200 Aviation LLC · Gentry, ARBuilt 2004 · S/N 096N468JJPdl Holdings Fl LLC · Tampa, FLBuilt 2005 · S/N 123N469DMNac Flight Service LLC · Madison, MSBuilt 2008 · S/N 257N479PRNellie Navigation LLC · Naples, FLBuilt 2000 · S/N 008N480JJJem Aviation III LLC · Thomasville, NCBuilt 2008 · S/N 270N500AGCd 321 LLC · Cypress, TXBuilt 2007 · S/N 158N501RPPts As LLC · Reading, PABuilt 2013 · S/N 308N503RPPts As LLC · Reading, PABuilt 2013 · S/N 307N508RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 306N513RBBeasley Roger K · Austin, TXBuilt 2002 · S/N 060N513UBC Street Holdings LLC · Newport Beach, CABuilt 2005 · S/N 126N518KHGolden Eagle Management LLC · Missoula, MTBuilt 2007 · S/N 229N530LDModena Aviation LLC · Leander, TXBuilt 2006 · S/N 203N531MBCaleah Acquisitions LLC · Savannah, GABuilt 2001 · S/N 044N54CMGac Wings LLC · Boca Raton, FLBuilt 2001 · S/N 042N557GABank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 292N573PTLoxodonta Aviation LLC · Vero Beach, FLBuilt 2005 · S/N 127N57RGBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 281N581SFFkm Enterprises LLC · North Oaks, MNBuilt 2008 · S/N 250N597NEFiwc26 LLC · El Paso, TXBuilt 2006 · S/N 144N597RBBaugh Aviation Services LLC · Orem, UTBuilt 2002 · S/N 068N598KDWildhorse Air II LLC · Minden, NVBuilt 2014 · S/N 313N5BCTsb Aviation Inc · Madera, CABuilt 2003 · S/N 084N606HPMustang 99 LLC · Austin, TXBuilt 2005 · S/N 116N612FAGroup Project Eight LLC · Bountiful, UTBuilt 2009 · S/N 213N619KSBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 151N626LBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 277N631DVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 166N650DHDrury Development Corp · Saint Louis, MOBuilt 2008 · S/N 247N651DHDrury Development Corp · Saint Louis, MOBuilt 2015 · S/N 319N65ERM G Investment Properties LLC · Van Nuys, CABuilt 2004 · S/N 100N663SBKka Enterprises LLC · Flower Mound, TXBuilt 2002 · S/N 062N668TVentu Aviation LLC · Tampa, FLBuilt 2008 · S/N 276N671BP671bp LLC · Cypress, TXBuilt 2000 · S/N 031N672PSFort Stephenson Air LLC · Chattanooga, TNBuilt 1999 · S/N 010N674PGArthur J Gallagher (Illinois) LLC · Rolling Meadows, ILBuilt 2011 · S/N 296N679MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 156N67KPMarivest Support Services LLC · Pittsburg, KSBuilt 2008 · S/N 249N67LRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 102N682RVKr Escapes LLC · Wilmington, DEBuilt 2006 · S/N 150N688HLH&L 168 LLC · Las Vegas, NVBuilt 2011 · S/N 247N68HHoward Industries Inc · Laurel, MSBuilt 2011 · S/N 297N696FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 202N699DB699db LLC · Vienna, VABuilt 2001 · S/N 056N700FAJet Flight LLC · Shreveport, LABuilt 2008 · S/N 278N703MSHillpointe Aviation Fl LLC · Winter Park, FLBuilt 2010 · S/N 235
Back to AD 2011-23-07