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.

N20BDHarbor Aircraft LLC · Wilmington, DEBuilt 2000 · S/N 014N20BLKiowa Aircraft Leasing LLC · Colorado Springs, COBuilt 2004 · S/N 094N211TAG150-223 LLC · Easton, MDBuilt 2007 · S/N 223N213EPJssi Parts LLC · Chicago, ILBuilt 2001 · S/N 052N217MSS&S Aviation LLC · Florence, ALBuilt 2007 · S/N 217N222HKNdw Hawk LLC · Laurel, MSBuilt 2008 · S/N 248N224GGGator Tracks LLC · Destin, FLBuilt 2007 · S/N 224N225JDAlliance Aviation Group LLC · Wilmington, DEBuilt 2000 · S/N 028N22GGoodyear Tire & Rubber Co · Akron, OHBuilt 2009 · S/N 282N236PSHoffman Corp · Lake Oswego, ORBuilt 2010 · S/N 236N247PSRed Clay Aviation LLC · Pineville, NCBuilt 2006 · S/N 215N24GGoodyear Tire & Rubber Co · Akron, OHBuilt 2010 · S/N 289N250HMPdkaa 250 Hm Partners LLC · Ketchum, IDBuilt 2008 · S/N 217N251LBAerotrust Services Corp Trustee · Wilmington, DEBuilt 2000 · S/N 024N278GACoramdeo LLC · Dallas, TXBuilt 2002 · S/N 078N27KB3kb Investments LLC · Wilmington, DEBuilt 2010 · S/N 291N280LTMcp Investments LLC · Sugar Land, TXBuilt 2002 · S/N 071N285GAPfc Holdings LLC · Bloomfield Hills, MIBuilt 2009 · S/N 285N286JJHoran John J Jr · Dallas, TXBuilt 2012 · S/N 303N299PSMbv Aviation LLC · Waco, TXBuilt 2006 · S/N 136N29JWSchussboomer Systems Inc · Anacortes, WABuilt 2006 · S/N 205N2BGCalifornia Hotel And Casino · Las Vegas, NVBuilt 2002 · S/N 064N2GPerformance Aviation LLC · Richmond, VABuilt 2004 · S/N 106N2HZHerzog Contracting Corp · Saint Joseph, MOBuilt 2006 · S/N 216N300BJRa2024 LLC · Tomball, TXBuilt 2002 · S/N 049N30MZWildwood Yonder LLC · San Francisco, CABuilt 2009 · S/N 226N311MKSkys The Limit Aviation LLC · Dallas, TXBuilt 2004 · S/N 095N318JFAibonito Aviation LLC · San Juan, PRBuilt 2004 · S/N 093N324WKDollar Air LLC · Menlo Park, CABuilt 2005 · S/N 108N326KHGator One Air LLC · Destin, FLBuilt 2007 · S/N 230N32BGBigs Property LLC · Norht Sioux City, SDBuilt 2006 · S/N 138N330APJ19 Aviation LLC · Austin, TXBuilt 2004 · S/N 105N330WJWaitt Joan T Trustee · La Jolla, CABuilt 2000 · S/N 022N33DYReal Estate And Renovate · Bigfork, MTBuilt 2004 · S/N 103N357JGRegistered aircraftS/N 171N357PTBenson Legacy LLC · Fort Wayne, INBuilt 2013 · S/N 309N358TDYang Chi · Lafayette, COBuilt 2007 · S/N 170N35PSSpotlight Capital LLC · Flower Mound, TXBuilt 2008 · S/N 209N35RFNational Aircraft Leasing LLC #2 · Seattle, WABuilt 2002 · S/N 061N360AVBsc Enterprises LLC · Tulare, CABuilt 2007 · S/N 240N361RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 179N365SSStallings Robert W · Frisco, TXBuilt 2008 · S/N 268N366FBMbl Financial LLC · Highland, UTBuilt 2002 · S/N 075N384JKTravelconfirm Aerolease Inc · Portland, ORBuilt 2002 · S/N 069N390KXKnight Air LLC · Phoenix, AZBuilt 2012 · S/N 305N403SLRegistered aircraftBuilt 2000 · S/N 013N409BMKsnl Aero LLC · Shawnee, OKBuilt 2002 · S/N 059N415PRDlh N415pr LLC · Cortland, NYBuilt 2000 · S/N 017N425JRTb Equico LLC · Beaumont, TXBuilt 2001 · S/N 055N428CJNo Res LLC · Scottsdale, AZBuilt 2008 · S/N 256
Back to AD 2011-23-07