CREATE TABLE table_75586 ("Name" CLOB, "Pennant number" CLOB, "Builder" CLOB, "Laid Down" CLOB, "Launched" CLOB, "Commissioned" CLOB, "Current status" CLOB)

what builder is now retired
SELECT "Pennant number" FROM table_75586 WHERE "Current status" = 'retired'
SELECT "Pennant number" FROM "table_75586" WHERE "Current status" = 'retired'