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.

N87NSSeaman Corporation · Wooster, OHBuilt 2001 · S/N 560-5213N87WUBarristair Lc · Beaumont, TXBuilt 1999 · S/N 560-5039N880POp Aviation LLC · Seattle, WABuilt 2004 · S/N 560-5364N881VPCitation Technology Partners LLC · Woodside, CABuilt 2009 · S/N 560-6018N883PFPrestage Farms Inc · Clinton, NCBuilt 2010 · S/N 560-6053N883SCBuffalo Bayou Air LLC · Houston, TXBuilt 2000 · S/N 560-5124N884BFriendly Skies 2 LLC · Muncie, INBuilt 2001 · S/N 560-5140N885BHWest Star Construction Inc · Kingsburg, CABuilt 2007 · S/N 560-5717N887PCPcj LLC · Carmel, INBuilt 2018 · S/N 560-6252N887WPPack Force One LLC · Raleigh, NCBuilt 2001 · S/N 560-5147N888RTOrlando Plane Partners LLC · Orlando, FLBuilt 2009 · S/N 560-6033N88AFRair LLC · Chicago, ILBuilt 2008 · S/N 560-6004N88CSTelepak Networks Inc · Ridgeland, MSBuilt 2023 · S/N 560-6351N88HPNlp Leasing LLC · North Adams, MABuilt 1999 · S/N 560-5050N890JSDtfa LLC · Kinston, NCBuilt 2010 · S/N 560-6065N891JSRegistered aircraftBuilt 2025 · S/N 560-6379N891SCIsc Aviation LLC · Baton Rouge, LABuilt 2023 · S/N 560-6350N892JSRegistered aircraftBuilt 2025 · S/N 560-6381N892SBN318mm LLC · Topeka, KSBuilt 2007 · S/N 560-5686N892ZZirkle Aviation LLC · Selah, WABuilt 2008 · S/N 560-6007N8JWWatkins Construction Company LLC · Corsicana, TXBuilt 2002 · S/N 560-5305N900ADPnc Bank Na · Boise, IDBuilt 2022 · S/N 560-6320N900KDThird Rockmar LLC · Denton, TXBuilt 2004 · S/N 560-5523N900TVN900tx LLC · Austin, TXBuilt 2000 · S/N 560-5097N900XLMonroe Aviation LLC · Columbus, MSBuilt 2005 · S/N 560-5544N901CBBravo 997 LLC · Grand Rapids, MIBuilt 2022 · S/N 560-6334N901CRCxlo Enterprises LLC · Cincinnati, OHBuilt 2001 · S/N 560-5141N902FHCcbcc Operations LLC · Charlotte, NCBuilt 2019 · S/N 560-6280N906ACBabs Air LLC · Georgetown, TXBuilt 2005 · S/N 560-5596N906DKLangdale Industries Inc · Valdosta, GABuilt 2009 · S/N 560-6016N907WTCj Blue LLC · Little Rock, ARBuilt 1999 · S/N 560-5049N909GCMw Air LLC · Lincoln, NEBuilt 1999 · S/N 560-5067N90FDStonewall Aviation LLC · Oklahoma City, OKBuilt 2010 · S/N 560-6049N913CLDp Leasing LLC · Gilford, NHBuilt 2007 · S/N 560-5718N913TFTosh Farms · Henry, TNBuilt 2022 · S/N 560-6336N915TMTomel Holdings LLC · Idalou, TXBuilt 2007 · S/N 560-5698N916CSAvlease Company LLC · Ann Arbor, MIBuilt 2010 · S/N 560-6062N916JRock Springs Management Inc · Great Bend, KSBuilt 2023 · S/N 560-6353N918RZBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 560-6130N921BRN921br LLC · Sulpher, OKBuilt 2002 · S/N 560-5288N921CGOffshore Energy Service Inc · Broussard, LABuilt 2014 · S/N 560-6174N923GSGreat Southern Bank · Springfield, MOBuilt 2006 · S/N 560-5624N925BWCobblestone Aviation LLC · Neenah, WIBuilt 2004 · S/N 560-5507N928CFBzt Consulting LLC · Scottsdale, AZBuilt 2007 · S/N 560-5705N933MRMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2012 · S/N 560-6126N935BBWells Enterprises Inc · Le Mars, IABuilt 2014 · S/N 560-6180N935PFPentagon Federal Credit Union · Mclean, VABuilt 2020 · S/N 560-6293N936EASeven Hills 5260 LLC · Lynchburg, VABuilt 2006 · S/N 560-5670N941KAKag Leasing Inc · North Canton, OHBuilt 2004 · S/N 560-5510N952RBBest Advantage LLC · Kittitas, WABuilt 2008 · S/N 560-6006
Back to AD 2012-06-01