-- MySQL dump 10.10 -- -- Host: localhost Database: eric -- ------------------------------------------------------ -- Server version 5.0.26-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `test_table2` -- DROP TABLE IF EXISTS `test_table2`; CREATE TABLE `test_table2` ( `tail_num` char(6) NOT NULL default '', `aircraft_serial` char(20) NOT NULL default '', `aircraft_model_code` char(7) NOT NULL default '', `aircraft_engine_code` char(5) NOT NULL default '', `year_built` year(4) NOT NULL default '0000', `aircraft_type_id` tinyint(3) unsigned NOT NULL default '0', `aircraft_engine_type_id` tinyint(3) unsigned NOT NULL default '0', `registrant_type_id` tinyint(3) unsigned NOT NULL default '0', `name` char(50) NOT NULL default '', `address1` char(33) NOT NULL default '', `address2` char(33) NOT NULL default '', `city` char(18) NOT NULL default '', `state` char(2) NOT NULL default '', `zip` char(10) NOT NULL default '', `region` char(1) NOT NULL default '', `county` char(3) NOT NULL default '', `country` char(2) NOT NULL default '', `certification` char(10) NOT NULL default '', `status_code` char(1) NOT NULL default '', `mode_s_code` char(8) NOT NULL default '', `fract_owner` char(1) NOT NULL default '', `last_action_date` date NOT NULL default '0000-00-00', `cert_issue_date` date NOT NULL default '0000-00-00', `air_worth_date` date NOT NULL default '0000-00-00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `test_table2` -- LOCK TABLES `test_table2` WRITE; /*!40000 ALTER TABLE `test_table2` DISABLE KEYS */; INSERT INTO `test_table2` VALUES ('N101TE','2000SC','2804003','52008',1988,4,1,3,'AMBER AVIATION LTD','10500 PROSPECT DR','','ANCHORAGE','AK','99516-1200','5','020','US','42','A','50005031','','2004-08-17','1995-08-03','1988-06-14'),('N11227','15075262','2071826','17020',1973,4,1,1,'AMBLER ERIC J','2059 CARDINAL LOOP','','STANLEY','NC','28164-7787','7','071','US','1U','A','50033137','','2005-12-20','1988-08-09','1973-10-05'),('N1188R','S60A-125','7480606','00000',2000,2,0,1,'AMBER DORIT E','20610 ALDERCROFT HTS RD MYR CAN R','','LOS GATOS','CA','95030','4','085','US','1N','A','50046553','','2005-07-19','1989-07-06','1977-04-21'),('N1358M','75-1229','1380144','17018',1941,4,1,3,'AMBLIN ANTIQUE AIR INC','304 W KARI CT','','JACKSONVILLE','FL','32259-3320','7','109','US','1A','V','50110500','','2005-11-10','2003-08-27','2005-11-14'),('N1401R','AA1B-0501','3960103','41505',1974,4,1,3,'AMBIENT CONDITION','3980 AIRPORT RD HNGR 5','','BOCA RATON','FL','33431-6413','7','099','US','1N','V','50122473','','2005-01-04','2005-01-04','1974-12-16'),('N1583H','18503311','2072821','17032',1977,4,1,4,'AMBLER AIR SERVIE','GENERAL DELIVERY','','AMBLER','AK','99786','5','188','US','30','A','50165260','','2005-06-21','1981-04-29','1999-06-19'),('N180HA','HA3080','4360122','41534',1980,6,3,3,'AMBROSINI HELICOPTERS INC','4497 W MADISON AVE','','FRESNO','CA','93706','4','019','US','1N','A','50240534','','2005-06-21','1989-05-15','1980-05-09'),('N184DM','E-3199','7150001','17042',1998,4,1,3,'AMBLEWOOD PROPERTIES LLC','14627 OAK BLUFF CT','','HOUSTON','TX','77070-2248','2','201','US','1U','V','50247737','','2005-05-10','2005-02-09','1998-10-25'),('N19862','5243','1880206','00000',1986,2,0,1,'AMBEAU ROBERT J','PO BOX 729','','GONZALES','LA','70707-0729','2','005','US','1B','A','50304450','','2003-03-18','1988-12-05','1986-11-04'),('N23HC','289','3300406','41515',1975,6,1,4,'AMBROSE DONALD L','19415 SCHRAM ROAD','','GRETNA','NE','68028','3','153','US','1N','8','50403331','','1992-11-07','1980-12-22','1975-08-13'),('N234PN','DMO 373','05602S9','',2000,4,1,1,'AMBERG PAUL H','12745 LEE CT','','ELM GROVE','WI','53122-1440','C','133','US','','A','50414256','','2005-12-20','1999-12-03','0000-00-00'),('N2561B','48619','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA INTERNATL INC','5383 N W 36TH ST PO BOX 48 181','','MIAMI','FL','00000','7','025','US','','9','50470105','','1977-01-14','0000-00-00','0000-00-00'),('N2562B','48620','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA CO INC','PO BOX 181','','MIAMI','FL','00000','7','025','US','','9','50470150','','1977-01-14','0000-00-00','0000-00-00'),('N2565B','48625','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA CO INC','PO BOX 181','','MIAMI','FL','00000','7','025','US','','9','50470321','','1977-01-14','0000-00-00','0000-00-00'),('N2567B','48627','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA CO INC','PO BOX 181','','MIAMI','FL','00000','7','025','US','','9','50470427','','1977-01-14','0000-00-00','0000-00-00'),('N2568B','48629','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA CO INC','PO BOX 181','','MIAMI','FL','00000','7','025','US','','9','50470472','','1977-01-14','0000-00-00','0000-00-00'),('N2570B','48-632','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA INTNTL INC','PO BOX 181 INTNTL AIRPORT BRANCH','','MIAMI','FL','00000','7','025','US','41','9','50471731','','1977-01-14','0000-00-00','0000-00-00'),('N2571B','48633','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA CO INC','PO BOX 181','','MIAMI','FL','00000','7','025','US','','9','50471774','','1977-01-14','0000-00-00','0000-00-00'),('N2572B','48635','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA CO INC','PO BOX 181','','MIAMI','FL','00000','7','025','US','','9','50472037','','1977-01-14','0000-00-00','0000-00-00'),('N2575B','48638','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA CO INC','PO BOX 181','','MIAMI','FL','00000','7','025','US','','9','50472210','','1977-01-14','0000-00-00','0000-00-00'),('N2576B','48639','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA CO INC','PO BOX 181','','MIAMI','FL','00000','7','025','US','','9','50472253','','1977-01-14','0000-00-00','0000-00-00'),('N2577B','48640','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIA CO INC','PO BOX 181','','MIAMI','FL','00000','7','025','US','','9','50472316','','1977-01-14','0000-00-00','0000-00-00'),('N267K','09971156','05605FX','',2000,4,1,1,'AMBROSE STEPHEN R','23736 ROLLING FORK WAY','','GAITHERSBURG','MD','20882-2721','1','031','US','','A','50514737','','2005-02-15','2002-02-08','0000-00-00'),('N29PA','2162','8850306','',2000,4,1,4,'AMBROSE AIR CHARTER','3380 PRAIRIE N CIR','','LOGAN','IA','51545','3','085','US','1','V','50572147','','2003-06-23','2000-05-02','1952-11-19'),('N3154D','31952','2072602','17026',1955,4,1,4,'AMBLER KIRBY P','PO BOX 177','','WASHINGTON ISLAND','WI','54246-0177','C','029','US','1','V','50656114','','2003-04-16','2003-04-16','0000-00-00'),('N321AB','14523','7630315','41530',1979,4,1,1,'AMBROSINI ALFRED F','786 VANDERBILT RD','','CONNELLSVILLE','PA','15425-6218','1','051','US','1N','A','50671011','','2003-11-22','1998-05-22','1998-04-09'),('N335QS','560-0335','2076750','52113',1995,5,4,4,'AMBLER INDUSTRIES INC','C/O NETJETS SALES INC','TWO LEADERSHIP SQ 10TH FL','OKLAHOMA CITY','OK','73102','2','109','US','1T','V','50724721','','2005-12-08','2005-12-08','1995-12-16'),('N3607J','15064907','2071816','17020',1966,4,1,1,'AMBLO JAMES','RT7 BOX 5866','','CHARLOTTE','VT','05445','E','007','US','1U','V','51007642','','2003-12-02','2003-12-02','1966-08-20'),('N3716M','12-2657','7101202','41508',1947,4,1,1,'AMBLER ROBERT L','2769 NIPOMA STREET','','SAN DIEGO','CA','92106','4','073','US','410','A','51035270','','2003-02-18','1975-11-01','1979-01-31'),('N373X','6176C','5460134','',1976,4,1,1,'AMBERGER MARK E','10709 CHATANIKA LOOP','','EAGLE RIVER','AK','99577-8264','5','020','US','1N','V','51040375','','2005-04-20','2005-04-20','1976-05-17'),('N3935W','32-884','7103206','41532',1967,4,1,1,'AMBROSIO PHILLIP','7208 VIRGINIA AVE','','SAINT LOUIS','MO','63111-3018','3','189','US','1N','A','51110412','','2003-02-18','1997-01-30','1967-12-12'),('N399BP','25209','05610P4','41508',2000,4,1,3,'AMBER AIR LLC','491 W 3RD ST','','LEXINGTON','KY','40508-1752','7','067','US','42','V','51122137','','2006-01-12','2003-10-20','2000-09-12'),('N4KA','4285','1181506','03020',1993,6,3,3,'AMBROSE CORP','2321 NW AVIATION DR','','ROSEBURG','OR','97470-1974','S','019','US','1N','V','51124321','','2006-01-06','2005-10-26','1993-10-05'),('N4256Z','14846','7100510','17008',1945,4,1,2,'AMBROSI NICHOLAS S','28364 N OAK LN','','LIBERTYVILLE','IL','60048-9762','C','097','US','1N','A','51210564','','2004-04-20','1998-04-14','1998-08-31'),('N456LC','434','2808002','',2000,4,1,3,'AMBER AVIATION LTD','10500 PROSPECT DR','','ANCHORAGE','AK','99516-1200','5','020','US','','A','51304543','','2004-01-20','1995-08-03','0000-00-00'),('N4562W','13052','7630306','41515',1976,4,1,3,'AMBER WINGS INC','1607 BURNWOOD RD','','BALTIMORE','MD','21239','1','005','US','1N','8','51305431','','1999-02-17','1987-02-20','1976-07-15'),('N47283','L-5212','8850408','17003',1943,4,1,1,'AMBROSICH STEVEN L','567 22 1/2 ROAD','','GRAND JUNCTION','CO','81501','S','077','US','1','9','51346024','','1977-07-09','1975-11-08','0000-00-00'),('N4741Y','7AC-5637','2110102','',2000,4,1,1,'AMBER JAMES W','69 N 43RD RD','','MENDOTA','IL','61342-9512','C','099','US','1','A','51351210','','2003-05-20','1997-04-30','1956-09-25'),('N49929','15281400','2071835','41505',1978,4,1,1,'AMBROULT JOHN A DBA','240 GEORGE RYDER RD','','CHATHAM','MA','02633-1617','E','001','US','1U','V','51432107','','2003-08-26','2003-08-26','1978-02-22'),('N5132K','NAV-4-2032B','6150170','41521',1950,4,1,3,'AMBASSADOR CARTAGE INC','6010 NW 52ND TER','','KANSAS CITY','MO','64151-3152','3','165','US','1','A','51467474','','2004-04-20','2001-04-23','1956-04-18'),('N5303S','R18201538','2072735','41532',1980,4,1,3,'AMBER AIR INC','5206 S 44TH ST','','ROGERS','AR','72758-8891','2','007','US','1N','V','51531477','','2004-02-13','2004-02-13','1980-03-24'),('N5382S','337-0482','2075704','17025',1966,5,1,1,'AMBROULT JOHN A','240 GEORGE RYDER RD','','CHATHAM','MA','02633-1617','E','001','US','1N','A','51550324','','2004-05-18','1998-06-04','1966-08-01'),('N5500S','44-63655','6402309','54558',1944,4,1,3,'AMBHIB INC','555 OAKWOOD RD','','LAKE ZURICH','IL','60047-1558','C','097','US','2','A','51600724','','2005-11-15','1998-08-24','2001-08-08'),('N5719B','33719','2072702','17026',1956,4,1,1,'AMBER LEE','1012 E HILTON DR','','BOULDER CREEK','CA','95006-9351','4','087','US','1','V','51652665','','2006-01-20','2006-01-20','1956-08-31'),('N59427','1132','1181511','03020',2000,6,3,3,'AMBROSINI HELICOPTERS INC','4497 W MADISON AVE','','FRESNO','CA','93760','4','019','US','314','A','51727401','','2005-12-20','1988-06-25','1988-03-11'),('N6102B','5524','1880216','00000',1989,2,0,1,'AMBEAU ROBERT','PO BOX 729','','GONZALES','LA','70707-0729','2','005','US','1B','A','51770536','','2003-04-15','1989-04-17','1989-03-29'),('N6230J','32R-7680337','7103213','41533',1976,4,1,3,'AMBLER AIR SERVICE','PO BOX 7','','AMBLER','AK','99786-0007','5','188','US','1N','A','52021703','','2004-05-18','1992-06-17','1976-06-14'),('N6426H','20700521','2073604','17032',1979,4,1,4,'AMBLER AIR SERVICE','GENERAL DELIVERY','','AMBLER','AK','99786','5','188','US','1N','A','52067733','','2005-02-15','1981-01-20','1979-04-10'),('N6456F','15063056','2071814','17020',1966,4,1,1,'AMB PARNELL G','RT 1 BOX 64','','PORTLAND','ND','58274','C','097','US','1U','A','52075376','','2005-10-18','1990-10-10','1966-02-02'),('N6492Z','25-2013','7102504','41532',1962,4,1,1,'AMBROSE BILL','ROUTE 1 BOX 552','','BUCKEYE','AZ','00000','4','013','US','','9','52104540','','1977-01-14','1966-04-04','0000-00-00'),('N6555S','15067355','2071818','17020',1967,4,1,1,'AMBROSE JAMES H','290 NATHAN LN','','DYERSBURG','TN','38024-6322','7','045','US','1U','V','52121145','','2005-08-10','2005-08-10','1967-10-01'),('N65884','48630','6450102','67028',2000,5,1,3,'AMBROSE FRANK AVIATION CO INC','BOX 181 INTNTL ARPT','','MIAMI','FL','00000','7','025','US','','9','52126777','','1977-01-14','0000-00-00','0000-00-00'),('N66088','15075825','2071830','17020',1974,4,1,1,'AMBURGY JAMES J','21311 LEONARD AVE','','PORT CHARLOTTE','FL','33954-3116','7','015','US','1U','V','52133712','','2005-08-01','2005-08-01','1974-06-22'),('N670JD','S550-0019','2076607','99999',1984,5,4,3,'AMBER SERVICES INC','670 N CLARK ST','','CHICAGO','IL','60610-6259','C','031','US','1T','A','52156204','','2004-12-21','2001-10-30','1984-12-18'),('N6845M','21061996','2073451','17040',1977,4,1,3,'AMBERGATE LTD','2655 NE 30TH PLACE','','FT LAUDERDALE','FL','33306','7','011','US','1N','8','52212446','','1985-11-02','1979-02-01','1977-05-27'),('N690SG','11146','0141722','01514',1974,5,2,3,'AMBER AVIATION','318 GRANGE HALL RD','','BEAVERCREEK','OH','45430-2024','C','113','US','1N','A','52226115','','2003-03-18','1997-03-06','1997-03-05'),('N700AM','33701801','2075730','',2000,5,1,1,'AMBROULT JOHN DBA','240 GEORGE RYDER RD','','CHATHAM','MA','02633-1617','E','001','US','1N','A','52252232','','2005-06-21','2002-06-20','1977-06-24'),('N70446','17443','7100510','17003',1946,4,1,1,'AMBROSICH BILL','9890 COLE RD','','PILOT POINT','TX','76258-6719','2','121','US','1','V','52263155','','2003-12-04','1988-07-28','1956-06-06'),('N7094Y','30-109','7103002','41509',1963,5,1,3,'AMBIAIR INC','936 HILLSIDE AVENUE','','ROCHESTER','NY','14618','1','055','US','1N','8','52274370','','1985-12-28','1979-01-31','1963-09-25'),('N7197A','29297','2072402','17022',1956,4,1,2,'AMBROSECCHIA DOMINICK F','15050 BECKNER STREET','','LA PUENTE','CA','91744','4','037','US','1','9','52320312','','1977-01-14','1973-07-09','0000-00-00'),('N721BH','310H0143','2074222','17027',1963,5,1,3,'AMBER AIRPLANE LLC','25225 LA LOMA DR','','LOS ALTOS HILLS','CA','94022-4540','4','085','US','1','A','52323544','','2005-03-15','2002-03-13','0000-00-00'),('N7278G','18280502','2072701','41530',1999,4,1,1,'AMBROSE GEORGE P','4050 N 2100 E','','FILER','ID','83328-5042','S','083','US','1N','A','52340404','','2004-06-15','2001-06-06','1999-04-29'),('N7412B','7EC-444','21101NM','17009',1956,4,1,1,'AMBROSE ANTHONY C','7161 BURRIDGE AVE','','MENTOR','OH','44060-5005','C','085','US','1','A','52374341','','2004-07-20','1998-07-11','1956-06-14'),('N74716','1716','5870206','41514',1961,4,1,1,'AMBLE TOD','7726 103RD ST NE','','SARLES','ND','58372-9691','C','019','US','1','A','52407445','','2005-06-21','1995-03-30','1961-02-14'),('N75708','13296','7100510','17008',1945,4,1,3,'AMBLIN ANTIQUE AIR INC','3709 ASHBY DR','','FLOWER MOUND','TX','75022-8460','2','121','US','1','V','52433203','','2003-12-08','2003-12-08','1954-10-10'),('N78913','1942','5870208','41514',1961,4,1,4,'AMBROSE GARY L','140 TRAFTON RD','','CAMDEN','NC','27921-7605','7','029','US','1','A','52532214','','2003-07-15','2000-07-25','1961-11-03'),('N79308','17258033','2072430','41508',1969,4,1,1,'AMBROSE CHRIS','3940 BENJAMIN NE','','GRAND RAPIDS','MI','49505','C','081','US','1NU','A','52542643','','2003-04-15','1990-06-28','1969-04-10'),('N806SB','64-14023','1181410','41552',1964,6,3,3,'AMBROSINI HELICOPTERS INC','4497 W MADISON','','FRESNO','CA','93706','4','019','US','3124570','A','52574671','','2003-12-16','1994-11-29','1994-10-12'),('N8229A','32R-7987045','7103216','41533',1979,4,1,3,'AMBER ENGINEERING & MANUF CO INC','2375 ESTES AVE','','ELK GROVE VILLAGE','IL','60007','C','031','US','1N','8','52635735','','1991-12-07','1985-02-28','1980-04-18'),('N8362D','34-8133052','7103420','17070',1981,5,1,3,'AMBASSADOR LEASING INC','30 OLD RUDNICK LN','','DOVER','DE','19901-4912','1','001','US','1N','A','52670506','','2005-12-20','1995-10-31','1981-03-18'),('N83881','7AC-2562','2110102','17003',1946,4,1,1,'AMBROSE ROGER H','278 E MADISON RD','','MADISON','NH','03849-5834','E','003','US','1N','A','52674634','','2005-02-22','1994-06-23','1947-06-17'),('N8480E','2651','1181026','41526',1961,6,1,1,'AMBROSE WALT JR','RR 1 BOX 24','','WALNUT','IA','51577','3','155','US','6134','A','52717756','','2003-07-15','1990-07-31','1962-07-31'),('N852AB','09031522','05619IR','',2000,4,1,1,'AMBROSE MARK E','2508 PINEY PASS WAY','','ODENTON','MD','21113-3690','1','003','US','','V','52727310','','2005-04-15','2005-04-15','0000-00-00'),('N9087K','108-2087','9230404','27024',1947,4,1,1,'AMBROSE CHRIS D','2910 US HIGHWAY 60 E','','REPUBLIC','MO','65738-9477','3','077','US','1','V','53110073','','2005-04-11','2005-04-11','1956-05-05'),('N92147','18260063','2072730','17026',1969,4,1,3,'AMBER LEASING INC','465 PALM AVE','','ORMOND BEACH','FL','32174','7','127','US','1N','A','53142345','','2004-09-21','1989-06-29','1969-11-17'),('N930AG','10196','2990000','09050',1996,4,1,3,'AMBASSADOR AVIATION LLC','6410 CROSSBOW CT','','DAVIE','FL','33331-2917','7','011','US','1U','V','53162660','','2003-03-27','2003-03-27','1996-10-29'),('N942GN','3360031','2075602','',2000,5,1,1,'AMBROULT JOHN A DBA','240 GEORGE RYDER RD','','CHATHAM','MA','02633-1617','E','001','US','1N','A','53212471','','2005-07-19','2002-07-18','1963-06-20'),('N9455C','31853','2072602','17026',1955,4,1,1,'AMBLER JAMES W','069 N 43RD RD','','MENDOTA','IL','61342','C','099','US','1','A','53221305','','2005-12-20','1993-11-29','1956-06-23'),('N9629M','20700712','2073614','17040',1981,4,2,3,'AMBER AIR INC','8205 N 67TH AVE','','GLENDALE','AZ','85302-5505','4','013','US','1N','A','53263463','','2004-02-17','1998-02-24','1981-06-29'); /*!40000 ALTER TABLE `test_table2` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2006-11-10 1:41:46