aircraft_registration.sql

-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 28, 2014 at 09:19 AM
-- Server version: 5.5.36-cll
-- PHP Version: 5.4.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `barriesp_spotter`
--

-- --------------------------------------------------------

--
-- Table structure for table `aircraft_registration`
--

CREATE TABLE IF NOT EXISTS `aircraft_registration` (
  `aircraft_registration_id` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(999) NOT NULL,
  `registration_prefix` varchar(999) NOT NULL,
  PRIMARY KEY (`aircraft_registration_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=242 ;

--
-- Dumping data for table `aircraft_registration`
--

INSERT INTO `aircraft_registration` (`aircraft_registration_id`, `country`, `registration_prefix`) VALUES
(1, 'Afghanistan', 'YA'),
(2, 'Albania', 'ZA'),
(3, 'Algeria', '7T'),
(4, 'Andorra', 'C3'),
(5, 'Angola', 'D2'),
(6, 'Anguilla', 'VP'),
(7, 'Antigua and Barbuda', 'V2'),
(8, 'Argentina', 'LV'),
(9, 'Argentina', 'LQ'),
(10, 'Armenia', 'EK'),
(11, 'Aruba', 'P4'),
(12, 'Australia', 'VH'),
(13, 'Austria', 'OE'),
(14, 'Azerbaijan', '4K'),
(15, 'Bahamas', 'C6'),
(16, 'Bahrain', 'A9C'),
(17, 'Bangladesh', 'S2'),
(18, 'Barbados', '8P'),
(19, 'Belarus', 'EW'),
(20, 'Belgium', 'OO'),
(21, 'Belize', 'V3'),
(22, 'Benin', 'TY'),
(23, 'Bermuda', 'VP'),
(24, 'Bermuda', 'VQ'),
(25, 'Bhutan', 'A5'),
(26, 'Bolivia', 'CP'),
(27, 'Bosnia and Herzegovina', 'T9'),
(28, 'Bosnia and Herzegovina', 'E7'),
(29, 'Botswana', 'A2'),
(30, 'Brazil', 'PP'),
(31, 'Brazil', 'PR'),
(32, 'Brazil', 'PT'),
(33, 'Brazil', 'PU'),
(34, 'British Virgin Islands', 'VP'),
(35, 'Brunei', 'V8'),
(36, 'Bulgaria', 'LZ'),
(37, 'Burkina Faso', 'XT'),
(38, 'Burundi', '9U'),
(39, 'Cambodia', 'XU'),
(40, 'Cameroon', 'TJ'),
(41, 'Canada', 'C'),
(42, 'Cape Verde', 'D4'),
(43, 'Cayman Islands', 'VP'),
(44, 'Central African Republic', 'TL'),
(45, 'Chad', 'TT'),
(46, 'Chile', 'CC'),
(47, 'Republic of China (Taiwan)', 'B'),
(48, 'People''s Republic of China', 'B'),
(49, 'Hong Kong', 'B'),
(50, 'Hong Kong', 'B'),
(51, 'Hong Kong', 'B'),
(52, 'Macau, China', 'B'),
(53, 'Colombia', 'HU'),
(54, 'Colombia', 'HK'),
(55, 'Comoros', 'D6'),
(56, 'Congo, Republic of', 'TN'),
(57, 'Cook Islands', 'E5'),
(58, 'Congo, Democratic Republic of', '9Q'),
(59, 'Costa Rica', 'TI'),
(60, 'C?te d''Ivoire', 'TU'),
(61, 'Croatia', '9A'),
(62, 'Cuba', 'CU'),
(63, 'Cyprus, Republic of', '5B'),
(64, 'Czech Republic', 'OK'),
(65, 'Denmark', 'OY'),
(66, 'Djibouti', 'J2'),
(67, 'Dominica', 'J7'),
(68, 'Dominican Republic', 'HI'),
(69, 'East Timor', '4W'),
(70, 'East Timor', 'N1'),
(71, 'Ecuador', 'HC'),
(72, 'Egypt', 'SU'),
(73, 'El Salvador', 'YS'),
(74, 'Equatorial Guinea', '3C'),
(75, 'Eritrea', 'E3'),
(76, 'Estonia', 'ES'),
(77, 'Ethiopia', 'ET'),
(78, 'Falkland Islands', 'VP'),
(79, 'Fiji Islands', 'DQ'),
(80, 'Finland', 'OH'),
(81, 'France', 'F'),
(82, 'French West Indies', 'F'),
(83, 'French Guyana', 'F'),
(84, 'Gabon', 'TR'),
(85, 'Gambia', 'C5'),
(86, 'Georgia', '4L'),
(87, 'Germany', 'D'),
(88, 'Ghana', '9G'),
(89, 'Gibraltar', 'VP'),
(90, 'Greece', 'SX'),
(91, 'Grenada', 'J3'),
(92, 'Guatemala', 'TG'),
(93, 'Guinea', '3X'),
(94, 'Guinea Bissau', 'J5'),
(95, 'Guyana', '8R'),
(96, 'Haiti', 'HH'),
(97, 'Honduras', 'HR'),
(98, 'Hungary', 'HA'),
(99, 'Iceland', 'TF'),
(100, 'India', 'VT'),
(101, 'Indonesia', 'PK'),
(102, 'Iran', 'EP'),
(103, 'Iraq', 'YI'),
(104, 'Ireland', 'EI'),
(105, 'Israel', '4X'),
(106, 'Italy', 'I'),
(107, 'Jamaica', '6Y'),
(108, 'Japan', 'JA'),
(109, 'Jersey', 'ZJ'),
(110, 'Jordan', 'JY'),
(111, 'Kosovo, Republic of', 'Z6'),
(112, 'Kazakhstan', 'UP'),
(113, 'Kenya', '5Y'),
(114, 'Kiribati', 'T3'),
(115, 'Korea, People''s Democratic Rep.', 'P'),
(116, 'Korea, Republic of', 'HL'),
(117, 'Kuwait', '9K'),
(118, 'Kyrgyzstan', 'EX'),
(119, 'Laos', 'RDPL'),
(120, 'Latvia', 'YL'),
(121, 'Lebanon', 'OD'),
(122, 'Lesotho', '7P'),
(123, 'Liberia', 'A8'),
(124, 'Libya', '5A'),
(125, 'Liechtenstein', 'HB'),
(126, 'Lithuania', 'LY'),
(127, 'Luxembourg', 'LX'),
(128, 'Macedonia, Republic of', 'Z3'),
(129, 'Madagascar', '5R'),
(130, 'Malawi', '7Q'),
(131, 'Malaysia', '9M'),
(132, 'Maldives', '8Q'),
(133, 'Mali', 'TZ'),
(134, 'Malta', '9H'),
(135, 'Isle of Man[13]', 'M'),
(136, 'Marshall Islands', 'V7'),
(137, 'Mauritania', '5T'),
(138, 'Mauritius', '3B'),
(139, 'Mexico', 'XA'),
(140, 'Mexico', 'XB'),
(141, 'Mexico', 'XC'),
(142, 'Micronesia, Federated States of', 'V6'),
(143, 'Moldova', 'ER'),
(144, 'Monaco', '3A'),
(145, 'Mongolia', 'JU'),
(146, 'Montenegro', '4O'),
(147, 'Montserrat', 'VP'),
(148, 'Morocco', 'CN'),
(149, 'Mozambique', 'C9'),
(150, 'Myanmar', 'XY'),
(151, 'Myanmar', 'XZ'),
(152, 'Namibia', 'V5'),
(153, 'Nauru', 'C2'),
(154, 'Nepal', '9N'),
(155, 'Netherlands', 'PH'),
(156, 'Netherlands Antilles', 'PJ'),
(157, 'New Zealand', 'ZK'),
(158, 'Nicaragua', 'YN'),
(159, 'Niger', '5U'),
(160, 'Nigeria', '5N'),
(161, 'Norway', 'LN'),
(162, 'Oman', 'A4O'),
(163, 'Pakistan', 'AP'),
(164, 'Pakistan', 'AR'),
(165, 'Palestine', 'SU'),
(166, 'Palestine', 'E4'),
(167, 'Panama', 'HP'),
(168, 'Papua New Guinea', 'P2'),
(169, 'Paraguay', 'ZP'),
(170, 'Peru', 'OB'),
(171, 'Philippines', 'RP'),
(172, 'Philippines', 'RP'),
(173, 'Philippines', 'RP'),
(174, 'Philippines', 'RP'),
(175, 'Philippines', 'RP'),
(176, 'Poland', 'SP'),
(177, 'Poland', 'SN'),
(178, 'Portugal', 'CR'),
(179, 'Portugal', 'CS'),
(180, 'Qatar', 'A7'),
(181, 'Raunion Island', 'F'),
(182, 'Romania', 'YR'),
(183, 'Russian Federation', 'RA'),
(184, 'Russian Federation', 'RF'),
(185, 'Rwanda', '9XR'),
(186, 'Saint Helena/Ascension', 'VQ'),
(187, 'Saint Kitts and Nevis', 'V4'),
(188, 'Saint Lucia', 'J6'),
(189, 'Saint Vincent and the Grenadines', 'J8'),
(190, 'Samoa', '5W'),
(191, 'San Marino', 'T7'),
(192, 'S?o Tom? and Pr?_ncipe', 'S9'),
(193, 'Saudi Arabia', 'HZ'),
(194, 'Senegal', '6V'),
(195, 'Serbia', 'YU'),
(196, 'Seychelles', 'S7'),
(197, 'Sierra Leone', '9L'),
(198, 'Singapore', '9V'),
(199, 'Slovakia', 'OM'),
(200, 'Slovenia', 'S5'),
(201, 'Solomon Islands', 'H4'),
(202, 'Somalia', '6O'),
(203, 'South Africa', 'ZS'),
(204, 'South Africa', 'ZT'),
(205, 'South Africa', 'ZU'),
(206, 'South Sudan', ''),
(207, 'Spain', 'EC'),
(208, 'Sri Lanka', '4R'),
(209, 'Sudan', 'ST'),
(210, 'Surinam', 'PZ'),
(211, 'Swaziland', '3D'),
(212, 'Sweden', 'SE'),
(213, 'Switzerland', 'HB'),
(214, 'Syria', 'YK'),
(215, 'Tahiti', 'F'),
(216, 'Tajikistan', 'EY'),
(217, 'Tanzania', '5H'),
(218, 'Thailand', 'HS'),
(219, 'Togo', '5V'),
(220, 'Tonga', 'A3'),
(221, 'Trinidad and Tobago', '9Y'),
(222, 'Tunisia', 'TS'),
(223, 'Turkey', 'TC'),
(224, 'Turkmenistan', 'EZ'),
(225, 'Turks and Caicos', 'VQ'),
(226, 'Tuvalu', 'T2'),
(227, 'Uganda', '5X'),
(228, 'Ukraine', 'UR'),
(229, 'United Arab Emirates', 'A6'),
(230, 'United Kingdom', 'G'),
(231, 'United NationsN3', '4U'),
(232, 'United States of America', 'N'),
(233, 'Uruguay', 'CX'),
(234, 'Uzbekistan', 'UK'),
(235, 'Vanuatu', 'YJ'),
(236, 'Venezuela', 'YV'),
(237, 'Vietnam', 'VN'),
(238, 'Yemen', '7O'),
(239, 'Zambia', '9J'),
(240, 'Zimbabwe', 'Z'),
(241, 'United Arab Emirates', 'E6');

/*!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 */;