In [301]:
import sys
assert sys.version_info.major == 3 and sys.version_info.minor == 7, 'Sorry. 3.7 or 3.8 only. f-strings.'
In [307]:
%%javascript
//hack to fix export
require.config({
  paths: {
    d3: 'https://cdnjs.cloudflare.com/ajax/libs/d3/5.9.2/d3',
    jquery: 'https://code.jquery.com/jquery-3.4.1.min',
    plotly: 'https://cdn.plot.ly/plotly-latest.min'
  },

  shim: {
    plotly: {
      deps: ['d3', 'jquery'],
      exports: 'plotly'
    }
  }
});
In [26]:
import requests, re, csv, pickle
import pandas as pd
import numpy as np
import pickle
import re

from plotly.offline import iplot, init_notebook_mode
import plotly.graph_objs as go
init_notebook_mode()
In [24]:
class Wiki():
    api = "https://en.wikipedia.org/w/api.php"
    
    def __init__(self, category, 
                 no_views=False, 
                 no_content=False, 
                 custom_page_parser=None, 
                 extra_fields=None,
                 forbidden_categories_keywords=None):
        """
        custom_page_parser is for content mining. a function that given wiki text returns a dictionary of whatever it mined.
        Any extra fields need to be be added to extra_fields or to_csv will fail.
        """
        self.session = requests.Session()
        self.no_views = no_views
        self.no_content = no_content
        self.data = {}
        self.category = category
        self.category_cleaned = category.replace(' ','_').replace('Category:','')
        if custom_page_parser:
            self.custom_page_parser = custom_page_parser
        else:
            self.custom_page_parser = lambda text: {}
        if extra_fields:
            self.extra_fields = extra_fields
        else:
            self.extra_fields = []
        if forbidden_categories_keywords:
            self.forbidden_categories_keywords = forbidden_categories_keywords
        else:
            self.forbidden_categories_keywords = []
        
    def get(self, params):
        data = self.session.get(url=self.api, params=params).json()
        if 'continue' in data:
            params['cmcontinue'] = data['continue']['cmcontinue']
            t = list(data['query'].keys())[0]
            new_data = self.get(params)
            new_data['query'][t] = [*data['query'][t], *new_data['query'][t]]
            data = new_data
        return data
    
    def add_datum(self, data, cat):
        for d in data:
            name = d["title"]
            if name not in self.data:
                self.data[name] = d
                self.data[name]['category'] = cat
                if not self.no_views:
                    self.data[name]['views'] = self.get_pageviews(name)
                if not self.no_content:
                    wiki = self.get_content(name)
                    for key, value in self.custom_page_parser(wiki).items():
                        self.data[name][key] = value
            else:
                self.data[name]["category"] += '|' + cat
        
    def get_subcategories(self, cat):
        return [subcat for subcat in self.get_members(cat, 'subcat')
                       if all([k not in subcat['title'].lower() for k in self.forbidden_categories_keywords])]
    
    def get_pages(self,cat):
        return self.get_members(cat, 'page')
    
    def get_members(self, cat, cmtype='subcat|page'):
        params = {
            'action': "query",
            'list': "categorymembers",
            'cmtitle': cat,
            'cmtype': cmtype,
            'cmdir': "desc",
            'format': "json"
            }
        r = self.get(params)
        if 'query' not in r:
            print(f'{cat} replied with {str(r)}.')
            return []
        data = r['query']['categorymembers']
        self.add_datum(data, cat)
        return data
    
    def get_pages_recursively(self, cat=None):
        if cat is None:
            cat = self.category
        subcats = [s['title'] for s in self.get_subcategories(cat)]
        data = self.get_pages(cat)
        for c in subcats:
            ndata = self.get_pages_recursively(c)
            print(c, len(data),len(ndata))
            data.extend(ndata)
        return data
    
    def get_pageviews(self, page):
        url = f"https://wikimedia.org/api/rest_v1/metrics/pageviews/per-article/en.wikipedia/all-access/all-agents/{page.replace(' ','_')}/monthly/2018060100/2019060100"
        r = self.session.get(url).json()
        if 'items' in r:
            return sum([i['views'] for i in r['items']])/365
        else:
            print('error',page, r)
            return 'NA'
        
    def get_content(self,page):
        params = {
            'action': "query",
            'prop': 'revisions',
            'rvprop': 'content',
            'rvsection': 0,
            'titles': page,
            'format': "json"
            }
        data = self.session.get(url=self.api, params=params).json()
        pageid = list(data['query']['pages'].keys())[0]
        wikimarkup = data['query']['pages'][pageid]['revisions'][0]['*']
        return wikimarkup.encode('utf-8','ignore').decode('unicode_escape','ignore') #not quite right
    
    def to_csv(self):
        with open(f'{self.category_cleaned}.csv','w',newline='') as w:
            dw = csv.DictWriter(w,['title','category', 'ns','views','pageid']+self.extra_fields)
            dw.writeheader()
            dw.writerows(self.data.values())
        return self

## aircraft specific
class Planewiki(Wiki):
    """
    {|{{Infobox Aircraft Begin
     |name=A-132 Tangará
     |image =
     |caption=
    }}{{Infobox Aircraft Type
     |type=Primary trainer
     |national origin =[[Brazil]]
     |manufacturer=[[Embraer#Acquisition of Aerotec|Aerotec]]
     |first flight =26 February 1981
     |introduction=
     |retired =
     |status =
     |primary user=[[Bolivian Air Force]]
     |number built =7
     |developed from =Aerotec Uirapuru
    }}'''
    """
    
    def __init__(self, category, no_views=False, no_content=False):
        super().__init__(category, no_views=no_views, no_content=no_content,
                         custom_page_parser=self.plane_data,
                         extra_fields = ['first flight','number built','unit cost','introduction','retired','introduced','status'],
                         forbidden_categories_keywords=['airliner','9/11','deaths','organisation','ancident','iccident','squadron', 'fiction','film','novel','star wars','star trek'])
        #forbidden keywords have a title problem.
        

    def plane_data(self, wiki):
        data = {}
        for key in self.extra_fields:
            rex = re.search('\|'+key+'\s*\=\s*([^\n\|\<]+)',wiki)
            if rex:
                data[key] = rex.group(1).rstrip()
            else:
                data[key] = 'Error'
        return data
In [ ]:
# demo? try... Category:1980s Brazilian military aircraft
for title in ('Category:Cancelled aircraft projects','Category:Proposed_aircraft','Category:Military aircraft','Category:Civil aircraft'):
    plane = Planewiki(title)
    plane.get_pages_recursively()
    print('******',title, len(plane.data))
    plane.to_csv()
    pickle.dump(plane.data, open(f'{plane.category_cleaned}.p','wb'))
In [28]:
military = pickle.load(open('Military_aircraft.p','rb'))
civil = pickle.load(open('Civil_aircraft.p','rb'))
In [254]:
def get_built(txt):
    if isinstance(txt, float) or isinstance(txt, int):
        return txt
    elif isinstance(txt, str):
        txt_clean = txt.replace(',','').replace('.','')
        ## case 1. there are multiple xxxx: nnn
        rex = re.findall('.*?\:\s+(\d+)',txt_clean)
        if rex:
            n = 0
            for rexi in rex:
                n+=int(rexi)
            return n
        ## case 2.
        rex = re.search('(\d+)',txt_clean)
        if rex:
            return int(rex.group(1))
        else:
            return None
    else:
        return None

group_labels = ['Single','2-5','6-50','50-200','200-2,000','2,000+']
def groupify(nb):
    x = get_built(nb)
    if x == None:
        return 0
    elif x == 1:
        return 1
    elif x <=5:
        return 2
    elif x <=50:
        return 3
    elif x <=200:
        return 4
    elif x <=2_000:
        return 5
    else:
        return 6

def yearify(row):
    for val in (f"{row['first flight']}{row.introduced}{row.introduction}", str(row.category)):
        x = re.findall('((?:19|20)\d\d)', str(val))
        if x:
            v = min([int(n) for n in x])
            if v < 2020 and v > 1899:
                return v
    return None


def to_df(data):
    fulldataset = pd.DataFrame.from_records(list(data.values()))
    
    fulldataset = fulldataset.assign(built_group=fulldataset['number built'].apply(groupify))\
                             .assign(built_number=fulldataset['number built'].apply(get_built).values)\
                             .assign(views=fulldataset.views.apply(lambda x: float(x) if x != 'NA' else None))\
                             .assign(year= fulldataset.apply(yearify,axis=1))  
    
    ticon = lambda term: fulldataset.title.str.contains(term, regex=False, na=True)
    return fulldataset.loc[(~fulldataset.built_number.isnull()) &
                          (fulldataset.built_group != 0) & 
                          (~fulldataset.views.isnull()) &
                          (~ticon('Category:')) & 
                          (~ticon('Squadron')) & 
                          (~ticon('Division')) & 
                          (~ticon('Bomber Wing')) & 
                          (~ticon('Fighter Wing')) & 
                          (~ticon('Group'))]
mil_df = to_df(military)
civ_df = to_df(civil)
In [187]:
vio_traces = []
scatter_traces = []
pivot_traces = []
import re

for side, label, dataset, color, dark_color in (("negative", "civil", civ_df, "teal","blue"), ("positive", "military", mil_df, "coral","red")):    
    trace = {
                "type": 'violin',
                "x": dataset.built_group,
                "y": dataset.views,
                "name": label,
                "text": dataset.title,
                "side": side,
                "box": {
                    "visible": True
                },
                "meanline": {
                    "visible": True
                },
                'spanmode': 'hard',
                "line": {
                    "color": color
                }
            }
    vio_traces.append(trace)
    
    pivot = Counter(dataset.built_group)
    pivot_trace = go.Scatter(
                mode= 'lines',
                x= list(range(1,7)),
                y= [pivot[k] for k in range(1,7)],
                name= f'N in bin ({label})',
                text= correct_order,
                yaxis='y2',
                line={'color': color}
            )
    pivot_traces.append(pivot_trace)
    
    scatter_traces.append(go.Scatter(
            x = dataset.built_number+np.random.random_sample(size=len(dataset.built_number))/3,
            y = dataset.views,
            text = dataset.title,
            name = label,
            mode = 'markers',
            marker= {'opacity':0.2, 'color': dark_color}
            ))

iplot({'data': traces, #+pivot_traces
       'layout':{'title': 'Plane population vs. popularity',
                 'yaxis':{'title':'Daily views on Wiki page'},
                 'yaxis2': {
                    'overlaying': 'y', 'range': [0,600],
                    'side': 'right'},
                 'xaxis': {'ticktext': group_labels,
                 'tickvals': list(range(1,1+len(group_labels)))},
                 "violingap": 0,
                 "violinmode": "overlay"
                }
      })                
        
iplot({'data': traces, #+pivot_traces
       'layout':{'title': 'Plane population vs. popularity',
                 'yaxis':{'title':'Daily views on Wiki page', 'type': 'log'},
                 'yaxis2': {
                    'overlaying': 'y', 'range': [0,600],
                    'side': 'right'},
                 'xaxis': {'ticktext': group_labels,
                 'tickvals': list(range(1,1+len(group_labels)))},
                 "violingap": 0,
                 "violinmode": "overlay"
                }
      })  


iplot({'data':scatter_traces,
       'layout':{'title': 'Planes: population vs. popularity','xaxis':{'title':'Numbers built', 'type': 'log'},'yaxis':{'title':'Daily views on en.wiki', 'type': 'log'}}
      })

So the B1 bomber is a curious case. The infobox has two numbers, the first 5 units for the B1A, the second 100 units for the B1B. Therefore this shows how its not overly reliable...

In [305]:
scatter_traces = []
for label, dataset, dark_color in (("civil", civ_df, "teal"), ("military", mil_df, "coral")):
    df = dataset.loc[~dataset.year.isnull()].loc[~dataset.views.isnull()]
    scatter_traces.append(go.Scattergl(
                x = df.year,
                y = df.views,
                text = dataset.title,
                name = label,
                mode = 'markers',
                marker= {'opacity':0.2,
                         'color': dark_color,
                        'size': np.log2(df.built_number.values + 1),
                         'sizeref': 1.3,
                        'sizemin':0.2}
                ))
    
    
scale = np.array(range(4,13)) #73000.0
scatter_traces.append(go.Scattergl(
                            x = [1915+8*n for n in scale],
                            y = [0.3]*len(scale),
                            text = [str(2**n) for n in scale],
                            textposition='bottom center',
                            name = 'N built scale',
                            mode = 'markers+text',
                            marker= {'opacity':0.5,
                                     'color': 'darkorchid',
                                    'size': scale,
                                     'sizeref': 1.3,
                                    'sizemin':0.2}
                            ))   


iplot({'data':scatter_traces,
       'layout':{'title': 'Planes: Numbers built, year of introduction and wikipedia pagevisits',
                 'xaxis':{'title':'Year of introduction'},
                 'yaxis':{'title':'Daily views on en.wiki', 'type': 'log'},
                'shapes': [{
                            'type': 'rect',
                            'x0': 1939,
                            'y0': 0.1,
                            'x1': 1945,
                            'y1': 1e4,
                            'line': {
                            'width': 0,
                            },
                            'fillcolor': 'rgba(10, 10, 10, 0.1)',
                            },
                            {
                            'type': 'rect',
                            'x0': 1914,
                            'y0': 0.1,
                            'x1': 1918,
                            'y1': 1e4,
                            'line': {
                            'width': 0,
                            },
                            'fillcolor': 'rgba(10, 10, 10, 0.1)',
                            }
                          ]}
      })
In [246]:
# worst mil
mil_df.sort_values(['views'])
Out[246]:
category first flight introduced introduction ns number built pageid retired status title unit cost views built_group built_number year
5149 Category:1910s German fighter aircraft|Categor... October 1917 Error 0 1+3 unfinished prototypes 59595940 prototype only Aviatik (Berg) Dr.I Error 0.126027 1 1.0 1917.0
11118 Category:Mexican military aircraft June 1, 1980 Error Error 0 8 60519397 Error Retired (2006) DGRCN Tonatiuh MX-1 Error 0.493151 3 8.0 1980.0
1300 Category:Military aircraft of World War I|Cate... 1917 Error 0 1 60129786 Error Paul Schmitt Type 10 Error 0.564384 1 1.0 1917.0
3798 Category:1920s German military reconnaissance ... Error 0 2 60089208 Caspar U 2 Error 0.613699 2 2.0 1920.0
5055 Category:1920s German fighter aircraft|Categor... [[1924 in aviation Error 0 1 60094951 Caspar CS 14 Error 0.635616 1 1.0 1924.0
5056 Category:1920s German fighter aircraft|Categor... [[1924 in aviation Error 0 1 60094928 Caspar CJ 14 Error 0.638356 1 1.0 1924.0
3110 Category:1930s French military trainer aircraf... {{avyear Error 0 1 59879340 Lorraine-Hanriot LH.60 Error 0.679452 1 1.0 1930.0
1301 Category:Military aircraft of World War I|Cate... 1915 February 1917 Error 0 150-200 60129859 Error Paul Schmitt Type 7 Error 0.684932 4 150.0 1915.0
5111 Category:1910s German fighter aircraft|Categor... February 1917 Error 0 3 59884138 Hansa-Brandenburg W.16 Error 0.695890 2 3.0 1917.0
3799 Category:1920s German military reconnaissance ... [[1928 in aviation Error 0 1 59805491 Caspar C 36 Error 0.720548 1 1.0 1928.0
3920 Category:1930s French military reconnaissance ... 1931 Error 0 1 59837315 Levasseur PL.11 0.736986 1 1.0 1931.0
3141 Category:1920s French military trainer aircraf... 5 April 1923 Error 0 1 59851189 Blériot-SPAD S.64 0.753425 1 1.0 1923.0
3695 Category:1920s Japanese military reconnaissanc... 1925 Error 0 4~ 59613397 Aichi Experimental Type 15-Ko Reconnaissance S... 0.769863 2 4.0 1925.0
3136 Category:1920s French military trainer aircraf... 1921 Error 0 1 60141084 Caudron C.51 0.775342 1 1.0 1921.0
3800 Category:1920s German military reconnaissance ... [[1926 in aviation Error 0 1 59805209 Caspar C 30 Error 0.780822 1 1.0 1926.0
1383 Category:Military aircraft of World War I|Cate... February 1916 Error 0 1 59721596 Bréguet XI Corsaire 0.783562 1 1.0 1916.0
6431 Category:1920s Czechoslovakian fighter aircraf... {{avyear Error 0 1 59905795 Letov Š-12 0.789041 1 1.0 1920.0
3919 Category:1930s French military reconnaissance ... 1930 Error 0 1 59837378 Levasseur PL.12 0.802740 1 1.0 1930.0
3139 Category:1920s French military trainer aircraf... 21 August 1928 Error 0 15 59851078 Blériot-SPAD S.92 0.819178 3 15.0 1928.0
1670 Category:1910s German military utility aircraf... {{avyear Error 0 6 59897398 Gotha LD 5 Error 0.830137 3 6.0 1910.0
3117 Category:1920s French military trainer aircraf... 1929 Error 0 2 59869930 Morane-Saulnier MS.250 0.830137 2 2.0 1929.0
3191 Category:1920s Czechoslovakian military traine... July 1930 Error 0 1 59905937 Letov Š-25 0.838356 1 1.0 1930.0
3753 Category:1910s international military reconnai... November 1922 Error 0 2 60146928 FBA 10 Error 0.846575 2 2.0 1922.0
4029 Category:1920s Czechoslovakian military reconn... {{avyear Error 0 1 59905717 Letov Š-5 0.865753 1 1.0 1920.0
5322 Category:1910s French fighter aircraft|Categor... 1918 Error 0 2 60155331 Courtois-Suffit Lescop CSL-1 Error 0.871233 2 2.0 1918.0
3790 Category:1920s German military reconnaissance ... 1928 Error 0 2 59886035 Heinkel HD 30 Error 0.876712 2 2.0 1928.0
1293 Category:Military aircraft of World War I|Cate... 1917 Error 0 1 59825289 Roland C.VIII 0.879452 1 1.0 1917.0
4433 Category:Fighter aircraft|Category:Fighter air... 14 January 1923 Error 0 1 59851260 Blériot-SPAD S.71 Error 0.879452 1 1.0 1923.0
3611 Category:1920s Soviet and Russian military rec... 2 June 1925 Error 0 1 59840757 Grigorovich MRL-1 0.884932 1 1.0 1925.0
3142 Category:1920s French military trainer aircraf... 13 April 1923 Error 0 1 59851135 Blériot-SPAD S.62 0.901370 1 1.0 1923.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2350 Category:1980s United States military transpor... 19 March 1989 13 June 2007 Error 0 200+ as of 2014 32814 Error In service Bell Boeing V-22 Osprey MV-22: US$72.1 million ([[flyaway cost]] for F... 1892.989041 4 200.0 1989.0
6462 Category:2010s Chinese fighter aircraft|Catego... 11 January 2011 10 March 2017 Error 0 8 prototypes 30236719 In service Chengdu J-20 • US$100-$120 million 1977.657534 3 8.0 2011.0
344 Category:United States military helicopters|Ca... 17 October 1974 1979 Error 0 About 4,000 37941 In service Sikorsky UH-60 Black Hawk UH-60: US$21.3&nbsp;million (avg. U.S. procure... 2006.975342 6 4000.0 1974.0
1045 Category:World War II bombers of the United St... {{Start date and age Error {{Start date and age 0 12,731 4997 1968 ([[Brazilian Air Force]]) Boeing B-17 Flying Fortress {{plainlist 2017.961644 6 12731.0 1930.0
4727 Category:1980s Swedish fighter aircraft|Catego... 9 December 1988 9 June 1996 Error 0 Approx. 247{{#tag:ref 87577 In service Saab JAS 39 Gripen US$ 30–60 million for JAS 39C 2047.578082 5 247.0 1988.0
1044 Category:World War II bombers of the United St... 21 September 1942 8 May 1944 Error 0 3,970 53179 21 June 1960 Retired (see [[Boeing B-29 Superfortress#Survi... Boeing B-29 Superfortress US$639,188 2066.515068 6 3970.0 1942.0
4763 Category:2000s Russian fighter aircraft|Catego... Su-27M: 28 June 1988 February 2014 Error 0 Su-27M: 14 314292 In service Sukhoi Su-35 US$40–65&nbsp;million (Su-35S) 2102.767123 3 14.0 1988.0
6554 Category:1930s British fighter aircraft|Catego... 5 March 1936 Error 4 August 1938 0 20,351 26027181 1961 [[Irish Air Corps]] Error Supermarine Spitfire £12,604 (£774,905 or $1,002,639 in 2017) ([[... 2170.805479 6 20351.0 1936.0
3517 Category:1950s United States military reconnai... 1 August 1955 1957 Error 0 104 32310 Error In service Lockheed U-2 $950,000 in 1955 (equivalent to ${{inflation 2236.887671 4 104.0 1955.0
387 Category:United States military helicopters|Ca... 21 September 1961 1962 Error 0 Over 1,200 as of 2012 38005 In service Boeing CH-47 Chinook US$38.55 million (CH-47F, FY13) 2244.720548 5 1200.0 1961.0
333 Category:Attack helicopters|Category:United St... 30 September 1975 April 1986 Error 0 2,000 {{as of 37746 In service Boeing AH-64 Apache {{plainlist 2246.021918 5 2000.0 1975.0
4781 Category:1970s Soviet fighter aircraft|Categor... 6 October 1977 July 1982 Error 0 1,600+ 185653 In service Mikoyan MiG-29 {{US$ 2254.693151 5 1600.0 1977.0
4552 Category:1940s United States fighter aircraft|... 26 October 1940 Error January 1942 (RAF) 0 More than 15,000 24710 Error Retired from military service 1984 (Dominican ... North American P-51 Mustang US$50,985 in 1945 2289.282192 6 15000.0 1940.0
6901 Category:1970s United States bomber aircraft|C... 23 December 1974 Error 1 October 1986 0 B-1A: 4 4952 In service Rockwell B-1 Lancer B-1B: [[United States dollar 2345.627397 2 4.0 1974.0
2363 Category:1950s United States military transpor... 23 August 1954 December 1956 Error 0 Over 2,500 as of 2015 7697 In service Lockheed C-130 Hercules C-130E: [[US dollar 2362.249315 6 2500.0 1954.0
2347 Category:1990s United States military transpor... 15 September 1991 17 January 1995 Error 0 279 6731 In service Boeing C-17 Globemaster III US$218 million ([[flyaway cost]] for FY 2007) 2377.953425 5 279.0 1991.0
4507 Category:1950s United States fighter aircraft|... 27 May 1958 30 December 1960 Error 0 5,195 11759 1992 (United Kingdom) In limited service McDonnell Douglas F-4 Phantom II {{US$ 2420.468493 6 5195.0 1958.0
4476 Category:1970s United States fighter aircraft|... 21 December 1970 22 September 1974 Error 0 712 11719 22 September 2006 ([[United States Navy]]) In service with the Islamic Republic of Iran A... Grumman F-14 Tomcat [[United States dollar 2631.471233 5 712.0 1970.0
5007 Category:2000s Indian fighter aircraft|Categor... 4 January 2001 17 January 2015 Error 0 32 (including 16 prototypes as of March 2019) 749967 In service HAL Tejas {{INRConvert 2754.413699 3 32.0 2001.0
5002 Category:1990s international fighter aircraft|... 27 March 1994 4 August 2003 Error 0 558 167667 In service Eurofighter Typhoon €90&nbsp;million (system cost Tranche 3A) 2958.624658 5 558.0 1994.0
5175 Category:1970s French fighter aircraft|Categor... 10 March 1978 July 1984 Error 0 601 381535 In service Dassault Mirage 2000 $30.6 million 2959.597260 5 601.0 1978.0
7508 Category:1970s United States attack aircraft|C... 10 May 1972 October 1977 Error 0 716 12502446 In service Fairchild Republic A-10 Thunderbolt II US$18.8&nbsp;million 3050.219178 5 716.0 1972.0
4762 Category:2010s Russian fighter aircraft|Catego... 29 January 2010 Error 2019 (planned) 0 10 flyable prototypes 2971192 Final flight testing Sukhoi Su-57 T-50: US$50&nbsp;million 3089.608219 3 10.0 2010.0
4474 Category:1970s United States fighter aircraft|... 27 July 1972 9 January 1976 Error 0 F-15A/B/C/D/J/DJ: 1,198 11715 In production (2019) McDonnell Douglas F-15 Eagle F-15A/B: US$27.9&nbsp;million (1998) 3156.191781 5 1198.0 1972.0
6899 Category:1980s United States bomber aircraft|C... 17 July 1989 1 January 1997 Error 0 21 4396 Error In service Northrop Grumman B-2 Spirit $737&nbsp;million (1997 approx. [[flyaway cost... 3504.717808 3 21.0 1989.0
6911 Category:1950s United States bomber aircraft|C... 15 April 1952 February 1955 Error 0 744 18933037 In service Boeing B-52 Stratofortress B-52B: US$14.43&nbsp;million (1956); 3610.035616 5 744.0 1952.0
5172 Category:1980s French fighter aircraft|Categor... Rafale A demo: {{start date {{start date Error 0 175 ({{as of 33731380 In service Dassault Rafale Rafale B: €74M ([[flyaway cost]], FY2013) 4085.008219 4 175.0 1980.0
4465 Category:1990s United States fighter aircraft|... 7 September 1997 15 December 2005 Error 0 195 (8 test and 187 operational aircraft) 66299 In service Lockheed Martin F-22 Raptor US$150&nbsp;million ([[flyaway cost]] for FY2009) 4892.093151 4 195.0 1997.0
3504 Category:1960s United States military reconnai... 22 December 1964 January 1966 Error 0 32 55245 1998 (USAF), 1999 (NASA) Retired Lockheed SR-71 Blackbird $34 million 4928.797260 3 32.0 1964.0
4477 Category:1970s United States fighter aircraft|... 20 January 1974 (unplanned) 17 August 1978 Error 0 4,604 (June 2018) 11642 Error In service General Dynamics F-16 Fighting Falcon F-16A/B: {{US$ 5568.690411 6 4604.0 1974.0

2724 rows × 15 columns

In [247]:
#worst
civ_df.sort_values(['views'])
Out[247]:
category first flight introduced introduction ns number built pageid retired status title unit cost views built_group built_number year
3101 Category:1950s Polish civil utility aircraft|C... 17 May 1951 (S-3) Error Error 0 3 + 1 11128535 Error Error PZL S-4 Kania 2 Error 0.312329 2 3 1951.0
5312 Category:1930s French sport aircraft|Category:... 1936 Error Error 0 1 60125989 Error Error SFAN 5 }} 0.389041 1 1 1936.0
4510 Category:German sailplanes|Category:German sai... 0 1 60094158 Akaflieg Berlin B3 Charlotte II 0.553425 1 1 NaN
5592 Category:1910s French experimental aircraft 0 1 60115621 SELA monoplane 0.619178 1 1 1910.0
5056 Category:1930s French civil utility aircraft|C... 1 September 1953 Error 0 1 59873195 Petitbon RP-40 0.624658 1 1 1953.0
5987 Category:1930s Czechoslovakian sport aircraft|... 20 July 1936 Error 0 1 x Be-52; 1 x Be-56 60173716 Beneš-Mráz Be-56 Beta-Major Error 0.660274 1 1 1936.0
4829 Category:1910s German experimental aircraft 12 December 1918 Error 0 1 60099130 Friedrichshafen FF.67 0.668493 1 1 1918.0
4830 Category:1910s German experimental aircraft 13 August 1918 Error 0 1 60099038 Friedrichshafen FF.63 0.747945 1 1 1918.0
4512 Category:German sailplanes|Category:German sai... 0 1 60093957 Akaflieg Berlin B1 0.772603 1 1 NaN
5516 Category:1930s French civil trainer aircraft|C... {{avyear Error 0 2 59879281 Hanriot LH.30 Error 0.780822 2 2 1930.0
5572 Category:1930s French experimental aircraft 1936 Error Error 0 1 59873133 Error Error Payen AP.10 Error 0.783562 1 1 1936.0
5571 Category:1930s French experimental aircraft 1935 Error Error 0 1 59873097 Error Error Payen Pa.101 Error 0.868493 1 1 1935.0
5057 Category:1930s French civil utility aircraft|C... 5 April 1937 Error 0 1 59867253 Nicolas-Claude NC-2 Aquilon 0.871233 1 1 1937.0
2757 Category:1920s Soviet and Russian military rec... 2 June 1925 Error 0 1 59840757 Grigorovich MRL-1 0.884932 1 1 1925.0
2250 Category:1940s United States special-purpose a... October 1941 Error 0 1 59743469 Radioplane OQ-12 Error 0.915068 1 1 1941.0
5543 Category:1940s French experimental aircraft 21 November 1941 Error 0 1 59864603 Lioré et Olivier LeO 48 0.939726 1 1 1941.0
2758 Category:1920s Soviet and Russian military rec... July 1929 Error 0 1 59832193 Grigorovich MR-5 0.942466 1 1 1929.0
3912 Category:1920s Italian civil trainer aircraft|... [[1926 in aviation Error 0 1 59725273 CANT 12 Error 0.969863 1 1 1926.0
2759 Category:1920s Soviet and Russian military rec... 23 September 1926 Error 0 1 59840874 Grigorovich MR-2 1.000000 1 1 1926.0
3939 Category:1910s Italian experimental aircraft 1914 Error 0 1 59754110 Caproni Ca.25 1.027397 1 1 1914.0
8280 Category:1940s Soviet military transport aircr... 1943 Error 0 1 59807472 Polikarpov MP Error 1.090411 1 1 1943.0
4847 Category:1920s German cargo aircraft|Category:... {{avyear Error 0 1 59885951 Heinkel HD 27 Error 1.093151 1 1 1920.0
5481 Category:1920s French sailplanes|Category:1920... 1923 Error 0 at least 2 59833968 Dewoitine P-3 1.128767 2 2 1923.0
2248 Category:1940s United States special-purpose a... 1945 Error 0 5 59609554 OQ-15 Error 1.175342 2 5 1945.0
3829 Category:1950s Italian sailplanes|Category:195... 1952 Error Error 0 1 40954363 Error Sole example destroyed Rotondi R-1 Gheppio Error 1.197260 1 1 1952.0
3423 Category:Mexican civil aircraft [[1957]] Error Error 0 1 59637104 Error Retired Lascurain Aura Error 1.205479 1 1 1957.0
2756 Category:1920s Soviet and Russian military rec... Summer 1929 Error 0 1 59832077 Grigorovich ROM-2 1.213699 1 1 1929.0
3527 Category:1930s Japanese experimental aircraft 1939 Error 0 1 59629399 Yokosuka MXY1 Error 1.290411 1 1 1939.0
2831 Category:1920s Soviet and Russian civil aircra... 10 June 1925 Error 0 1 59807290 Polikarpov PM-1 Error 1.347945 1 1 1925.0
5042 Category:1940s French civil utility aircraft|C... 13 October 1946 Error 0 1 43941438 Boisavia Muscadet Error 1.350685 1 1 1946.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
6211 Category:1960s Canadian civil utility aircraft... 20 May 1965 1966 Error 0 Oct 2017: {{#expr:844+123}} 717467 In production De Havilland Canada DHC-6 Twin Otter US$680,000 (1972) 985.890411 6 2017 1965.0
2139 Category:1980s United States special-purpose a... May 16, 1987 August 23, 1990 Error 0 2 (VC-25A) 581260 In service Boeing VC-25 US$325 million 993.531507 2 2 1987.0
2627 Category:1960s Soviet civil utility aircraft|C... 7 July 1961 1967 Error 0 >17,000 and production continues today; world'... 957233 In service Mil Mi-8 Error 1010.898630 6 17000 1961.0
6326 Category:1990s Canadian business aircraft|Cate... 13 October 1996 1997 Error 0 816 (Oct 2018) 881260 Error In service, in production Bombardier Global Express 5000: US$50.44 million 1027.000000 5 816 1996.0
2811 Category:1970s Soviet cargo aircraft|Category:... 25 March 1971 June 1974 Error 0 960 229943 Error In production, in service Ilyushin Il-76 1028.682192 5 960 1971.0
8195 Category:1990s United States military transpor... 5 April 1996 1999 Error 0 400 as of February 2018 16172717 In service Lockheed Martin C-130J Super Hercules {{US$ 1030.134247 5 400 1996.0
2394 Category:1990s Swiss civil utility aircraft|Ca... 31 May 1991 1994 Error 0 1,500 ({{As of 914310 In production Pilatus PC-12 [[United States dollar 1031.252055 5 1500 1991.0
8324 Category:2000s international military transpor... 11 December 2009 2013 Error 0 80 371265 In service Airbus A400M Atlas [[Euro 1104.791781 4 80 2009.0
8004 Category:NASA aircraft 21 September 1964 Error 0 2 211782 4 February 1969 Retired North American XB-70 Valkyrie US$750&nbsp;million (average cost)(equivalent ... 1144.673973 2 2 1964.0
2780 Category:1960s Soviet military reconnaissance ... 6 March 1964 1970 Error 0 1,186 247960 In limited service Mikoyan-Gurevich MiG-25 1164.052055 5 1186 1964.0
386 Category:1970s United States civil utility air... October 27, 1972 1972 (Military) Error 0 3,781 at end of 2015 9023483 Active service Beechcraft Super King Air King Air 250: US$6.295M 1188.293151 6 3781 1972.0
2217 Category:1950s United States helicopters|Categ... 20 October 1956 (XH-40) 1959 Error 0 >16,000 38008 In service Bell UH-1 Iroquois 1285.865753 6 16000 1956.0
7890 Category:Racing aircraft|Category:Racing aircraft 29 May 1940 Error 28 December 1942 0 12,571 11721 1953 (United States) Error Vought F4U Corsair 1291.693151 6 12571 1940.0
2859 Category:1970s Soviet helicopters|Category:197... 1975 1977 (Mi-8MT), 1981 (Mi-17) Error 0 About 12,000 as of 2007 1493374 In service Mil Mi-17 Prices vary based on specifications (military ... 1297.665753 6 12000 1975.0
4028 Category:1990s international cargo aircraft|Ca... 13 September 1994 September 1995 Error 0 5 183548 In service Airbus Beluga €183 million 1328.482192 2 5 1994.0
4027 Category:2010s international cargo aircraft|Ca... 19 July 2018 Expected 2019 Error 0 3 47848500 Flight Testing Airbus Beluga XL Error 1341.791781 2 3 2018.0
1848 Category:1950s United States experimental airc... 8 June 1959 17 September 1959 Error 0 3 221315 December 1968 North American X-15 1431.821918 2 3 1959.0
8224 Category:1940s United States military transpor... November 2, 1947 Error 0 1 197878 On display Hughes H-4 Hercules $2.5 million 1655.690411 1 1 1947.0
2868 Category:1960s Soviet helicopters|Category:196... 19 September 1969 1972 Error 0 2,648 384591 In service Mil Mi-24 1702.808219 6 2648 1969.0
8202 Category:1960s United States military transpor... 30 June 1968 Error June 1970 0 131 (C-5A: 81, C-5B: 50) 160434 In service Lockheed C-5 Galaxy C-5A: [[United States dollar 1758.841096 4 131 1968.0
8199 Category:1980s United States military transpor... 19 March 1989 13 June 2007 Error 0 200+ as of 2014 32814 Error In service Bell Boeing V-22 Osprey MV-22: US$72.1 million ([[flyaway cost]] for F... 1892.989041 4 200 1989.0
2157 Category:1970s United States helicopters|Categ... 17 October 1974 1979 Error 0 About 4,000 37941 In service Sikorsky UH-60 Black Hawk UH-60: US$21.3&nbsp;million (avg. U.S. procure... 2006.975342 6 4000 1974.0
2808 Category:1980s Soviet cargo aircraft|Category:... 21 December 1988 Error 0 1 406245 In service Antonov An-225 Mriya 2176.846575 1 1 1988.0
2195 Category:1960s United States helicopters|Categ... 21 September 1961 1962 Error 0 Over 1,200 as of 2012 38005 In service Boeing CH-47 Chinook US$38.55 million (CH-47F, FY13) 2244.720548 5 1200 1961.0
2162 Category:1970s United States helicopters|Categ... 30 September 1975 April 1986 Error 0 2,000 {{as of 37746 In service Boeing AH-64 Apache {{plainlist 2246.021918 5 2000 1975.0
1966 Category:1980s United States cargo aircraft|Ca... February 19, 1982 January 1, 1983, with [[Eastern Air Lines]] Error 0 1,050 151995 In service Boeing 757 {{plainlist 2264.934247 5 1050 1982.0
8209 Category:1950s United States military transpor... 23 August 1954 December 1956 Error 0 Over 2,500 as of 2015 7697 In service Lockheed C-130 Hercules C-130E: [[US dollar 2362.249315 6 2500 1954.0
8197 Category:1990s United States military transpor... 15 September 1991 17 January 1995 Error 0 279 6731 In service Boeing C-17 Globemaster III US$218 million ([[flyaway cost]] for FY 2007) 2377.953425 5 279 1991.0
1963 Category:2000s United States cargo aircraft|Ca... 747-8F: February 8, 2010 747-8F: October 12, 2011, with [[Cargolux]] Error 0 130 as of December 2018 3166708 Error In service Boeing 747-8 747-8I: [[US$]]418.4M, 747-8F: US$419.2M as of... 2583.832877 4 130 2010.0
8008 Category:NASA aircraft 22 December 1964 January 1966 Error 0 32 55245 1998 (USAF), 1999 (NASA) Retired Lockheed SR-71 Blackbird $34 million 4928.797260 3 32 1964.0

1945 rows × 15 columns

In [249]:
# top mil
mil_df.sort_values(['views'],ascending=False)
Out[249]:
category first flight introduced introduction ns number built pageid retired status title unit cost views built_group built_number year
4477 Category:1970s United States fighter aircraft|... 20 January 1974 (unplanned) 17 August 1978 Error 0 4,604 (June 2018) 11642 Error In service General Dynamics F-16 Fighting Falcon F-16A/B: {{US$ 5568.690411 6 4604.0 1974.0
3504 Category:1960s United States military reconnai... 22 December 1964 January 1966 Error 0 32 55245 1998 (USAF), 1999 (NASA) Retired Lockheed SR-71 Blackbird $34 million 4928.797260 3 32.0 1964.0
4465 Category:1990s United States fighter aircraft|... 7 September 1997 15 December 2005 Error 0 195 (8 test and 187 operational aircraft) 66299 In service Lockheed Martin F-22 Raptor US$150&nbsp;million ([[flyaway cost]] for FY2009) 4892.093151 4 195.0 1997.0
5172 Category:1980s French fighter aircraft|Categor... Rafale A demo: {{start date {{start date Error 0 175 ({{as of 33731380 In service Dassault Rafale Rafale B: €74M ([[flyaway cost]], FY2013) 4085.008219 4 175.0 1980.0
6911 Category:1950s United States bomber aircraft|C... 15 April 1952 February 1955 Error 0 744 18933037 In service Boeing B-52 Stratofortress B-52B: US$14.43&nbsp;million (1956); 3610.035616 5 744.0 1952.0
6899 Category:1980s United States bomber aircraft|C... 17 July 1989 1 January 1997 Error 0 21 4396 Error In service Northrop Grumman B-2 Spirit $737&nbsp;million (1997 approx. [[flyaway cost... 3504.717808 3 21.0 1989.0
4474 Category:1970s United States fighter aircraft|... 27 July 1972 9 January 1976 Error 0 F-15A/B/C/D/J/DJ: 1,198 11715 In production (2019) McDonnell Douglas F-15 Eagle F-15A/B: US$27.9&nbsp;million (1998) 3156.191781 5 1198.0 1972.0
4762 Category:2010s Russian fighter aircraft|Catego... 29 January 2010 Error 2019 (planned) 0 10 flyable prototypes 2971192 Final flight testing Sukhoi Su-57 T-50: US$50&nbsp;million 3089.608219 3 10.0 2010.0
7508 Category:1970s United States attack aircraft|C... 10 May 1972 October 1977 Error 0 716 12502446 In service Fairchild Republic A-10 Thunderbolt II US$18.8&nbsp;million 3050.219178 5 716.0 1972.0
5175 Category:1970s French fighter aircraft|Categor... 10 March 1978 July 1984 Error 0 601 381535 In service Dassault Mirage 2000 $30.6 million 2959.597260 5 601.0 1978.0
5002 Category:1990s international fighter aircraft|... 27 March 1994 4 August 2003 Error 0 558 167667 In service Eurofighter Typhoon €90&nbsp;million (system cost Tranche 3A) 2958.624658 5 558.0 1994.0
5007 Category:2000s Indian fighter aircraft|Categor... 4 January 2001 17 January 2015 Error 0 32 (including 16 prototypes as of March 2019) 749967 In service HAL Tejas {{INRConvert 2754.413699 3 32.0 2001.0
4476 Category:1970s United States fighter aircraft|... 21 December 1970 22 September 1974 Error 0 712 11719 22 September 2006 ([[United States Navy]]) In service with the Islamic Republic of Iran A... Grumman F-14 Tomcat [[United States dollar 2631.471233 5 712.0 1970.0
4507 Category:1950s United States fighter aircraft|... 27 May 1958 30 December 1960 Error 0 5,195 11759 1992 (United Kingdom) In limited service McDonnell Douglas F-4 Phantom II {{US$ 2420.468493 6 5195.0 1958.0
2347 Category:1990s United States military transpor... 15 September 1991 17 January 1995 Error 0 279 6731 In service Boeing C-17 Globemaster III US$218 million ([[flyaway cost]] for FY 2007) 2377.953425 5 279.0 1991.0
2363 Category:1950s United States military transpor... 23 August 1954 December 1956 Error 0 Over 2,500 as of 2015 7697 In service Lockheed C-130 Hercules C-130E: [[US dollar 2362.249315 6 2500.0 1954.0
6901 Category:1970s United States bomber aircraft|C... 23 December 1974 Error 1 October 1986 0 B-1A: 4 4952 In service Rockwell B-1 Lancer B-1B: [[United States dollar 2345.627397 2 4.0 1974.0
4552 Category:1940s United States fighter aircraft|... 26 October 1940 Error January 1942 (RAF) 0 More than 15,000 24710 Error Retired from military service 1984 (Dominican ... North American P-51 Mustang US$50,985 in 1945 2289.282192 6 15000.0 1940.0
4781 Category:1970s Soviet fighter aircraft|Categor... 6 October 1977 July 1982 Error 0 1,600+ 185653 In service Mikoyan MiG-29 {{US$ 2254.693151 5 1600.0 1977.0
333 Category:Attack helicopters|Category:United St... 30 September 1975 April 1986 Error 0 2,000 {{as of 37746 In service Boeing AH-64 Apache {{plainlist 2246.021918 5 2000.0 1975.0
387 Category:United States military helicopters|Ca... 21 September 1961 1962 Error 0 Over 1,200 as of 2012 38005 In service Boeing CH-47 Chinook US$38.55 million (CH-47F, FY13) 2244.720548 5 1200.0 1961.0
3517 Category:1950s United States military reconnai... 1 August 1955 1957 Error 0 104 32310 Error In service Lockheed U-2 $950,000 in 1955 (equivalent to ${{inflation 2236.887671 4 104.0 1955.0
6554 Category:1930s British fighter aircraft|Catego... 5 March 1936 Error 4 August 1938 0 20,351 26027181 1961 [[Irish Air Corps]] Error Supermarine Spitfire £12,604 (£774,905 or $1,002,639 in 2017) ([[... 2170.805479 6 20351.0 1936.0
4763 Category:2000s Russian fighter aircraft|Catego... Su-27M: 28 June 1988 February 2014 Error 0 Su-27M: 14 314292 In service Sukhoi Su-35 US$40–65&nbsp;million (Su-35S) 2102.767123 3 14.0 1988.0
1044 Category:World War II bombers of the United St... 21 September 1942 8 May 1944 Error 0 3,970 53179 21 June 1960 Retired (see [[Boeing B-29 Superfortress#Survi... Boeing B-29 Superfortress US$639,188 2066.515068 6 3970.0 1942.0
4727 Category:1980s Swedish fighter aircraft|Catego... 9 December 1988 9 June 1996 Error 0 Approx. 247{{#tag:ref 87577 In service Saab JAS 39 Gripen US$ 30–60 million for JAS 39C 2047.578082 5 247.0 1988.0
1045 Category:World War II bombers of the United St... {{Start date and age Error {{Start date and age 0 12,731 4997 1968 ([[Brazilian Air Force]]) Boeing B-17 Flying Fortress {{plainlist 2017.961644 6 12731.0 1930.0
344 Category:United States military helicopters|Ca... 17 October 1974 1979 Error 0 About 4,000 37941 In service Sikorsky UH-60 Black Hawk UH-60: US$21.3&nbsp;million (avg. U.S. procure... 2006.975342 6 4000.0 1974.0
6462 Category:2010s Chinese fighter aircraft|Catego... 11 January 2011 10 March 2017 Error 0 8 prototypes 30236719 In service Chengdu J-20 • US$100-$120 million 1977.657534 3 8.0 2011.0
2350 Category:1980s United States military transpor... 19 March 1989 13 June 2007 Error 0 200+ as of 2014 32814 Error In service Bell Boeing V-22 Osprey MV-22: US$72.1 million ([[flyaway cost]] for F... 1892.989041 4 200.0 1989.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
3142 Category:1920s French military trainer aircraf... 13 April 1923 Error 0 1 59851135 Blériot-SPAD S.62 0.901370 1 1.0 1923.0
3611 Category:1920s Soviet and Russian military rec... 2 June 1925 Error 0 1 59840757 Grigorovich MRL-1 0.884932 1 1.0 1925.0
4433 Category:Fighter aircraft|Category:Fighter air... 14 January 1923 Error 0 1 59851260 Blériot-SPAD S.71 Error 0.879452 1 1.0 1923.0
1293 Category:Military aircraft of World War I|Cate... 1917 Error 0 1 59825289 Roland C.VIII 0.879452 1 1.0 1917.0
3790 Category:1920s German military reconnaissance ... 1928 Error 0 2 59886035 Heinkel HD 30 Error 0.876712 2 2.0 1928.0
5322 Category:1910s French fighter aircraft|Categor... 1918 Error 0 2 60155331 Courtois-Suffit Lescop CSL-1 Error 0.871233 2 2.0 1918.0
4029 Category:1920s Czechoslovakian military reconn... {{avyear Error 0 1 59905717 Letov Š-5 0.865753 1 1.0 1920.0
3753 Category:1910s international military reconnai... November 1922 Error 0 2 60146928 FBA 10 Error 0.846575 2 2.0 1922.0
3191 Category:1920s Czechoslovakian military traine... July 1930 Error 0 1 59905937 Letov Š-25 0.838356 1 1.0 1930.0
3117 Category:1920s French military trainer aircraf... 1929 Error 0 2 59869930 Morane-Saulnier MS.250 0.830137 2 2.0 1929.0
1670 Category:1910s German military utility aircraf... {{avyear Error 0 6 59897398 Gotha LD 5 Error 0.830137 3 6.0 1910.0
3139 Category:1920s French military trainer aircraf... 21 August 1928 Error 0 15 59851078 Blériot-SPAD S.92 0.819178 3 15.0 1928.0
3919 Category:1930s French military reconnaissance ... 1930 Error 0 1 59837378 Levasseur PL.12 0.802740 1 1.0 1930.0
6431 Category:1920s Czechoslovakian fighter aircraf... {{avyear Error 0 1 59905795 Letov Š-12 0.789041 1 1.0 1920.0
1383 Category:Military aircraft of World War I|Cate... February 1916 Error 0 1 59721596 Bréguet XI Corsaire 0.783562 1 1.0 1916.0
3800 Category:1920s German military reconnaissance ... [[1926 in aviation Error 0 1 59805209 Caspar C 30 Error 0.780822 1 1.0 1926.0
3136 Category:1920s French military trainer aircraf... 1921 Error 0 1 60141084 Caudron C.51 0.775342 1 1.0 1921.0
3695 Category:1920s Japanese military reconnaissanc... 1925 Error 0 4~ 59613397 Aichi Experimental Type 15-Ko Reconnaissance S... 0.769863 2 4.0 1925.0
3141 Category:1920s French military trainer aircraf... 5 April 1923 Error 0 1 59851189 Blériot-SPAD S.64 0.753425 1 1.0 1923.0
3920 Category:1930s French military reconnaissance ... 1931 Error 0 1 59837315 Levasseur PL.11 0.736986 1 1.0 1931.0
3799 Category:1920s German military reconnaissance ... [[1928 in aviation Error 0 1 59805491 Caspar C 36 Error 0.720548 1 1.0 1928.0
5111 Category:1910s German fighter aircraft|Categor... February 1917 Error 0 3 59884138 Hansa-Brandenburg W.16 Error 0.695890 2 3.0 1917.0
1301 Category:Military aircraft of World War I|Cate... 1915 February 1917 Error 0 150-200 60129859 Error Paul Schmitt Type 7 Error 0.684932 4 150.0 1915.0
3110 Category:1930s French military trainer aircraf... {{avyear Error 0 1 59879340 Lorraine-Hanriot LH.60 Error 0.679452 1 1.0 1930.0
5056 Category:1920s German fighter aircraft|Categor... [[1924 in aviation Error 0 1 60094928 Caspar CJ 14 Error 0.638356 1 1.0 1924.0
5055 Category:1920s German fighter aircraft|Categor... [[1924 in aviation Error 0 1 60094951 Caspar CS 14 Error 0.635616 1 1.0 1924.0
3798 Category:1920s German military reconnaissance ... Error 0 2 60089208 Caspar U 2 Error 0.613699 2 2.0 1920.0
1300 Category:Military aircraft of World War I|Cate... 1917 Error 0 1 60129786 Error Paul Schmitt Type 10 Error 0.564384 1 1.0 1917.0
11118 Category:Mexican military aircraft June 1, 1980 Error Error 0 8 60519397 Error Retired (2006) DGRCN Tonatiuh MX-1 Error 0.493151 3 8.0 1980.0
5149 Category:1910s German fighter aircraft|Categor... October 1917 Error 0 1+3 unfinished prototypes 59595940 prototype only Aviatik (Berg) Dr.I Error 0.126027 1 1.0 1917.0

2724 rows × 15 columns

In [289]:
# top civ
civ_df.sort_values(['built_number'],ascending=False)
Out[289]:
category first flight introduced introduction ns number built pageid retired status title unit cost views built_group built_number year
2210 Category:1950s United States special-purpose a... Error 0 >73,000 6353080 Radioplane BTT Error 33.134247 6 73000.0 1950.0
416 Category:1960s United States civil utility air... 14 January 1960 [[1960 in aviation Error 0 32,778+ 172948 In production Piper PA-28 Cherokee [[United States dollar 852.813699 6 32778.0 1960.0
489 Category:1950s United States civil utility air... September 12, 1957 Error 0 23,949{{Citation needed 848180 Error Error Cessna 150 [[United States dollar 480.517808 6 23949.0 1957.0
485 Category:1950s United States civil utility air... 1956 Error 0 over 23,237 643970 In production Cessna 182 Skylane [[United States dollar 453.030137 6 23237.0 1956.0
601 Category:1930s United States civil utility air... 1938 Error 0 19,888 (US built) 847652 Error Piper J-3 Cub $995–2,461 when new 386.284932 6 19888.0 1938.0
2641 Category:1940s Soviet civil utility aircraft|C... 31 August 1947 Error 0 18,000+ 702782 Error Series production may still continue in [[Chin... Antonov An-2 666.835616 6 18000.0 1947.0
550 Category:1940s United States civil utility air... December 22, 1945 1947 Error 0 >17,000 946289 In service Beechcraft Bonanza [[United States dollar 879.309589 6 17000.0 1945.0
2627 Category:1960s Soviet civil utility aircraft|C... 7 July 1961 1967 Error 0 >17,000 and production continues today; world'... 957233 In service Mil Mi-8 Error 1010.898630 6 17000.0 1961.0
2217 Category:1950s United States helicopters|Categ... 20 October 1956 (XH-40) 1959 Error 0 >16,000 38008 In service Bell UH-1 Iroquois 1285.865753 6 16000.0 1956.0
2253 Category:1940s United States special-purpose a... {{avyear Error 0 ca. 15,000 6351403 Radioplane OQ-2 Error 36.238356 6 15000.0 1940.0
507 Category:1940s United States civil utility air... 1949 1949 Error 0 15000{{cn 1562655 Piper PA-18 Super Cub 225.947945 6 15000.0 1949.0
1616 Category:1940s United States military gliders|... [[1942 in aviation Error Error 0 >13,903 12261319 Error Error Waco CG-4 Error 121.235616 6 13903.0 1942.0
7890 Category:Racing aircraft|Category:Racing aircraft 29 May 1940 Error 28 December 1942 0 12,571 11721 1953 (United States) Error Vought F4U Corsair 1291.693151 6 12571.0 1940.0
2859 Category:1970s Soviet helicopters|Category:197... 1975 1977 (Mi-8MT), 1981 (Mi-17) Error 0 About 12,000 as of 2007 1493374 In service Mil Mi-17 Prices vary based on specifications (military ... 1297.665753 6 12000.0 1975.0
474 Category:1950s United States civil utility air... 1953 Error 1955 0 >11,000 949842 In production (2018) Mooney M20 M20U Ovation Ultra: [[United States dollar 374.413699 6 11000.0 1953.0
8178 Category:World War II transport aircraft of th... 23 December 1941 Error 0 10,174 364142 In service in Colombia, El Salvador and South ... Douglas C-47 Skytrain 919.893151 6 10174.0 1941.0
484 Category:1950s United States civil utility air... January 1957 1957 Error 0 9,240 1808956 Cessna 210 499.567123 6 9240.0 1957.0
651 Category:1930s United States civil utility air... January 15, 1937 1937 Error 0 9,000+ 2045174 Beechcraft Model 18 D18S: US$78,050 in 1952 526.235616 6 9000.0 1937.0
443 Category:1960s United States civil utility air... 1962 (206) Error 0 over 8509 (as of approx. 2006) 1240850 In production Cessna 206 [[United States dollar 554.745205 6 8509.0 1962.0
413 Category:1960s United States civil utility air... 6 December 1963 Error 1965 0 7842+ 177372 Production completed 2007 Piper PA-32 190.150685 6 7842.0 1963.0
544 Category:1940s United States civil utility air... June 28, 1945 (140) 1946 Error 0 7,664 847727 Cessna 140 [[United States dollar 143.065753 6 7664.0 1945.0
378 Category:1970s United States civil utility air... 1977 Error 0 7,584 306162 Cessna 152 362.032877 6 7584.0 1977.0
450 Category:1960s United States civil utility air... December 8, 1962 (206) 1967 Error 0 7,300 1315340 In service Bell 206 approx. US$900,000 to $1.2 million 827.383562 6 7300.0 1962.0
2755 Category:1920s Soviet and Russian military rec... Autumn 1928 1930 Error 0 ~7000 12516339 1944 Polikarpov R-5 47.512329 6 7000.0 1928.0
150 Category:United States civil aircraft|Category... 15 September 1969 Error 1972 0 7000 3098211 Error Error Cessna Citation family Error 293.945205 6 7000.0 1969.0
473 Category:1950s United States civil utility air... 2 March [[1952 in aviation Error [[1954 in aviation 0 6,976 287124 Piper PA-23 191.430137 6 6976.0 1952.0
455 Category:1960s United States civil utility air... February 29, 1960 Error 0 6,884+ 947430 In production Beechcraft Baron [[United States dollar 491.205479 6 6884.0 1960.0
486 Category:1950s United States civil utility air... May 26, 1952 1953 Error 0 6,193 1051297 Cessna 180 159.717808 6 6193.0 1952.0
8139 Category:World War II Soviet transport aircraf... Error 1939 Error 0 6,157 3979727 Error Error Lisunov Li-2 160.052055 6 6157.0 1939.0
1039 Category:1970s United States civil trainer air... 1970 Error 0 Over 6,000 4535901 American Champion Decathlon Error 107.600000 6 6000.0 1970.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
5600 Category:1910s French experimental aircraft 1911 Error 0 1 10902657 Antoinette military monoplane Error 6.238356 1 1.0 1911.0
5619 Category:1900s French experimental aircraft Error 0 1 11997745 Blériot VIII Error 15.621918 1 1.0 1900.0
8522 Category:Abandoned civil aircraft projects of ... Error 0 1 (incomplete) 12584500 Abandoned project Britten Sheriff Error 10.057534 1 1.0 NaN
5606 Category:1900s French experimental aircraft 5 September {{avyear Error 0 1 16839595 Goupy No.1 Error 2.942466 1 1.0 1900.0
5605 Category:1900s French experimental aircraft 9 March {{avyear Error 0 1 16850645 Goupy No.2 Error 3.432877 1 1.0 1900.0
5618 Category:1900s French experimental aircraft Error 0 1 11997871 Blériot IX Error 6.463014 1 1.0 1900.0
5617 Category:1900s French experimental aircraft Error 0 1 12011689 never completed Blériot X Error 4.057534 1 1.0 1900.0
5612 Category:1900s French experimental aircraft|Ca... 13 November [[1907 in aviation Error 0 1 14901852 Cornu helicopter Error 24.531507 1 1.0 1907.0
5608 Category:1900s French experimental aircraft 1908 Error 0 1 10895826 Ferber IX Error 2.994521 1 1.0 1908.0
8433 Category:Supersonic business jets Error 0 0 25327086 In development Gulfstream X-54 82.920548 2 0.0 NaN
8508 Category:Abandoned civil aircraft projects of ... Error 0 0 662310 Developed, never built Boeing 7J7 US$28 million (1987 dollars) 127.682192 2 0.0 NaN
8502 Category:Abandoned civil aircraft projects of ... Error 0 0 33950656 Design only Convair Model 58-9 46.408219 2 0.0 NaN
1642 Category:1940s United States military gliders|... Error 0 0 59779558 cancelled AGA Aviation LRG Error 1.372603 2 0.0 1940.0
8490 Category:Abandoned civil aircraft projects of ... Error 0 0 1542863 Cancelled Rocketplane XP 13.413699 2 0.0 NaN
3526 Category:1940s Japanese experimental aircraft|... Error 0 0 1968183 Cancelled Kawanishi K-200 15.706849 2 0.0 1940.0
1960 Category:United States cargo aircraft|Category... Error 0 0 17962717 Cancelled Ayres LM200 Loadmaster 13.879452 2 0.0 1990.0
8481 Category:Abandoned civil aircraft projects Error Error Error 0 0 318407 Error Error Bristol Type 223 40.663014 2 0.0 NaN
8474 Category:Abandoned civil aircraft projects Error Error 0 0}} 32013272 Error Error Focke-Wulf Fw 206 Error 15.786301 2 0.0 NaN
4797 Category:1940s German experimental aircraft Error 0 0 1673300 Project Lippisch P.13a 101.106849 2 0.0 1940.0
8473 Category:Abandoned civil aircraft projects Error 0 0 39057977 Focke-Wulf Fw 260 10.161644 2 0.0 NaN
2788 Category:1930s Soviet military reconnaissance ... Error 0 0 59592244 Error paper project only Tupolev ANT-30 2.342466 2 0.0 1930.0
4801 Category:1940s German experimental aircraft none Error 0 0 19572669 Focke-Achgelis Fa 269 Error 62.613699 2 0.0 1940.0
2251 Category:1940s United States special-purpose a... never flew Error 0 0 59743525 design study only OQ-5 Error 1.158904 2 0.0 1940.0
8334 Category:German military transport aircraft Error 0 0 9306898 Dornier Do 214 17.413699 2 0.0 NaN
1623 Category:1940s United States military gliders|... Error 0 0 59779165 cancelled Snead LRH Error 1.019178 2 0.0 1940.0
8461 Category:Abandoned civil aircraft projects Error 0 0 53777199 Junkers J.1000 3.600000 2 0.0 NaN
4874 Category:1940s German helicopters|Category:194... Error 0 0 42345483 Focke-Achgelis Fa 284 20.041096 2 0.0 1940.0
8456 Category:Abandoned civil aircraft projects Error 0 0 24898908 Cancelled Miles M.26 9.090411 2 0.0 NaN
4873 Category:1940s German helicopters|Category:194... 1942 Error 0 0 59758227 paper project only Focke-Achgelis Fa 325 Error 6.673973 2 0.0 1942.0
8462 Category:Abandoned civil aircraft projects 10 June [[1995 in aviation Error 0 0 26321154 cancelled 1998 IPTN N-2130 7.427397 2 0.0 1995.0

1966 rows × 15 columns

In [295]:
civ_df.loc[civ_df.built_number < 100].sort_values(['views'],ascending=False)
Out[295]:
category first flight introduced introduction ns number built pageid retired status title unit cost views built_group built_number year
8008 Category:NASA aircraft 22 December 1964 January 1966 Error 0 32 55245 1998 (USAF), 1999 (NASA) Retired Lockheed SR-71 Blackbird $34 million 4928.797260 3 32.0 1964.0
2808 Category:1980s Soviet cargo aircraft|Category:... 21 December 1988 Error 0 1 406245 In service Antonov An-225 Mriya 2176.846575 1 1.0 1988.0
8224 Category:1940s United States military transpor... November 2, 1947 Error 0 1 197878 On display Hughes H-4 Hercules $2.5 million 1655.690411 1 1.0 1947.0
1848 Category:1950s United States experimental airc... 8 June 1959 17 September 1959 Error 0 3 221315 December 1968 North American X-15 1431.821918 2 3.0 1959.0
4027 Category:2010s international cargo aircraft|Ca... 19 July 2018 Expected 2019 Error 0 3 47848500 Flight Testing Airbus Beluga XL Error 1341.791781 2 3.0 2018.0
4028 Category:1990s international cargo aircraft|Ca... 13 September 1994 September 1995 Error 0 5 183548 In service Airbus Beluga €183 million 1328.482192 2 5.0 1994.0
8004 Category:NASA aircraft 21 September 1964 Error 0 2 211782 4 February 1969 Retired North American XB-70 Valkyrie US$750&nbsp;million (average cost)(equivalent ... 1144.673973 2 2.0 1964.0
8324 Category:2000s international military transpor... 11 December 2009 2013 Error 0 80 371265 In service Airbus A400M Atlas [[Euro 1104.791781 4 80.0 2009.0
2139 Category:1980s United States special-purpose a... May 16, 1987 August 23, 1990 Error 0 2 (VC-25A) 581260 In service Boeing VC-25 US$325 million 993.531507 2 2.0 1987.0
2809 Category:1980s Soviet cargo aircraft|Category:... 24 December 1982 1986 Error 0 55 435406 In service Antonov An-124 Ruslan US$70–100&nbsp;million 859.210959 4 55.0 1982.0
2117 Category:2000s United States helicopters|Categ... 8 December 2000 30 September 2010 Error 0 61 10805384 In service Bell AH-1Z Viper US$27 million 833.482192 4 61.0 2000.0
2854 Category:1980s Soviet helicopters|Category:198... Ka-50: 17 June 1982 Error 28 August 1995 0 Ka-50: 32 16917 In service Kamov Ka-50 500 million rubles (approx. $16&nbsp;million f... 760.602740 3 32.0 1982.0
2104 Category:2000s United States civil aircraft|Ca... First prototype: 3 July 2008 Error Error 0 88 delivered (January 2019) 7880654 In production Cirrus Vision SF50 [[US$]]2.38-2.75 million (G2, 2019) 734.197260 4 88.0 2008.0
8325 Category:2000s international military transpor... 15 June 2007 1 June 2011 Error 0 33 as of 14 December 2018 616482 Error In service Airbus A330 MRTT Error 714.463014 3 33.0 2007.0
1935 Category:1900s United States experimental airc... December 17, 1903 Error Error 0 1 1045608 Error Error Wright Flyer 711.249315 1 1.0 1903.0
1962 Category:2000s United States cargo aircraft|Ca... September 9, 2006 2007 Error 0 4 (all conversions) 6343363 Error In service Boeing Dreamlifter Error 652.134247 2 4.0 2006.0
2005 Category:2000s United States business aircraft... December 3, 2003 Error 0 92 (Oct 2018) 2288521 Active Honda HA-420 HondaJet US$4.9 million (2018) 640.361644 4 92.0 2003.0
8007 Category:NASA aircraft 7 August 1963 Error 0 3 547798 Canceled Lockheed YF-12 US$15–18&nbsp;million (projected) 636.523288 2 3.0 1963.0
1870 Category:1940s United States experimental airc... 19 January 1946 Error 0 7 208674 Retired Bell X-1 577.024658 3 7.0 1946.0
8196 Category:1990s United States military transpor... June 1998 Error 0 8{{cn 595226 In service Boeing C-32 570.443836 3 8.0 1998.0
3510 Category:Japanese experimental aircraft 22 April 2016 Error 0 1 prototype 12057661 Error In development Mitsubishi X-2 Shinshin Error 561.013699 1 1.0 2016.0
1685 Category:2010s United States experimental airc... 4 February 2011 Error 0 2 4908033 Northrop Grumman X-47B 553.630137 2 2.0 2011.0
4103 Category:2010s Indian helicopters|Category:201... 29 March 2010 Error 0 4 8139772 In production HAL Light Combat Helicopter US$20.2 million 551.846575 2 4.0 2010.0
1719 Category:2000s United States experimental airc... 24 October 2000 Error 0 2 (X-35A/B and X-35C) 561535 Error Retired Lockheed Martin X-35 541.473973 2 2.0 2000.0
2300 Category:1920s United States special-purpose a... April 28, 1927 Error 0 1 (not including later replicas and reproducti... 358988 April 30, 1928 Spirit of St. Louis $10,580 ($144,931 in 2015) 506.405479 1 1.0 1927.0
8204 Category:1960s United States military transpor... 18 November 1964 1966 Error 0 C-2A: 17 204746 C-2A: Retired Grumman C-2 Greyhound US$40.01&nbsp;million in 2016 501.761644 3 17.0 1964.0
2114 Category:2000s United States helicopters|Categ... 20 December 2001 8 August 2008 Error 0 92 8660252 In service Bell UH-1Y Venom US$26.2 million ([[flyaway cost]], FY2014) 457.745205 4 92.0 2001.0
8194 Category:2000s United States military transpor... 21 April 2001 Error 0 21{{cn 313275 Active service Boeing C-40 Clipper [[United States dollar 427.441096 3 21.0 2001.0
2441 Category:2010s Swiss business aircraft|Categor... 11 May 2015 1 April 2018 Error 0 30 delivered by May 2019 39438695 in production Pilatus PC-24 [[US$]]10.7M (2019) 422.726027 3 30.0 2015.0
8416 Category:2010s military transport aircraft 3 February 2015 2019 (proposed) Error 0 3 10818650 Under development Embraer KC-390 US$ 50-55 million (2016) 418.024658 2 3.0 2015.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
3527 Category:1930s Japanese experimental aircraft 1939 Error 0 1 59629399 Yokosuka MXY1 Error 1.290411 1 1.0 1939.0
2756 Category:1920s Soviet and Russian military rec... Summer 1929 Error 0 1 59832077 Grigorovich ROM-2 1.213699 1 1.0 1929.0
3423 Category:Mexican civil aircraft [[1957]] Error Error 0 1 59637104 Error Retired Lascurain Aura Error 1.205479 1 1.0 1957.0
3829 Category:1950s Italian sailplanes|Category:195... 1952 Error Error 0 1 40954363 Error Sole example destroyed Rotondi R-1 Gheppio Error 1.197260 1 1.0 1952.0
2248 Category:1940s United States special-purpose a... 1945 Error 0 5 59609554 OQ-15 Error 1.175342 2 5.0 1945.0
2251 Category:1940s United States special-purpose a... never flew Error 0 0 59743525 design study only OQ-5 Error 1.158904 2 0.0 1940.0
5481 Category:1920s French sailplanes|Category:1920... 1923 Error 0 at least 2 59833968 Dewoitine P-3 1.128767 2 2.0 1923.0
4847 Category:1920s German cargo aircraft|Category:... {{avyear Error 0 1 59885951 Heinkel HD 27 Error 1.093151 1 1.0 1920.0
8280 Category:1940s Soviet military transport aircr... 1943 Error 0 1 59807472 Polikarpov MP Error 1.090411 1 1.0 1943.0
3939 Category:1910s Italian experimental aircraft 1914 Error 0 1 59754110 Caproni Ca.25 1.027397 1 1.0 1914.0
1623 Category:1940s United States military gliders|... Error 0 0 59779165 cancelled Snead LRH Error 1.019178 2 0.0 1940.0
2759 Category:1920s Soviet and Russian military rec... 23 September 1926 Error 0 1 59840874 Grigorovich MR-2 1.000000 1 1.0 1926.0
3912 Category:1920s Italian civil trainer aircraft|... [[1926 in aviation Error 0 1 59725273 CANT 12 Error 0.969863 1 1.0 1926.0
2758 Category:1920s Soviet and Russian military rec... July 1929 Error 0 1 59832193 Grigorovich MR-5 0.942466 1 1.0 1929.0
5543 Category:1940s French experimental aircraft 21 November 1941 Error 0 1 59864603 Lioré et Olivier LeO 48 0.939726 1 1.0 1941.0
2250 Category:1940s United States special-purpose a... October 1941 Error 0 1 59743469 Radioplane OQ-12 Error 0.915068 1 1.0 1941.0
2757 Category:1920s Soviet and Russian military rec... 2 June 1925 Error 0 1 59840757 Grigorovich MRL-1 0.884932 1 1.0 1925.0
5057 Category:1930s French civil utility aircraft|C... 5 April 1937 Error 0 1 59867253 Nicolas-Claude NC-2 Aquilon 0.871233 1 1.0 1937.0
5571 Category:1930s French experimental aircraft 1935 Error Error 0 1 59873097 Error Error Payen Pa.101 Error 0.868493 1 1.0 1935.0
5572 Category:1930s French experimental aircraft 1936 Error Error 0 1 59873133 Error Error Payen AP.10 Error 0.783562 1 1.0 1936.0
5516 Category:1930s French civil trainer aircraft|C... {{avyear Error 0 2 59879281 Hanriot LH.30 Error 0.780822 2 2.0 1930.0
4512 Category:German sailplanes|Category:German sai... 0 1 60093957 Akaflieg Berlin B1 0.772603 1 1.0 NaN
4830 Category:1910s German experimental aircraft 13 August 1918 Error 0 1 60099038 Friedrichshafen FF.63 0.747945 1 1.0 1918.0
4829 Category:1910s German experimental aircraft 12 December 1918 Error 0 1 60099130 Friedrichshafen FF.67 0.668493 1 1.0 1918.0
5987 Category:1930s Czechoslovakian sport aircraft|... 20 July 1936 Error 0 1 x Be-52; 1 x Be-56 60173716 Beneš-Mráz Be-56 Beta-Major Error 0.660274 1 1.0 1936.0
5056 Category:1930s French civil utility aircraft|C... 1 September 1953 Error 0 1 59873195 Petitbon RP-40 0.624658 1 1.0 1953.0
5592 Category:1910s French experimental aircraft 0 1 60115621 SELA monoplane 0.619178 1 1.0 1910.0
4510 Category:German sailplanes|Category:German sai... 0 1 60094158 Akaflieg Berlin B3 Charlotte II 0.553425 1 1.0 NaN
5312 Category:1930s French sport aircraft|Category:... 1936 Error Error 0 1 60125989 Error Error SFAN 5 }} 0.389041 1 1.0 1936.0
3101 Category:1950s Polish civil utility aircraft|C... 17 May 1951 (S-3) Error Error 0 3 + 1 11128535 Error Error PZL S-4 Kania 2 Error 0.312329 2 3.0 1951.0

1373 rows × 15 columns

In [299]:
civ_df.loc[civ_df.built_number >= 1].sort_values(['views'],ascending=False)
Out[299]:
category first flight introduced introduction ns number built pageid retired status title unit cost views built_group built_number year
8008 Category:NASA aircraft 22 December 1964 January 1966 Error 0 32 55245 1998 (USAF), 1999 (NASA) Retired Lockheed SR-71 Blackbird $34 million 4928.797260 3 32.0 1964.0
1963 Category:2000s United States cargo aircraft|Ca... 747-8F: February 8, 2010 747-8F: October 12, 2011, with [[Cargolux]] Error 0 130 as of December 2018 3166708 Error In service Boeing 747-8 747-8I: [[US$]]418.4M, 747-8F: US$419.2M as of... 2583.832877 4 130.0 2010.0
8197 Category:1990s United States military transpor... 15 September 1991 17 January 1995 Error 0 279 6731 In service Boeing C-17 Globemaster III US$218 million ([[flyaway cost]] for FY 2007) 2377.953425 5 279.0 1991.0
8209 Category:1950s United States military transpor... 23 August 1954 December 1956 Error 0 Over 2,500 as of 2015 7697 In service Lockheed C-130 Hercules C-130E: [[US dollar 2362.249315 6 2500.0 1954.0
1966 Category:1980s United States cargo aircraft|Ca... February 19, 1982 January 1, 1983, with [[Eastern Air Lines]] Error 0 1,050 151995 In service Boeing 757 {{plainlist 2264.934247 5 1050.0 1982.0
2162 Category:1970s United States helicopters|Categ... 30 September 1975 April 1986 Error 0 2,000 {{as of 37746 In service Boeing AH-64 Apache {{plainlist 2246.021918 5 2000.0 1975.0
2195 Category:1960s United States helicopters|Categ... 21 September 1961 1962 Error 0 Over 1,200 as of 2012 38005 In service Boeing CH-47 Chinook US$38.55 million (CH-47F, FY13) 2244.720548 5 1200.0 1961.0
2808 Category:1980s Soviet cargo aircraft|Category:... 21 December 1988 Error 0 1 406245 In service Antonov An-225 Mriya 2176.846575 1 1.0 1988.0
2157 Category:1970s United States helicopters|Categ... 17 October 1974 1979 Error 0 About 4,000 37941 In service Sikorsky UH-60 Black Hawk UH-60: US$21.3&nbsp;million (avg. U.S. procure... 2006.975342 6 4000.0 1974.0
8199 Category:1980s United States military transpor... 19 March 1989 13 June 2007 Error 0 200+ as of 2014 32814 Error In service Bell Boeing V-22 Osprey MV-22: US$72.1 million ([[flyaway cost]] for F... 1892.989041 4 200.0 1989.0
8202 Category:1960s United States military transpor... 30 June 1968 Error June 1970 0 131 (C-5A: 81, C-5B: 50) 160434 In service Lockheed C-5 Galaxy C-5A: [[United States dollar 1758.841096 4 131.0 1968.0
2868 Category:1960s Soviet helicopters|Category:196... 19 September 1969 1972 Error 0 2,648 384591 In service Mil Mi-24 1702.808219 6 2648.0 1969.0
8224 Category:1940s United States military transpor... November 2, 1947 Error 0 1 197878 On display Hughes H-4 Hercules $2.5 million 1655.690411 1 1.0 1947.0
1848 Category:1950s United States experimental airc... 8 June 1959 17 September 1959 Error 0 3 221315 December 1968 North American X-15 1431.821918 2 3.0 1959.0
4027 Category:2010s international cargo aircraft|Ca... 19 July 2018 Expected 2019 Error 0 3 47848500 Flight Testing Airbus Beluga XL Error 1341.791781 2 3.0 2018.0
4028 Category:1990s international cargo aircraft|Ca... 13 September 1994 September 1995 Error 0 5 183548 In service Airbus Beluga €183 million 1328.482192 2 5.0 1994.0
2859 Category:1970s Soviet helicopters|Category:197... 1975 1977 (Mi-8MT), 1981 (Mi-17) Error 0 About 12,000 as of 2007 1493374 In service Mil Mi-17 Prices vary based on specifications (military ... 1297.665753 6 12000.0 1975.0
7890 Category:Racing aircraft|Category:Racing aircraft 29 May 1940 Error 28 December 1942 0 12,571 11721 1953 (United States) Error Vought F4U Corsair 1291.693151 6 12571.0 1940.0
2217 Category:1950s United States helicopters|Categ... 20 October 1956 (XH-40) 1959 Error 0 >16,000 38008 In service Bell UH-1 Iroquois 1285.865753 6 16000.0 1956.0
386 Category:1970s United States civil utility air... October 27, 1972 1972 (Military) Error 0 3,781 at end of 2015 9023483 Active service Beechcraft Super King Air King Air 250: US$6.295M 1188.293151 6 3781.0 1972.0
2780 Category:1960s Soviet military reconnaissance ... 6 March 1964 1970 Error 0 1,186 247960 In limited service Mikoyan-Gurevich MiG-25 1164.052055 5 1186.0 1964.0
8004 Category:NASA aircraft 21 September 1964 Error 0 2 211782 4 February 1969 Retired North American XB-70 Valkyrie US$750&nbsp;million (average cost)(equivalent ... 1144.673973 2 2.0 1964.0
8324 Category:2000s international military transpor... 11 December 2009 2013 Error 0 80 371265 In service Airbus A400M Atlas [[Euro 1104.791781 4 80.0 2009.0
2394 Category:1990s Swiss civil utility aircraft|Ca... 31 May 1991 1994 Error 0 1,500 ({{As of 914310 In production Pilatus PC-12 [[United States dollar 1031.252055 5 1500.0 1991.0
8195 Category:1990s United States military transpor... 5 April 1996 1999 Error 0 400 as of February 2018 16172717 In service Lockheed Martin C-130J Super Hercules {{US$ 1030.134247 5 400.0 1996.0
2811 Category:1970s Soviet cargo aircraft|Category:... 25 March 1971 June 1974 Error 0 960 229943 Error In production, in service Ilyushin Il-76 1028.682192 5 960.0 1971.0
6326 Category:1990s Canadian business aircraft|Cate... 13 October 1996 1997 Error 0 816 (Oct 2018) 881260 Error In service, in production Bombardier Global Express 5000: US$50.44 million 1027.000000 5 816.0 1996.0
2627 Category:1960s Soviet civil utility aircraft|C... 7 July 1961 1967 Error 0 >17,000 and production continues today; world'... 957233 In service Mil Mi-8 Error 1010.898630 6 17000.0 1961.0
2139 Category:1980s United States special-purpose a... May 16, 1987 August 23, 1990 Error 0 2 (VC-25A) 581260 In service Boeing VC-25 US$325 million 993.531507 2 2.0 1987.0
6211 Category:1960s Canadian civil utility aircraft... 20 May 1965 1966 Error 0 Oct 2017: {{#expr:844+123}} 717467 In production De Havilland Canada DHC-6 Twin Otter US$680,000 (1972) 985.890411 6 2017.0 1965.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
5042 Category:1940s French civil utility aircraft|C... 13 October 1946 Error 0 1 43941438 Boisavia Muscadet Error 1.350685 1 1.0 1946.0
2831 Category:1920s Soviet and Russian civil aircra... 10 June 1925 Error 0 1 59807290 Polikarpov PM-1 Error 1.347945 1 1.0 1925.0
3527 Category:1930s Japanese experimental aircraft 1939 Error 0 1 59629399 Yokosuka MXY1 Error 1.290411 1 1.0 1939.0
2756 Category:1920s Soviet and Russian military rec... Summer 1929 Error 0 1 59832077 Grigorovich ROM-2 1.213699 1 1.0 1929.0
3423 Category:Mexican civil aircraft [[1957]] Error Error 0 1 59637104 Error Retired Lascurain Aura Error 1.205479 1 1.0 1957.0
3829 Category:1950s Italian sailplanes|Category:195... 1952 Error Error 0 1 40954363 Error Sole example destroyed Rotondi R-1 Gheppio Error 1.197260 1 1.0 1952.0
2248 Category:1940s United States special-purpose a... 1945 Error 0 5 59609554 OQ-15 Error 1.175342 2 5.0 1945.0
5481 Category:1920s French sailplanes|Category:1920... 1923 Error 0 at least 2 59833968 Dewoitine P-3 1.128767 2 2.0 1923.0
4847 Category:1920s German cargo aircraft|Category:... {{avyear Error 0 1 59885951 Heinkel HD 27 Error 1.093151 1 1.0 1920.0
8280 Category:1940s Soviet military transport aircr... 1943 Error 0 1 59807472 Polikarpov MP Error 1.090411 1 1.0 1943.0
3939 Category:1910s Italian experimental aircraft 1914 Error 0 1 59754110 Caproni Ca.25 1.027397 1 1.0 1914.0
2759 Category:1920s Soviet and Russian military rec... 23 September 1926 Error 0 1 59840874 Grigorovich MR-2 1.000000 1 1.0 1926.0
3912 Category:1920s Italian civil trainer aircraft|... [[1926 in aviation Error 0 1 59725273 CANT 12 Error 0.969863 1 1.0 1926.0
2758 Category:1920s Soviet and Russian military rec... July 1929 Error 0 1 59832193 Grigorovich MR-5 0.942466 1 1.0 1929.0
5543 Category:1940s French experimental aircraft 21 November 1941 Error 0 1 59864603 Lioré et Olivier LeO 48 0.939726 1 1.0 1941.0
2250 Category:1940s United States special-purpose a... October 1941 Error 0 1 59743469 Radioplane OQ-12 Error 0.915068 1 1.0 1941.0
2757 Category:1920s Soviet and Russian military rec... 2 June 1925 Error 0 1 59840757 Grigorovich MRL-1 0.884932 1 1.0 1925.0
5057 Category:1930s French civil utility aircraft|C... 5 April 1937 Error 0 1 59867253 Nicolas-Claude NC-2 Aquilon 0.871233 1 1.0 1937.0
5571 Category:1930s French experimental aircraft 1935 Error Error 0 1 59873097 Error Error Payen Pa.101 Error 0.868493 1 1.0 1935.0
5572 Category:1930s French experimental aircraft 1936 Error Error 0 1 59873133 Error Error Payen AP.10 Error 0.783562 1 1.0 1936.0
5516 Category:1930s French civil trainer aircraft|C... {{avyear Error 0 2 59879281 Hanriot LH.30 Error 0.780822 2 2.0 1930.0
4512 Category:German sailplanes|Category:German sai... 0 1 60093957 Akaflieg Berlin B1 0.772603 1 1.0 NaN
4830 Category:1910s German experimental aircraft 13 August 1918 Error 0 1 60099038 Friedrichshafen FF.63 0.747945 1 1.0 1918.0
4829 Category:1910s German experimental aircraft 12 December 1918 Error 0 1 60099130 Friedrichshafen FF.67 0.668493 1 1.0 1918.0
5987 Category:1930s Czechoslovakian sport aircraft|... 20 July 1936 Error 0 1 x Be-52; 1 x Be-56 60173716 Beneš-Mráz Be-56 Beta-Major Error 0.660274 1 1.0 1936.0
5056 Category:1930s French civil utility aircraft|C... 1 September 1953 Error 0 1 59873195 Petitbon RP-40 0.624658 1 1.0 1953.0
5592 Category:1910s French experimental aircraft 0 1 60115621 SELA monoplane 0.619178 1 1.0 1910.0
4510 Category:German sailplanes|Category:German sai... 0 1 60094158 Akaflieg Berlin B3 Charlotte II 0.553425 1 1.0 NaN
5312 Category:1930s French sport aircraft|Category:... 1936 Error Error 0 1 60125989 Error Error SFAN 5 }} 0.389041 1 1.0 1936.0
3101 Category:1950s Polish civil utility aircraft|C... 17 May 1951 (S-3) Error Error 0 3 + 1 11128535 Error Error PZL S-4 Kania 2 Error 0.312329 2 3.0 1951.0

1945 rows × 15 columns

In [297]:
mil_df.loc[mil_df.built_number == 0].sort_values(['views'],ascending=False)
Out[297]:
category first flight introduced introduction ns number built pageid retired status title unit cost views built_group built_number year
7757 Category:Carrier-based aircraft|Category:Carri... Error Error Error 0 0; [[mockup]] only 574228 Error Canceled McDonnell Douglas A-12 Avenger II US$84 million (estimated) 289.375342 2 0.0 NaN
1154 Category:Boeing B-29 Superfortress|Category:Bo... Error 0 0 3243407 Canceled Boeing B-54 216.597260 2 0.0 NaN
10976 Category:Cancelled military aircraft projects ... Error 0 0 13550580 Cancelled Convair Kingfish 131.693151 2 0.0 NaN
11215 Category:Abandoned military aircraft projects ... Error 0 0 1673300 Project Lippisch P.13a 101.106849 2 0.0 NaN
7765 Category:Carrier-based aircraft|Category:Carri... Error 0 0 1048043 Cancelled Douglas F6D Missileer 80.849315 2 0.0 NaN
7137 Category:1940s German bomber aircraft|Category... Error 0 0 7816782 Arado E.555 79.430137 2 0.0 1940.0
11224 Category:Abandoned military aircraft projects ... Error 0 0 9306615 proposal Focke-Wulf Fw 300 77.427397 2 0.0 NaN
6508 Category:1950s British fighter aircraft|Catego... Error 0 0 597903 Saunders-Roe SR.177 69.145205 2 0.0 1950.0
10965 Category:Cancelled military aircraft projects ... Error 0 0 1059686 Design only Douglas XB-31 66.410959 2 0.0 NaN
6859 Category:Bomber aircraft|Category:Bomber aircr... Error 0 0 3243473 Cancelled in 1952 Boeing XB-59 65.717808 2 0.0 NaN
11226 Category:Abandoned military aircraft projects ... none Error 0 0 19572669 Focke-Achgelis Fa 269 Error 62.613699 2 0.0 NaN
10979 Category:Cancelled military aircraft projects ... n/a Error 0 0 885100 Cancelled Boeing Y1B-20 61.060274 2 0.0 NaN
818 Category:World War II dive bombers|Category:Wo... Error 0 0 1436398 Junkers Ju 187 58.279452 2 0.0 1940.0
6860 Category:Bomber aircraft|Category:Bomber aircr... Error 0 0 3243424 Cancelled Boeing XB-55 58.202740 2 0.0 NaN
11231 Category:Abandoned military aircraft projects ... 1944 Error 0 0 25536623 Cancelled Dornier Do 635 55.586301 2 0.0 1944.0
6738 Category:1980s Argentine fighter aircraft|Cate... Error Error Error 0 0 8042960 Error Cancelled FMA SAIA 90 49.043836 2 0.0 1980.0
10975 Category:Cancelled military aircraft projects ... n/a Error 0 0 1920927 Cancelled in 1949 Convair XB-53 45.994521 2 0.0 NaN
11238 Category:Abandoned military aircraft projects ... Error Error Error 0 0 powered aircraft, 27124225 Error Abandoned Arado E.381 Error 45.854795 2 0.0 NaN
11094 Category:Abandoned military aircraft projects ... Error 0 0 55607053 Cancelled Tupolev Tu-360 45.649315 2 0.0 NaN
6482 Category:1950s Canadian fighter aircraft|Categ... Error 0 0 27334190 Cancelled December 1951 Avro Canada CF-103 43.471233 2 0.0 1950.0
744 Category:World War II jet aircraft of Germany|... 0 0 15416348 Messerschmitt P.1112 43.191781 2 0.0 NaN
10967 Category:Cancelled military aircraft projects ... Error 0 0 13316934 Canceled Douglas C-132 Error 42.265753 2 0.0 NaN
10944 Category:Cancelled military aircraft projects ... Error 0 0 17449605 Cancelled 1967 Project Isinglass 38.419178 2 0.0 NaN
11101 Category:Abandoned military aircraft projects ... Error 0 0 (1 unfinished prototype) 52741007 Development ceased Beriev S-13 37.391781 2 0.0 NaN
740 Category:World War II jet aircraft of Japan|Ca... Error 0 0 1960381 Cancelled Kawanishi Baika 35.128767 2 0.0 NaN
11210 Category:Abandoned military aircraft projects ... Error 0 0 9288750 Mock up only{{Citation needed Messerschmitt Me 329 32.728767 2 0.0 NaN
11061 Category:Unmanned aerial vehicles of the Sovie... Error 0 0 52734953 Development ceased Tupolev Voron 31.578082 2 0.0 NaN
10970 Category:Cancelled military aircraft projects ... n/a Error 0 0 3091933 Cancelled in 1943 Curtiss XP-71 30.830137 2 0.0 NaN
756 Category:World War II jet aircraft of Germany|... Error 0 0 1960033 Incomplete Junkers EF 132 27.616438 2 0.0 1940.0
10980 Category:Cancelled military aircraft projects ... Error 0 0 38894450 Boeing XP3B 21.726027 2 0.0 NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
10938 Category:Cancelled military aircraft projects ... Error 0 0 5790917 Waco C-62 9.189041 2 0.0 NaN
10915 Category:Unmanned aerial vehicles of the Unite... Error 0 0 30660469 Cornelius XBG-3 7.975342 2 0.0 NaN
220 Category:World War II helicopters of Germany|C... 1942 Error 0 0 59758227 paper project only Focke-Achgelis Fa 325 Error 6.673973 2 0.0 1942.0
10960 Category:Cancelled military aircraft projects ... Error 0 0 54636248 Grumman G-132 6.463014 2 0.0 NaN
2814 Category:1970s Spanish military trainer aircra... Error 0 0 14720320 Cancelled project CASA C-102 Error 6.232877 2 0.0 1970.0
6968 Category:1920s United States bomber aircraft|C... Error 0 0 46304057 Martin XNBL-2 6.049315 2 0.0 1920.0
6981 Category:1920s United States bomber aircraft|C... Error 0 0 59559563 project only Fokker XHB-2 6.024658 2 0.0 1920.0
1547 Category:1940s United States military utility ... Error 0 0 38541440 Culver PQ-10 5.769863 2 0.0 1940.0
10989 Category:Cancelled military aircraft projects ... Error 0 0 27001669 Cancelled Aircraft Research BT-11 5.758904 2 0.0 NaN
6976 Category:1920s United States bomber aircraft|C... Error 0 0 59810361 Paper project only Martin XLB-4 5.290411 2 0.0 1920.0
6977 Category:1920s United States bomber aircraft|C... Error 0 0 59850108 project only Huff-Daland XHB-3 4.994521 2 0.0 1920.0
924 Category:World War II Japanese fighter aircraf... Error 0 0 60158206 design only Kawanishi J6K 4.753425 2 0.0 1940.0
2225 Category:Unmanned military aircraft of the Uni... Error Error 0 0 56059749 Error Error Republic SD-4 Swallow 4.657534 2 0.0 NaN
11013 Category:Abandoned military aircraft engine pr... Error Error Error 0 0 33019572 Error Error Chrysler T36D 4.463014 2 0.0 NaN
11304 Category:Abandoned military aircraft projects ... Error 0 0 35761852 CTA Convertiplano Error 3.947945 2 0.0 NaN
1844 Category:Target drones|Category:Target drones|... Error Error Error 0 0 42152967 Error Error Frankfort OQ-16 3.167123 2 0.0 NaN
3645 Category:1930s Polish military reconnaissance ... Error 0 0 34545131 RWD 22 2.835616 2 0.0 1930.0
10969 Category:Cancelled military aircraft projects ... Error 0 0 50751636 Design only Douglas 423 2.586301 2 0.0 NaN
3270 Category:1940s British military trainer aircra... Error 0 0 56925923 Cancelled before completion of first prototype Boulton Paul P.112 2.567123 2 0.0 1940.0
3633 Category:1930s Soviet military reconnaissance ... Error 0 0 59592244 Error paper project only Tupolev ANT-30 2.342466 2 0.0 1930.0
6972 Category:1920s United States bomber aircraft|C... Error 0 0 46287781 Lowe-Willard-Fowler XNBS-2 2.336986 2 0.0 1920.0
925 Category:World War II Japanese fighter aircraf... Error 0 0 60157954 1945 design only Kawanishi J3K 2.235616 2 0.0 1940.0
1291 Category:Military aircraft of World War I|Cate... Error Error 0 0 40147381 Error cancelled Royal Aircraft Factory B.E.10 Error 2.065753 2 0.0 1910.0
438 Category:1940s United States military gliders|... Error 0 0 59779558 cancelled AGA Aviation LRG Error 1.372603 2 0.0 1940.0
10888 Category:Unmanned aerial vehicles of the Unite... never flew Error 0 0 59743525 design study only OQ-5 Error 1.158904 2 0.0 NaN
4279 Category:1930s Italian patrol aircraft|Categor... never Error 0 0 59725993 project only CANT 38 Error 1.139726 2 0.0 1930.0
419 Category:1940s United States military gliders|... Error 0 0 59779165 cancelled Snead LRH Error 1.019178 2 0.0 1940.0
3562 Category:1920s United States military reconnai... Error 0 0 59576639 design study only Douglas XNO-1 Error 0.967123 2 0.0 1920.0
3561 Category:1920s United States military reconnai... Error 0 0 59576734 design study only Douglas XNO-2 Error 0.750685 2 0.0 1920.0
4235 Category:1910s United States patrol aircraft|C... 0 0 (prototype not completed) 60912103 Canceled Naval Aircraft Factory Giant Boat 0.334247 2 0.0 1910.0

82 rows × 15 columns

In [298]:
mil_df.loc[mil_df.built_number == 1].sort_values(['views'],ascending=False)
Out[298]:
category first flight introduced introduction ns number built pageid retired status title unit cost views built_group built_number year
2379 Category:1940s United States military transpor... November 2, 1947 Error 0 1 197878 On display Hughes H-4 Hercules $2.5 million 1655.690411 1 1.0 1947.0
4769 Category:1990s Soviet and Russian fighter airc... 2 April 1996 Error 0 1 (conversion from Su-27M) 724871 Development ceased, aircraft crashed Sukhoi Su-37 590.079452 1 1.0 1996.0
4768 Category:1990s Soviet and Russian fighter airc... 25 September 1997 Error 0 1 844410 Cancelled Sukhoi Su-47 585.380822 1 1.0 1997.0
4910 Category:2010s Japanese fighter aircraft|Categ... 22 April 2016 Error 0 1 prototype 12057661 Error In development Mitsubishi X-2 Shinshin Error 561.013699 1 1.0 2016.0
4461 Category:2010s United States fighter aircraft|... demonstrator aircraft: 8 July 2010 Error Error 0 1 demonstrator 22321842 Error Cancelled Boeing F-15SE Silent Eagle F-15SE: [[United States dollar 436.643836 1 1.0 2010.0
11017 Category:Boeing military aircraft July 18, 2002 Error 0 1 163261 September 25, 2014 Canceled Boeing YAL-1 344.780822 1 1.0 2002.0
4765 Category:2000s Russian fighter aircraft|Catego... 29 February 2000 Error 0 1 941206 Cancelled Mikoyan Project 1.44 287.465753 1 1.0 2000.0
5174 Category:1970s French fighter aircraft|Categor... 9 March 1979 Error 0 1 1574932 Program cancelled in the 1980s Dassault Mirage 4000 251.643836 1 1.0 1979.0
2512 Category:1940s German military transport aircr... April 1944 Error 0 1 (with 2 incomplete prototypes) 460133 Blohm & Voss BV 238 231.898630 1 1.0 1944.0
2410 Category:Ukrainian military transport aircraft... 7 May 2015 0 1 (2015) 44425991 In production Antonov An-178 US$ 40-70 million 201.484932 1 1.0 2015.0
10344 Category:1990s United States military aircraft... September 11, 1996 Error 0 1 1048090 April 1999 On display Boeing Bird of Prey 200.202740 1 1.0 1996.0
6932 Category:1940s United States bomber aircraft|C... 27 June 1941 Error 0 1 878733 17 August 1946 Scrapped Douglas XB-19 191.693151 1 1.0 1941.0
2456 Category:1940s Soviet military transport aircr... 1942 Error 0 1 2167950 Cancelled Antonov A-40 187.917808 1 1.0 1942.0
2430 Category:2010s Russian military transport airc... 30 March 2019 Error 0 1 flyable prototype 11977166 Under development Ilyushin Il-112 181.506849 1 1.0 2019.0
6910 Category:1950s United States bomber aircraft|C... 18 April 1952 Error Error 0 1 complete, 1 partial 462213 Error Canceled 14 August 1952 Convair YB-60 Error 170.183562 1 1.0 1952.0
6964 Category:1930s United States bomber aircraft|C... 15 October 1937 Error Error 0 1 prototype 766141 Error Canceled Boeing XB-15 162.832877 1 1.0 1937.0
369 Category:United States military helicopters|Ca... June 29, 2007 Error 0 1 prototype 1263926 Phase 1 complete Piasecki X-49 158.890411 1 1.0 2007.0
411 Category:1990s United States military gliders|... August 11, 1998 Error Error 0 1 581848 Error Retired May 2001 Boeing X-40 149.887671 1 1.0 1998.0
2386 Category:1940s United States military transpor... 24 November 1947 26 May 1949 Error 0 1 466729 1957 Convair XC-99 146.315068 1 1.0 1947.0
1822 Category:Unmanned military aircraft|Category:U... 10 August 2013 Error 0 1 8354477 In development BAE Systems Taranis 144.150685 1 1.0 2013.0
7015 Category:1950s Soviet bomber aircraft|Category... 27 October 1959 Error 0 1 (+1 static test airframe, 1 M-52) 1493610 Retired Myasishchev M-50 138.750685 1 1.0 1959.0
11095 Category:Abandoned military aircraft projects ... 1961 Error 0 1 2834887 Tupolev Tu-95LAL 138.419178 1 1.0 1961.0
10920 Category:Unmanned aerial vehicles of the Unite... April 27, 2011 Error 0 1 27333891 Under development Boeing Phantom Ray 137.928767 1 1.0 2011.0
4472 Category:1970s United States fighter aircraft|... Error 0 1 6266766 Cancelled (1981) Rockwell XFV-12 136.164384 1 1.0 1970.0
958 Category:World War II fighter aircraft of Germ... August 1944 (Unpowered) Error 0 1 454962 Messerschmitt Me 263 128.249315 1 1.0 1944.0
7581 Category:1940s Soviet attack aircraft|Category... Error Error Error 0 1 10999314 Error Ilyushin Il-20 (1948) Error 124.906849 1 1.0 1940.0
391 Category:United States military helicopters|Ca... Error 0 1 (never completed) 11378800 Program terminated Boeing Vertol XCH-62 123.126027 1 1.0 NaN
349 Category:United States military helicopters|Ca... 20 August 1970 Error 0 1 1654092 Destroyed (1974 crash) Sikorsky S-67 Blackhawk 118.161644 1 1.0 1970.0
4560 Category:1940s United States fighter aircraft|... 1 June 1944 Error 0 1 2188015 Canceled Lockheed XP-58 Chain Lightning 117.679452 1 1.0 1944.0
2240 Category:Unmanned military aircraft of the Uni... 2005 Error 0 1 6028690 December 18, 2006 Lockheed Martin Polecat 106.452055 1 1.0 2005.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
3613 Category:1920s Soviet and Russian military rec... 23 September 1926 Error 0 1 59840874 Grigorovich MR-2 1.000000 1 1.0 1926.0
3140 Category:1920s French military trainer aircraf... 15 April 1923 Error 0 1 59851107 Blériot-SPAD S.72 0.989041 1 1.0 1923.0
5204 Category:1930s French fighter aircraft|Categor... 30 March 1938 Error 0 1 60112474 Romano R.110 Error 0.978082 1 1.0 1938.0
7227 Category:1930s French bomber aircraft|Category... 1938 Error 0 1 60112491 Romano R.120 Error 0.969863 1 1.0 1938.0
4432 Category:Fighter aircraft|Category:Fighter air... 1918 Error 0 1 59851536 Blériot-SPAD S.XXI Error 0.967123 1 1.0 1918.0
7094 Category:1920s Italian bomber aircraft|Categor... 1929 Error 0 1 59842284 Caproni Ca.103 Error 0.964384 1 1.0 1929.0
3612 Category:1920s Soviet and Russian military rec... July 1929 Error 0 1 59832193 Grigorovich MR-5 0.942466 1 1.0 1929.0
5107 Category:1910s German fighter aircraft|Categor... 1917 Error 0 1 59892478 Hansa-Brandenburg W.25 Error 0.926027 1 1.0 1917.0
4437 Category:Fighter aircraft|Category:Fighter air... 1920 Error 0 1 59851312 Blériot-SPAD S.38 Error 0.917808 1 1.0 1920.0
10887 Category:Unmanned aerial vehicles of the Unite... October 1941 Error 0 1 59743469 Radioplane OQ-12 Error 0.915068 1 1.0 1941.0
4431 Category:Fighter aircraft|Category:Fighter air... 1919 Error 0 1 59851583 Blériot-SPAD S.XXII Error 0.912329 1 1.0 1919.0
3142 Category:1920s French military trainer aircraf... 13 April 1923 Error 0 1 59851135 Blériot-SPAD S.62 0.901370 1 1.0 1923.0
3611 Category:1920s Soviet and Russian military rec... 2 June 1925 Error 0 1 59840757 Grigorovich MRL-1 0.884932 1 1.0 1925.0
4433 Category:Fighter aircraft|Category:Fighter air... 14 January 1923 Error 0 1 59851260 Blériot-SPAD S.71 Error 0.879452 1 1.0 1923.0
1293 Category:Military aircraft of World War I|Cate... 1917 Error 0 1 59825289 Roland C.VIII 0.879452 1 1.0 1917.0
4029 Category:1920s Czechoslovakian military reconn... {{avyear Error 0 1 59905717 Letov Š-5 0.865753 1 1.0 1920.0
3191 Category:1920s Czechoslovakian military traine... July 1930 Error 0 1 59905937 Letov Š-25 0.838356 1 1.0 1930.0
3919 Category:1930s French military reconnaissance ... 1930 Error 0 1 59837378 Levasseur PL.12 0.802740 1 1.0 1930.0
6431 Category:1920s Czechoslovakian fighter aircraf... {{avyear Error 0 1 59905795 Letov Š-12 0.789041 1 1.0 1920.0
1383 Category:Military aircraft of World War I|Cate... February 1916 Error 0 1 59721596 Bréguet XI Corsaire 0.783562 1 1.0 1916.0
3800 Category:1920s German military reconnaissance ... [[1926 in aviation Error 0 1 59805209 Caspar C 30 Error 0.780822 1 1.0 1926.0
3136 Category:1920s French military trainer aircraf... 1921 Error 0 1 60141084 Caudron C.51 0.775342 1 1.0 1921.0
3141 Category:1920s French military trainer aircraf... 5 April 1923 Error 0 1 59851189 Blériot-SPAD S.64 0.753425 1 1.0 1923.0
3920 Category:1930s French military reconnaissance ... 1931 Error 0 1 59837315 Levasseur PL.11 0.736986 1 1.0 1931.0
3799 Category:1920s German military reconnaissance ... [[1928 in aviation Error 0 1 59805491 Caspar C 36 Error 0.720548 1 1.0 1928.0
3110 Category:1930s French military trainer aircraf... {{avyear Error 0 1 59879340 Lorraine-Hanriot LH.60 Error 0.679452 1 1.0 1930.0
5056 Category:1920s German fighter aircraft|Categor... [[1924 in aviation Error 0 1 60094928 Caspar CJ 14 Error 0.638356 1 1.0 1924.0
5055 Category:1920s German fighter aircraft|Categor... [[1924 in aviation Error 0 1 60094951 Caspar CS 14 Error 0.635616 1 1.0 1924.0
1300 Category:Military aircraft of World War I|Cate... 1917 Error 0 1 60129786 Error Paul Schmitt Type 10 Error 0.564384 1 1.0 1917.0
5149 Category:1910s German fighter aircraft|Categor... October 1917 Error 0 1+3 unfinished prototypes 59595940 prototype only Aviatik (Berg) Dr.I Error 0.126027 1 1.0 1917.0

510 rows × 15 columns

In [303]:
mil_df.to_csv('military.csv')
civ_df.to_csv('civil.csv')
In [ ]: