Types:

Environmental
Crimp Type
Straight PC Tail Type
Right Angle PC Tail
Solder Type

Non-Environmental Series
Crimp Type

Configuration:
Receptacle (Female, Connector with Socket contacts)
Plug (Male, Connector with Pin contacts)

Applications:
This is a general-purpose type connector used in nearly all areas of technology such as aerospace, computer, telecommunication, and automotive industry.

IFE (In Flight Entertainment) systems ­ Video, Audio, Seat to Seat, etc.
Automotive
PC board mounting
In-line mating

Advantages in using a D-subminiature connector:
Ideal for blind mating applications
Space saving
Lightweight
Low cost connector