There is actually no average length which can be measured in numbers because what we always consider is aesthetic proportions. Ideally, length from the tip to the base of the columella should be equal to the vertical length of your upper lip (the distance between the base of your columella to...
Your photos reveal congenital asymmetric alar rims.
Deformities such as these are correctable through the placement of small cartilage grafts to reshape the arch of the nostrils from the inside
Tip grafting can be removed through either a closed or open approach. The issue with tip grafting is that the soft tissues can contract around the graft, creating a visiblity of the graft.