col : model | origin | type | versions | in service | notes row 1 : vought f-8 crusader | united states | air superiority fighter/interceptor aircraft | f-8p | 35 | placed in open storage 1988-01-23 at basa air base. row 2 : northrop f-5 freedom fighter | united states | fighter/bomber | f-5a f-5b | 37 | retired. the 10 remaining f-5s, out of a row 3 : north american f-86 sabre | united states | fighter/bomber | f-86f f-86d | 50 20 | replaced by the northrop f-5a row 4 : north american p-51 mustang | united states | fighter | p-51d | 103 | paf's 1950s fighter, replaced by f-86 sabre row 5 : north american t-28 trojan | united states | trainer/light strike aircraft | t-28a t-28d | 20 24 | replaced by ov-10 bronco row 6 : north american t-6 texan | united states | trainer aircraft | nan | 38 | nan row 7 : beechcraft t-34 mentor | united states | trainer aircraft | nan | 36 | replaced by the sf-260 row 8 : lockheed t-33 shooting star | united states | trainer aircraft | t-33a rt-33a | 25 2 | replaced by the s-211 row 9 : douglas ac-47 spooky | united states | close air support aircraft | nan | 11 | nan row 10 : douglas c-47 skytrain | united states | military transport aircraft | nan | ? | replaced by the c-130 row 11 : de havilland canada dhc-2 beaver | canada | military transport aircraft | nan | ? | replaced by the c-130 row 12 : grumman hu-16 albatross | united states | military transport aircraft | hu-16b | 6 | nan row 13 : namc ys-11 | japan | vip transport | nan | ? | nan row 14 : stinson l-5 sentinel | united states | liaison aircraft | nan | ? | nan row 15 : sikorsky s-62 | united states   japan | multipurpose utility helicopter  multipurpose utility helicopter  vip transport | s-62a  s-62j | 1  2 | nan row 16 : sikorsky h-34 | united states | sar helicopter | nan | ? | nan row 17 : sikorsky h-19 | united states | nan | nan | ? | nan row 18 : bell 212 | united states | utility helicopter | nan | 1 | a presidential aircraft that crashed in benguet province. row 19 : aerospatiale sa 330 puma | france | presidential helicopter | sa 330l | 2 | nan
what are all of the aircraft? of those, which one has the highest in service time?
north american p-51 mustang, united states, fighter, p-51d, 103, paf's 1950s fighter, replaced by f-86 sabre
Model Origin Type Versions In Service Notes
of those, which one has the highest in service time?
Vought F-8 Crusader United States Air superiority fighter/Interceptor aircraft F-8P 35 Placed in open storage 1988-01-23 at Basa Air Base.
Northrop F-5 Freedom Fighter United States Fighter/Bomber F-5A F-5B 37 Retired. The 10 remaining F-5s, out of a
North American F-86 Sabre United States Fighter/Bomber F-86F F-86D 50 20 Replaced by the Northrop F-5A
North American P-51 Mustang United States Fighter P-51D 103 PAF's 1950s Fighter, replaced by F-86 Sabre
North American T-28 Trojan United States Trainer/Light strike aircraft T-28A T-28D 20 24 Replaced by OV-10 Bronco
North American T-6 Texan United States Trainer aircraft nan 38 nan
Beechcraft T-34 Mentor United States Trainer aircraft nan 36 Replaced by the SF-260
Lockheed T-33 Shooting Star United States Trainer aircraft T-33A RT-33A 25 2 Replaced by the S-211
Douglas AC-47 Spooky United States Close air support aircraft nan 11 nan
Douglas C-47 Skytrain United States Military transport aircraft nan ? Replaced by the C-130
de Havilland Canada DHC-2 Beaver Canada Military transport aircraft nan ? Replaced by the C-130
Grumman HU-16 Albatross United States Military transport aircraft HU-16B 6 nan
NAMC YS-11 Japan VIP transport nan ? nan
Stinson L-5 Sentinel United States Liaison aircraft nan ? nan
Sikorsky S-62 United States   Japan Multipurpose utility helicopter  Multipurpose utility helicopter  VIP transport S-62A  S-62J 1  2 nan
Sikorsky H-34 United States SAR Helicopter nan ? nan
Sikorsky H-19 United States nan nan ? nan
Bell 212 United States Utility helicopter nan 1 A presidential aircraft that crashed in Benguet Province.
Aerospatiale SA 330 Puma France Presidential helicopter SA 330L 2 nan
North American P-51 Mustang United States Fighter P-51D 103 PAF's 1950s Fighter, replaced by F-86 Sabre
of those, which one has the highest in service time? || what are all of the aircraft?