SELECT * FROM items WHERE active = '1' AND sh_id = 'conceptaviation' AND items.sub_item = 0 AND (cat_string LIKE '%\_425\_%' OR cat_string2 LIKE '%\_425\_%')

Books

Name A to Z
Name Z to A
Price Low to High
Price High to Low
Average Rating
Newest to Oldest
Oldest to Newest
 

Your item has been added!

Foggles
Foggles
Foggles-c
More Info
$52.00 ea.
Pilot Training Glasses That Meet Instrument Flight Rule (IFR) Certification Requirements! These polycarbonate lenses are frosted to partially block the field of vision. The open area is just large enough to allow the pilot in training to have a full view of the instrument panel. Foggles are light, c...