DROP DATABASE IF EXISTS travel;
CREATE DATABASE travel;

USE travel;

CREATE TABLE manufacturers (
  manufacturer_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  manufacturer VARCHAR(50) NOT NULL,
  create_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  last_update TIMESTAMP NOT NULL 
    DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (manufacturer_id) )
ENGINE=InnoDB AUTO_INCREMENT=1001;

CREATE TABLE airplanes (
  plane_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  plane VARCHAR(50) NOT NULL,
  manufacturer_id INT UNSIGNED NOT NULL,
  engine_type VARCHAR(50) NOT NULL,
  engine_count TINYINT NOT NULL,
  max_weight MEDIUMINT UNSIGNED NOT NULL,
  wingspan DECIMAL(5,2) NOT NULL,
  plane_length DECIMAL(5,2) NOT NULL,
  parking_area INT GENERATED ALWAYS AS ((wingspan * plane_length)) STORED,
  icao_code CHAR(4) NOT NULL,
  create_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  last_update TIMESTAMP NOT NULL 
    DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (plane_id),
  CONSTRAINT fk_manufacturer_id FOREIGN KEY (manufacturer_id) 
    REFERENCES manufacturers (manufacturer_id) ) 
ENGINE=InnoDB AUTO_INCREMENT=101;

INSERT INTO manufacturers (manufacturer)
VALUES ('Airbus'), ('Beechcraft'), ('Boeing'), ('Cessna'), ('Embraer'), ('Piper');

INSERT INTO airplanes 
  (plane, manufacturer_id, engine_type, engine_count, 
    wingspan, plane_length, max_weight, icao_code)
VALUES
('A220-100',1001,'Jet',2,115.08,114.75,134000,'BCS1'),
('A220-300',1001,'Jet',2,115.08,127,149000,'BCS3'),
('A300-100 (A300-B4-100)',1001,'Jet',2,147.08,175.5,347227,'A30B'),
('A300-100-200 (A300-B2-100-200)',1001,'Jet',2,147.08,175.5,313056,'A30B'),
('A300-200 (A300-B4-200)',1001,'Jet',2,147.08,175.5,363760,'A30B'),
('A300-600 (B4-C4-600)',1001,'Jet',2,147.14,177.43,363760,'A306'),
('A300-600 (F4-600)',1001,'Jet',2,147.14,177.42,375887,'A306'),
('A300-600R (B4-600R)',1001,'Jet',2,147.14,177.43,378530,'A306'),
('A300-600ST BelugaST',1001,'Jet',2,147.14,184.25,341713,'A3ST'),
('A300-600XL BelugaXL',1001,'Jet',2,197.83,207,500444,'A3ST'),
('A310-200',1001,'Jet',2,144.03,153.16,317465,'A310'),
('A310-300',1001,'Jet',2,144.03,153.16,361557,'A310'),
('A318-100',1001,'Jet',2,111.88,103.18,149914,'A318'),
('A319-100',1001,'Jet',2,111.88,111.02,168653,'A319'),
('A319-100 Sharklet',1001,'Jet',2,117.45,111.02,168653,'A319'),
('A319neo Sharklet',1001,'Jet',2,117.45,111.02,166449,'A319'),
('A320-200',1001,'Jet',2,111.88,123.27,171961,'A320'),
('A320-200 Sharklet',1001,'Jet',2,117.45,123.27,171961,'A320'),
('A320neo Sharklet',1001,'Jet',2,117.45,123.27,174165,'A320'),
('A321-100',1001,'Jet',2,111.88,146.03,196211,'A321'),
('A321-100 Sharklet',1001,'Jet',2,117.45,146.03,196211,'A321'),
('A321-200',1001,'Jet',2,111.88,146.03,206132,'A321'),
('A321-200 Sharklet',1001,'Jet',2,117.45,146.03,206132,'A321'),
('A321neo Sharklet',1001,'Jet',2,117.45,146.03,206132,'A321'),
('A330-200',1001,'Jet',2,197.83,193.57,533519,'A332'),
('A330-200F',1001,'Jet',2,197.83,192.98,533519,'A332'),
('A330-300',1001,'Jet',2,197.83,208.99,533519,'A333'),
('A340-200',1001,'Jet',4,197.83,194.95,606271,'A342'),
('A340-300',1001,'Jet',4,197.83,208.96,609578,'A343'),
('A340-500',1001,'Jet',4,208.17,222.87,837756,'A345'),
('A340-600',1001,'Jet',4,208.17,247.24,837756,'A346'),
('A350-800 XWB',1001,'Jet',2,212.42,198.58,546700,'A358'),
('A350-900',1001,'Jet',2,212.42,219.16,617295,'A359'),
('A350-900 XWB',1001,'Jet',2,212.42,219.42,617300,'A359'),
('A380-800',1001,'Jet',4,261.65,238.62,1267658,'A388'),
('A380-843F',1001,'Jet',4,261.65,238.62,1300000,'A38F'),
('ACJ320neo (Corporate Jet version)',1001,'Jet',2,117.45,123.27,174165,'A320'),
('1900C',1002,'Turboprop',2,54.5,57.83,16600,'B190'),
('1900D',1002,'Turboprop',2,57.75,57.67,17120,'B190'),
('Baron 55',1002,'Piston',2,37.83,28,5300,'BE55'),
('Baron 56 TC Turbo Baron',1002,'Piston',2,37.83,28,5990,'BE56'),
('Baron 58 (and current G58)',1002,'Piston',2,37.83,29.83,5500,'BE58'),
('Beechjet 400 (same as MU-300-10 Diamond II)',1002,'Jet',2,43.5,48.42,15780,'BE40'),
('Beechjet 400A (became Raytheon Beechjet 400A)',1002,'Jet',2,43.5,48.42,16100,'BE40'),
('Bonanza 33 (F33A)',1002,'Piston',1,33.5,26.67,3500,'BE33'),
('Bonanza 35 (G35)',1002,'Piston',1,32.83,25.17,3125,'BE35'),
('Bonanza 35 (P35)',1002,'Piston',1,33.5,25.08,3125,'BE35'),
('Bonanza 35 (V35TC) rare as only 7 built',1002,'Piston',1,33.5,26.42,3400,'BE35'),
('Bonanza 36 (G36)',1002,'Piston',1,33.5,27.5,3650,'BE36'),
('King Air 100 (B100)',1002,'Turboprop',2,45.92,39.92,11800,'BE10'),
('King Air 200 and 250',1002,'Turboprop',2,54.5,43.75,12500,'BE20'),
('King Air 300 and 300LW (Limited Weight version)',1002,'Turboprop',2,57.92,46.67,14000,'BE30'),
('King Air 350i (current production model)',1002,'Turboprop',2,57.92,46.67,15000,'B350'),
('King Air 90 (A90)',1002,'Turboprop',2,45.92,35.5,9300,'BE9L'),
('King Air 90 (C90B)',1002,'Turboprop',2,50.25,35.5,10100,'BE9L'),
('King Air 90 (F90)',1002,'Turboprop',2,54.5,35.5,10950,'BE9T'),
('King Air C90GTi',1002,'Turboprop',2,53.67,35.5,10485,'BE9L'),
('King Air C90GTx',1002,'Turboprop',2,53.67,35.5,10485,'BE9L'),
('King Air C90GTx',1002,'Turboprop',2,50.25,35.5,10100,'BE9L'),
('Model 18 (H18 Super Twin Beech)',1002,'Piston',2,49.67,35.25,9900,'BE18'),
('Model 60 Duke (B60)',1002,'Piston',2,39.25,33.83,6775,'BE60'),
('Model 60 Duke (Original 60 and the A60)',1002,'Piston',2,39.25,33.83,6725,'BE60'),
('Model 60 Royal Turbine Duke',1002,'Turboprop',1,39.25,33.83,7050,'BE60'),
('Model 65 (Queen Air 65)',1002,'Piston',2,45.88,35.5,7700,'BE65'),
('Model 65A (Queen Air A65)',1002,'Piston',2,45.88,35.5,8200,'BE65'),
('Model 70 (Queen Air 70)',1002,'Piston',2,50.25,35.5,8200,'BE70'),
('Model 80 (Queen Air 80)',1002,'Piston',2,45.88,35.5,8000,'BE80'),
('Model 80A (Queen Air A80)',1002,'Piston',2,50.25,35.5,8500,'BE80'),
('Model 80B (Queen Air B80)',1002,'Piston',2,50.25,35.5,8800,'BE80'),
('Model 88 (Queen Air 88)',1002,'Piston',2,50.25,35.5,8800,'BE88'),
('Model 95 Travel Air D95A',1002,'Piston',2,37.83,25.92,4200,'BE95'),
('T-34C Mentor',1002,'Turboprop',1,33.32,28.71,5500,'T34P'),
('707-320B-C',1003,'Jet',4,145.75,152.92,333600,'B703'),
('717-200',1003,'Jet',2,93.33,124,118000,'B712'),
('717-200 HGW Option',1003,'Jet',2,93.33,124,121000,'B712'),
('720B',1003,'Jet',4,130.83,136.75,234300,'B720'),
('727-100 and -100C Basic',1003,'Jet',2,108,133.17,160000,'B721'),
('727-100 and -100C Option',1003,'Jet',2,108,133.17,169000,'B721'),
('727-200 Basic',1003,'Jet',2,108,153.17,184800,'B722'),
('727-200 Basic with winglets',1003,'Jet',2,109.25,153.17,184800,'B722'),
('727-200 Option',1003,'Jet',2,108,153.17,209500,'B722'),
('727-200 Option with winglets',1003,'Jet',2,109.25,153.17,209500,'B722'),
('737-100',1003,'Jet',2,93,94,110000,'B731'),
('737-200',1003,'Jet',2,93,100.17,115500,'B732'),
('737-300',1003,'Jet',2,94.75,109.58,139500,'B733'),
('737-300 with winglets',1003,'Jet',2,102.08,109.58,139500,'B733'),
('737-400',1003,'Jet',2,94.75,119.58,150000,'B734'),
('737-500',1003,'Jet',2,94.75,101.75,136000,'B735'),
('737-600',1003,'Jet',2,112.58,102.5,144500,'B736'),
('737-600 with winglets',1003,'Jet',2,117.42,102.5,144500,'B736'),
('737-700 with winglets',1003,'Jet',2,117.42,110.33,154500,'B737'),
('737-800',1003,'Jet',2,112.58,129.5,174200,'B738'),
('737-800 with upper and lower winglets',1003,'Jet',2,117.83,129.5,174200,'B738'),
('737-800 with winglets',1003,'Jet',2,117.42,129.5,174200,'B738'),
('737-900',1003,'Jet',2,112.58,138.17,174200,'B739'),
('737-900 with upper and lower winglets',1003,'Jet',2,117.83,138.17,174200,'B739'),
('737-900 with winglets',1003,'Jet',2,117.42,138.17,174200,'B739'),
('737-900ER',1003,'Jet',2,112.58,138.17,187700,'B739'),
('737-900ER with winglets',1003,'Jet',2,117.42,138.17,187700,'B739'),
('747-100B SR',1003,'Jet',4,195.67,231.83,600000,'B741'),
('747-100SF (Swingtail Freighter)',1003,'Jet',4,195.67,231.83,735000,'B741'),
('747-300SR',1003,'Jet',4,195.67,231.83,600000,'B743'),
('747-400 DOMESTIC',1003,'Jet',4,195.67,231.85,610000,'B744'),
('747-400ER',1003,'Jet',4,213,231.85,910000,'B744'),
('747-400ER F',1003,'Jet',4,213,231.85,910000,'B744'),
('747-400F',1003,'Jet',4,213,231.85,875000,'B744'),
('747-8',1003,'Jet',4,224.42,250.17,987000,'B748'),
('747-8F',1003,'Jet',4,224.42,250.17,987000,'B748'),
('747-SP',1003,'Jet',4,195.67,184.75,696000,'B74S'),
('757-300',1003,'Jet',2,124.83,178.58,270000,'B753'),
('757-300 with winglets',1003,'Jet',2,134.75,178.58,270000,'B753'),
('767-200',1003,'Jet',2,156.08,159.17,315000,'B762'),
('767-200ER',1003,'Jet',2,156.08,159.17,395000,'B762'),
('767-300',1003,'Jet',2,156.08,180.25,350000,'B763'),
('767-300 Freighter',1003,'Jet',2,156.08,180.25,412000,'B763'),
('767-300ER',1003,'Jet',2,156.08,180.25,412000,'B763'),
('767-300ER with winglets',1003,'Jet',2,167,180.25,412000,'B763'),
('767-400ER',1003,'Jet',2,170.33,201.33,450000,'B764'),
('777-200',1003,'Jet',2,199.92,209.08,535000,'B772'),
('777-200 (HGW Option)',1003,'Jet',2,199.92,209.08,632500,'B772'),
('777-200LR',1003,'Jet',2,212.58,209.08,766000,'B772'),
('777-300',1003,'Jet',2,199.92,242.33,660000,'B773'),
('777-300ER',1003,'Jet',2,212.58,242.33,775000,'B77W'),
('777-300F',1003,'Jet',2,212.58,209.08,766800,'B773'),
('787-8 Dreamliner',1003,'Jet',2,197.25,186.08,502500,'B788'),
('787-9 Dreamliner',1003,'Jet',2,197.25,206.08,560000,'B789'),
('162 Skycatcher',1004,'Piston',1,30,22.8,1320,'C162'),
('172 Skyhawk Turbo JT-A (aka a Turbo Skyhawk)',1004,'Piston',1,36.08,27.17,2550,'C172'),
('175 Skylark',1004,'Piston',1,36.17,25,2500,'C175'),
('177 Cardinal',1004,'Piston',1,35.5,27.25,2500,'C177'),
('177 Cardinal RG',1004,'Piston',1,35.5,27.25,2800,'C77R'),
('180 Skywagon',1004,'Piston',1,35.83,25.63,2800,'C180'),
('185 Skywagon',1004,'Piston',1,35.83,25.63,3350,'C185'),
('185 Skywagon (A185 Agcarryall)',1004,'Piston',1,35.83,25.75,3350,'C185'),
('185 Skywagon Amphibian',1004,'Piston',1,35.83,27.5,3265,'C185'),
('185 Skywagon Floatplane',1004,'Piston',1,35.83,27,3320,'C185'),
('205 Skywagon',1004,'Piston',1,36.17,27.33,3300,'C205'),
('206 Stationair Turbo HD',1004,'Piston',1,36,28.25,3789,'C06T'),
('208 Caravan',1004,'Turboprop',1,52.08,37.58,8000,'C208'),
('208B Grand Caravan EX Amphibian',1004,'Turboprop',1,52.08,41.58,9062,'C208'),
('208B Grand Caravan EX-Super Cargomaster EX',1004,'Turboprop',1,52.08,41.58,8807,'C208'),
('303 (T303) Crusader',1004,'Piston',2,39.04,30.42,5150,'C303'),
('310 (Model T310R)',1004,'Piston',2,36.92,32,5500,'C310'),
('318 - A-37 Dragonfly',1004,'Jet',2,35.86,28.28,14000,'A37'),
('340 (developed from 1004 310)',1004,'Piston',2,38.11,43.33,6025,'C340'),
('350 Corvalis',1004,'Piston',1,36.08,25.17,3400,'COL3'),
('400 Corvalis TT',1004,'Piston',1,36.08,25.17,3400,'COL4'),
('402C Utililiner-Businessliner turbocharged',1004,'Piston',2,44.17,36.42,6850,'C02T'),
('404 Titan',1004,'Piston',2,46.33,39.52,8400,'C404'),
('414A Chancellor',1004,'Piston',2,44.17,36.42,6750,'C414'),
('421C Golden Eagle',1004,'Piston',2,44.17,36.42,7450,'C421'),
('425 Corsair-Conquest I',1004,'Turboprop',2,44.17,35.83,8600,'C425'),
('441 Conquest II',1004,'Turboprop',2,49.33,39,9850,'C441'),
('Citation CJ1 (Model C525)',1004,'Jet',2,46.92,42.58,10600,'C525'),
('Citation CJ1+ (Model C525)',1004,'Jet',2,46.92,42.58,10700,'C525'),
('Citation CJ2 (Model C525A)',1004,'Jet',2,49.83,47.67,12300,'C25A'),
('Citation CJ2+ (Model C525A)',1004,'Jet',2,49.83,47.67,12500,'C25A'),
('Citation CJ4 (Model C525C)',1004,'Jet',2,50.83,53.33,17110,'C25C'),
('Citation Excel',1004,'Jet',2,55.71,51.79,20000,'C56X'),
('Citation Latitude',1004,'Jet',2,72.33,62.25,30800,'C68A'),
('Citation M2 (Model C525)',1004,'Jet',2,47.25,42.58,10700,'C25M'),
('Citation Mustang (Model C510)',1004,'Jet',2,43.17,40.58,8645,'C510'),
('Citation S-II',1004,'Jet',2,51.58,47.71,15100,'S550'),
('Citation Sovereign',1004,'Jet',2,63.33,63.5,30300,'C680'),
('Citation Sovereign+',1004,'Jet',2,72.33,63.5,30775,'C680'),
('Citation Ultra Encore',1004,'Jet',2,52.17,48.9,16630,'C560'),
('Citation VII (an upgrade of the III)',1004,'Jet',2,53.5,55.46,23000,'C650'),
('Citation X',1004,'Jet',2,63.58,72.33,36100,'C750'),
('Citation X+',1004,'Jet',2,69.17,73.58,36600,'C750'),
('CitationJet',1004,'Jet',2,46.79,42.58,10400,'C526'),
('UC-35 (military designation of Ultra)',1004,'Jet',2,52.17,48.9,16300,'C560'),
('EMB 110 Bandeirante',1005,'Turboprop',2,50.25,50.33,13010,'E110'),
('EMB 120 Brasilia (ER Model)',1005,'Turboprop',2,64.92,65.67,26433,'E120'),
('EMB 121 XINGU II',1005,'Turboprop',2,48.67,44.08,13536,'E121'),
('EMB 175 AR',1005,'Jet',2,85.33,103.92,89000,'E170'),
('EMB 175 LR',1005,'Jet',2,85.33,103.92,85517,'E170'),
('EMB 175 Standard',1005,'Jet',2,85.33,103.92,82673,'E170'),
('EMB 175-E2',1005,'Jet',2,101.67,106,98767,'E170'),
('EMB 190 AR',1005,'Jet',2,94.25,118.92,114199,'E190'),
('EMB 190 LR',1005,'Jet',2,94.25,118.92,110892,'E190'),
('EMB 190 Standard',1005,'Jet',2,94.25,118.92,105359,'E190'),
('EMB 190-E2',1005,'Jet',2,101.67,106,124341,'E190'),
('EMB 195 AR',1005,'Jet',2,94.25,126.83,115280,'E190'),
('EMB 195 LR',1005,'Jet',2,94.25,126.83,111973,'E190'),
('EMB 195 Standard',1005,'Jet',2,94.25,126.83,107564,'E190'),
('EMB 195-E2',1005,'Jet',2,101.67,106,135584,'E190'),
('EMB 201 Ipanema 201 (Ag Sprayer)',1005,'Piston',1,37.75,24.42,3968,'IPAN'),
('EMB 202 Ipanema 202 (Ag Sprayer)',1005,'Piston',1,38.33,24.42,3969,'IPAN'),
('EMB 203 Ipanema 203 (Ag Sprayer)',1005,'Piston',1,43.64,26.33,3969,'IPAN'),
('EMB 312 Tucano',1005,'Turboprop',1,36.5,32.33,7000,'TUCA'),
('EMB 312S Short Tucano',1005,'Turboprop',1,37,32.33,7220,'TUCA'),
('EMB-ERJ-135 ER',1005,'Jet',2,65.75,86.42,41888,'E135'),
('EMB-ERJ-135 LR',1005,'Jet',2,65.75,86.42,44092,'E35L'),
('EMB-ERJ-140 ER',1005,'Jet',2,65.75,93.42,44312,'E135'),
('EMB-ERJ-140 LR',1005,'Jet',2,65.75,93.42,46517,'E135'),
('EMB-ERJ-145 EP',1005,'Jet',2,65.75,98,46275,'E145'),
('EMB-ERJ-145 ER',1005,'Jet',2,65.75,98,45415,'E145'),
('EMB-ERJ-145 EU',1005,'Jet',2,65.75,98,44070,'E145'),
('EMB-ERJ-145 LR',1005,'Jet',2,65.75,98,48502,'E145'),
('EMB-ERJ-145 LU',1005,'Jet',2,65.75,98,48480,'E145'),
('EMB-ERJ-145 MK',1005,'Jet',2,65.75,98,44070,'E145'),
('EMB-ERJ-145 MP',1005,'Jet',2,65.75,98,46275,'E145'),
('EMB-ERJ-145 XR',1005,'Jet',2,68.92,98,53131,'E45X'),
('Phenom 100 (EMB-500)',1005,'Jet',2,40.33,42.08,10582,'E50P'),
('Phenom 300 (EMB-505)',1005,'Jet',2,52.17,51.33,17968,'E55P'),
('J-3 Cub',1006,'Piston',1,38,22.42,1220,'J3'),
('PA-18-150 Super Cub',1006,'Piston',1,35.29,22.5,1750,'PA18'),
('PA-24-180 Comanche',1006,'Piston',1,36,24.79,2550,'PA24'),
('PA-24-250 Comanche',1006,'Piston',1,36,24.79,2900,'PA24'),
('PA-24-260 Comanche',1006,'Piston',1,36,25.29,3200,'PA24'),
('PA-24-400 Comanche',1006,'Piston',1,36,24.79,3600,'PA24'),
('PA-28-151 and -161 Cherokee Warrior-Cadet',1006,'Piston',1,35,23.79,2325,'P28A'),
('PA-28-180 Cherokee',1006,'Piston',1,30,23.5,2400,'P28A'),
('PA-28-210T Cherokee Turbo Dakota',1006,'Piston',1,35,24.73,2900,'P28B'),
('PA-28-235 Cherokee',1006,'Piston',1,32,23.79,2900,'P28A'),
('PA-28-235 Cherokee Pathfinder-Charger',1006,'Piston',1,32,23.79,3000,'P28A'),
('PA-28-236 Cherokee Dakota',1006,'Piston',1,35,24.73,3000,'P28A'),
('PA-28R-180 Cherokee Arrow',1006,'Piston',1,30,23.5,2500,'P28R'),
('PA-28R-200 Cherokee Arrow',1006,'Piston',1,30,23.5,2600,'P28R'),
('PA-28R-200 Cherokee Arrow II',1006,'Piston',1,30,23.92,2600,'P28R'),
('PA-28R-201 Cherokee Arrow III',1006,'Piston',1,35.42,24.67,2750,'P28R'),
('PA-28R-201T Cherokee Turbo Arrow III',1006,'Piston',1,35.42,24.67,2900,'P28R'),
('PA-28RT-201 Cherokee Arrow IV (has T tail)',1006,'Piston',1,35.42,24.67,2750,'P28T'),
('PA-28RT-201T Cherokee Turbo Arrow IV (has T tail)',1006,'Piston',1,35.42,24.67,2900,'P28R'),
('PA-28S-160 Cherokee C Seaplane',1006,'Piston',1,30,23.5,2140,'P28A'),
('PA-28S-180 Cherokee C Seaplane',1006,'Piston',1,30,23.5,2222,'P28A'),
('PA-31 Navajo',1006,'Piston',2,40.67,32.63,6500,'PA31'),
('PA-31-300 Navajo (turbocharged model)',1006,'Piston',2,40.67,32.63,6000,'PA31'),
('PA-31-325 Navajo C-R',1006,'Piston',2,40.67,32.63,6500,'PA31'),
('PA-31-350 Chieftain-T-1020 Navajo C-R',1006,'Piston',2,40.67,34.63,7000,'PA31'),
('PA-31P Navajo (pressurized)',1006,'Piston',2,40.67,32.63,7800,'PA31'),
('PA-31P-350 Mojave',1006,'Piston',2,40.67,32.63,7200,'PA31'),
('PA-31T-260 Cheyenne-Cheyenne II',1006,'Piston',2,42.69,34.67,9000,'PAY2'),
('PA-31T1-500 Cheyenne I-IA',1006,'Piston',2,42.69,34.67,8700,'PAY1'),
('PA-31T2 Cheyenne IIXL',1006,'Piston',2,42.69,34.67,9474,'PAY2'),
('PA-31T3 T-1040 Airliner',1006,'Piston',2,42.69,34.67,9000,'PAT4'),
('PA-32-300 Cherokee Six',1006,'Piston',1,32.67,27.58,3400,'PA32'),
('PA-42-1000 Cheyenne 400 LS (formerly IV)',1006,'Turboprop',2,47.67,43.4,12050,'PAY4'),
('PA-46-400TP Malibu Meridian',1006,'Turboprop',1,43,29.6,4850,'P46T'),
('PA-60 Aerostar 700P',1006,'Piston',2,36.67,34.81,6315,'AEST'),
('PA-60 Aerostar 702P (700P with reinf nose gear)',1006,'Piston',2,36.67,34.81,6850,'AEST');