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.

N654WAWinchester Air Inc · Winchester, MABuilt 2024 · S/N 560-6363N655QSNetjets Sales Inc · Oklahoma City, OKBuilt 2006 · S/N 560-5655N655TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5251N656CNCorporate Flight Management Incdba · Smyrna, TNBuilt 2005 · S/N 560-5551N656QSRegistered aircraftBuilt 2007 · S/N 560-5732N657CNCorporate Flight Management Inc · Smyrna, TNBuilt 2005 · S/N 560-5572N664AFAlfa Financial Corp · Montgomery, ALBuilt 2011 · S/N 560-6064N668TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5268N669QSNetjets Sales Inc · Columbus, OHBuilt 2007 · S/N 560-5689N670KF2012 Leasing Inc · Saint Paul, MNBuilt 2002 · S/N 560-5306N670MWDg Financial Consulting Inc · Longview, TXBuilt 2004 · S/N 560-5511N676TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 560-5367N678QSNetjets Sales Inc · Oklahoma City, OKBuilt 2006 · S/N 560-5616N679LGBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 560-6195N67PRStr Holdings LLC · Memphis, TNBuilt 2009 · S/N 560-5806N681WAWonderful Orchards LLC · Bakersfield, CABuilt 2012 · S/N 560-6098N683QSNetjets Sales Inc · Columbus, OHBuilt 2006 · S/N 560-5643N685QSNetjets Sales Inc · Oklahoma City, OKBuilt 2006 · S/N 560-5650N686QSNetjets Sales Inc · Oklahoma City, OKBuilt 2006 · S/N 560-5661N687SFTextron Aviation Inc · Wichita, KSBuilt 2023 · S/N 560-6317N68GNGrady-White Boats Inc · Greenville, NCBuilt 2015 · S/N 560-6189N68MYRedeemed Holdings II LLC · Artesia, NMBuilt 2006 · S/N 560-5666N690MJNorth South Aviation LLC · Sheridan, WYBuilt 2000 · S/N 560-5133N690TXKancolo Aero LLC · Wichita, KSBuilt 2002 · S/N 560-5290N690XLLuke Oil Co Inc · Hobart, INBuilt 2007 · S/N 560-5690N692TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5293N693QSNetjets Sales Inc · Oklahoma City, OKBuilt 2006 · S/N 560-5657N697ECEagle Carports Inc · Mount Airy, NCBuilt 2008 · S/N 560-5809N697SDMia Jets Acquisitions LLC · Miami, FLBuilt 2001 · S/N 560-5197N6TMO52 Logistics LLC · Mriott Sltrvl, UTBuilt 2010 · S/N 560-6071N703PPink Ribbon Aviation LLC · Wilmington, DEBuilt 2003 · S/N 560-5317N704HHHihopes Air LLC · Charlotte, NCBuilt 2025 · S/N 560-6380N705SGUnion Of Operating Engineers · Pasadena, CABuilt 2001 · S/N 560-5142N706RRRr604 LLC · Charlotte, NCS/N 560-5247N706WLScheels All Sports Inc · Fargo, NDBuilt 2000 · S/N 560-5036N708MBas Part Sales LLC · Greeley, COBuilt 2001 · S/N 560-5194N708USXls Leasing LLC · Conover, NCBuilt 2008 · S/N 560-5824N70BCSale Reported · Wilmington, DESale reportedBuilt 2002 · S/N 560-5279N70THAlliance Aviation Group LLC · Wilmington, DEBuilt 1998 · S/N 560-5007N711BSBlue Transport LLC · Columbia, SCBuilt 2009 · S/N 560-6015N711FPF A Peinado LLC · Frisco, TXBuilt 2005 · S/N 560-5565N711LXNational Education Loan Network Inc · Lincoln, NEBuilt 2021 · S/N 560-6300N711LZBg22 LLC · Lewes, DEBuilt 2006 · S/N 560-5597N712ABArcbest II Inc · Fort Smith, ARBuilt 2020 · S/N 560-6297N712GKKs Air 3-7-12 Vi LLC · Charlotte, NCBuilt 2021 · S/N 560-6312N712JNIp Aviation LLC · Saint Paul, MNBuilt 2022 · S/N 560-6332N712PVTacocat LLC · Omaha, NEBuilt 2005 · S/N 560-5556N713TXZeplane LLC · Miami, FLBuilt 2000 · S/N 560-5063N714WAMustang Interests LLC · Fort Worth, TXBuilt 2016 · S/N 560-6217N715MNCohasp Aero Ventures LLC · Overland Park, KSBuilt 2009 · S/N 560-6048
Back to AD 2012-06-01