Need to translate from `airplane_type`.`identifier` values of `Ultraleichtflugzeug`, `Flugboot`. Also columns like `description`

[fortunewalla]

-- Some columns like `identifier` which contains values like Ultraleichtflugzeug, Flugboot seem to need translation. Also columns like `description`.

mysql> select distinct identifier from airplane_type limit 11; 
+---------------------+                                        
| identifier          |                                        
+---------------------+                                        
| Concorde            |                                        
| Tupolew Tu-144      |                                        
| Ultraleichtflugzeug |                                        
| Flugboot            |                                        
| Dornier Do X        |                                        
| Airbus A380         |                                        
| Airbus A310         |                                        
| Bristol Brabazon    |                                        
| Boeing B-377        |                                        
| Antonow An-225      |                                        
| Antonow An-124      |                                        
+---------------------+                                        
11 rows in set (0.00 sec)   

Mostly the general names. Need to be filtered further.

AirCRAFT

Concorde Ultraleichtflugzeug Flugboot Learjet Himmelslaus CriCri Channelwing Doppelraab Zieldarstellungsdrohne

[fortunewalla]

After investigation, it seems that most of the German aircraft names are brand names for various aircraft barring a few. So using the existing German names would make sense without much need for translation.

So we will close this for now unless, circumstances change.