AD 2012-06-01

Registered aircraft · 726

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:2012-06-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:2012-06-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.

N716LDDorf Air Leasing LLC · Saint Louis, MOBuilt 2002 · S/N 560-5255N717EHElkhart Holdings II LLC · Elkhart, INFirst renewal noticeBuilt 2008 · S/N 560-6008N717NBMckenzie Bridge Land Co LLC · Bakersfield, CABuilt 2007 · S/N 560-5694N718QQExcel Aviation LLC · Saint Clairsville, OHBuilt 2016 · S/N 560-6222N719TTZorair LLC · Houston, TXBuilt 2004 · S/N 560-5516N71HCSoar20 LLC · Holmes, FLBuilt 2000 · S/N 560-5084N720GBCloudkisser LLC · Marco Island, FLS/N 560-6058N720RWRkwilerrebel Mgt LLC · Las Vegas, NVBuilt 2017 · S/N 560-6228N721RNAmd Leasing LLC · Kentwood, MIBuilt 2008 · S/N 560-5785N721WRTpl Logistics LLC · Lubbock, TXS/N 560-6303N721XLAir Suz LLC · Memphis, TNBuilt 2006 · S/N 560-5612N723JGFriends In The Skies LLC · Dallas, TXBuilt 2010 · S/N 560-6069N724GTCoral One LLC · Orlando, FLS/N 560-5564N724MPCanary Holdings LLC · Lexington, KYBuilt 2018 · S/N 560-6248N725MSBlue Doors Property Management LLC · Matthews, NCBuilt 2019 · S/N 560-6273N725XLHogs Fly LLC · Crystal Lake, ILBuilt 2007 · S/N 560-5725N727PJBlack Hat Ventures Pp LLC · Naples, FLBuilt 2001 · S/N 560-5184N72SGAero Air Charter Holding LLC · Pensacola, FLBuilt 2004 · S/N 560-5508N72XLGate Precast Co · Jacksonville, FLBuilt 2011 · S/N 560-6072N731BPBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 560-5802N735XLPjk Equipment Leasing LLC · Zelienople, PABuilt 2007 · S/N 560-5733N737DDegol Aviation Inc · Altoona, PABuilt 2006 · S/N 560-5638N746CXB Street Air LLC · Omaha, NEBuilt 2005 · S/N 560-5567N746PCAerozephyr LLC · Long Beach, CABuilt 2015 · S/N 560-6192N748WRt Air II LLC · Little Rock, ARBuilt 2004 · S/N 560-5531N749XLMitchco Air LLC · Louisville, KYBuilt 2005 · S/N 560-5577N750BABklavi LLC · New Richmond, WIBuilt 1998 · S/N 560-5002N75PSSnow Peak Ventures LLC · Spanish Fork, UTBuilt 2007 · S/N 560-5719N75TPCrimson Excel LLC · Wilmington, DES/N 560-6216N75XL5437 Holdings LLC · Houston, TXBuilt 2000 · S/N 560-5079N760EDLimnes Aviation LLC · Hillsboro, ORBuilt 2001 · S/N 560-5201N765KRSnp Ventures LLC · Kurten, TXBuilt 2010 · S/N 560-6076N766CBNals Apartment Homes LLC · Ogden, UTBuilt 2003 · S/N 560-5341N767BSBrewer Air LLC · Orwigsburg, PABuilt 2001 · S/N 560-5191N76SNMsn Enterprises LLC · Tulsa, OKBuilt 2009 · S/N 560-6032N771DEDhb Aviation LLC · Smithfield, NCBuilt 2005 · S/N 560-5591N771DGFuneral Directors Life Insurance Co · Abilene, TXBuilt 2016 · S/N 560-6207N771PMTbn Group LLC · Reno, NVBuilt 2008 · S/N 560-5799N777LXFrontenac Properties Inc · Chesterfield, MOBuilt 2007 · S/N 560-5736N777RBSchwik Air LLC · Springfield, ILBuilt 2006 · S/N 560-5641N77DZZkd Air LLC · Houston, TXBuilt 2001 · S/N 560-5168N77JDJd Capital LLC · Fort Smith, ARBuilt 2001 · S/N 560-5190N781KBRipley Entertainment Inc · Orlando, FLBuilt 2016 · S/N 560-6214N781SLBb & Ryder LLC · Conway, ARBuilt 2001 · S/N 560-5162N785CC7 Highway Investors LLC · Leawood, KSBuilt 2002 · S/N 560-5275N785TBSeven Eight Five Tb LLC · Topeka, KSBuilt 2006 · S/N 560-5625N786TTXepa Air Inc · Pomona, CABuilt 2008 · S/N 560-5786N787TYLife Logistics LLC · Chesterfield, MOBuilt 2011 · S/N 560-6091N788TMT Air LLC · Birmingham, ALS/N 560-5505N789HUBmag Management Co LLC · Oklahoma City, OKBuilt 2011 · S/N 560-6081
Back to AD 2012-06-01