[php] [/php]

Australian Civil Aircraft Register

Choice of formats.

I created the original comma separated values file from the Australian Civil Aircraft Register. It has been downloaded over 100 times, as I’ve refreshed it four times – I’m guessing that about 20 or so individuals have downloaded it.

Now to make things even easier I’ve decided to make all the registers available in portable document format, that’s PDF. This is a more common format, which in many cases can be opened and eddited or annotated in a web browser – I find MS Edge to be very good.

I am keeping the download on this post at the moment, why? Well I would like some feed back from the people who down load it, the Australian Civil Aircraft Register is a test. If it is successful, I’ll make the others available – but they are very large files so I’d like feed back on formatting and the like. I estimate that the file will be around 450 pages for Australia, the other registers will obviously be much larger.

Available for Download

So that’s the file ready for download, it is a little larger than I expected at 469 pages. The contents of the file are from the historic download off the official site, this download is dated 31st December 2023 – I know that this one will remain unchanged now.

Feel free to download the file and copy to anyone you like providing it is for their personal use. As I said above, any feedback would be welcome and will help me make the downloads  better if not smaller.

Photograph above is attributed to YSSYguy, it was downloaded from Wikipedia.

Support this site.

It does take some time and effort to create these downloads, also there are a number of costs associated with running the site. So if you can consider supporting this site with a donation it would be helpful, if you find the site useful then why not treat me to a doughnut – or even a doughnut and a coffee if you’re feeling really flush.

Or if you are thinking of ordering something from Amazon then you could click the link to get there, it doesn’t actually cost you anything. And it will help me to pay for the site hosting, which is getting more expensive like everything else.

But regardless of whether you donate or not, I hope that the contents of the files are of some use, also bear in mind that the files are as dated in the bar graph on the down load page – I will try and produce a new data set every month or more frequently if time allows.

Please note these files are provided for personal use, if you want to use them for any other purpose or if you want to make them available through your own site – get in touch first.

 

 

Surprising Development

Unexpected Development.

I have decided to update the Plane Spotting Guide, it has come as a surprise to see that this was the most popular download of the last three months. The original guide was quite terse, with just a few pointers – I’ve enlarged it. Adding a few more sections and quite a few links that I hope will be useful.

 The whole guide has been updated, hopefully it will be of some use in its revised form.

 

Support this site.

It does take some time and effort to create these downloads, also there are a number of costs associated with running the site. So if you can consider supporting this site with a donation it would be helpful, if you find the site useful then why not treat me to a doughnut – or even a doughnut and a coffee if you’re feeling really flush.

Or if you are thinking of ordering something from Amazon then you could click the link to get there, it doesn’t actually cost you anything. And it will help me to pay for the site hosting, which is getting more expensive like everything else.

But regardless of whether you donate or not, I hope that the contents of the files are of some use, also bear in mind that the files are as dated in the bar graph on the down load page – I will try and produce a new data set every month or more frequently if time allows.

Please note these files are provided for personal use, if you want to use them for any other purpose or if you want to make them available through your own site – get in touch first.

 

 

Register Downloads 14/10/2024

Register Downloads

There are a new set of files available for download from the downloads page, the files changes are the usual culprits. The US Active and Deregistered aircraft, along with the Canadian and Australian files.

There have been almost 1000 records added to the four files over the past month, so the data set is getting larger – there will also be an unspecified number of changes of ownership over the last month.

As usual, the files can be downloaded and used for your own personal usee. Why not get in touch and tell us how you use them.

 

Support this site.

It does take some time and effort to create these downloads, also there are a number of costs associated with running the site. So if you can consider supporting this site with a donation it would be helpful, if you find the site useful then why not treat me to a doughnut – or even a doughnut and a coffee if you’re feeling really flush.

Or if you are thinking of ordering something from Amazon then you could click the link to get there, it doesn’t actually cost you anything. And it will help me to pay for the site hosting, which is getting more expensive like everything else.

But regardless of whether you donate or not, I hope that the contents of the files are of some use, also bear in mind that the files are as dated in the bar graph on the down load page – I will try and produce a new data set every month or more frequently if time allows.

Please note these files are provided for personal use, if you want to use them for any other purpose or if you want to make them available through your own site – get in touch first.

 

 

Survivors – P-51 – Mustang – USA

Surviving Mustangs

The list of surviving North American Mustangs is quite lenthy, but before delving into the survivors what is the definition of a Mustang. To understand this we need to look at the evolution of the Mustang, designed to a British specification by North American Aviation. Originally approached to Build the Curtis P-40 under licence for the British, there was agreement that a new design would be more appropriate and so the NA-73X was born. This was the original Mustang Mk I, at this point the British Purchasing Commission effectively ordered 320 off the drawing board.

Of the first batch of Mustangs, two were allocated to the USAAC – the serials allocated were 41-038 and 41-039 and the XP-51 had arrived. Originally armed with two .50 calibre guns in the nose and four .303 calibre wing mounted guns the Mustang Mk I (NA-73 and NA-83) became the Mustang Mk Ia (NA-91) in RAF service when the wing armament was changed to 4 * 20mm cannons. The a,b,c suffix being commonly used when there was a wing armaments change, particularly when changed within a version as here.

The Mustang Mk Ia was in production when the Japanese attacked Pearl Harbour, the USAAC withheld a number of the 300 Mk Ia Mustangs that had been ordered and these became the P-51-2 or the F6A in USAAC service. North American Aviation at this time was closely involved in the Rolls-Royce Mustang X project, to re-engine the Mustang with the Rolls-Royce Merlin 61 as used in the Spitfire Mk IX.

The above lineage brings us to the North American Aviation P-51A Mustang, on the way there was probably much in fighting among various factions – but essentially the P-51A was arrived at through British requirements and North American Aviation technical skills and manufacturing capacity, modified by British need.

There were over fifteen thousand Mustangs built of all variants, with a number still in active service until the1980’s. They were operated by many countries, even built in countries like Australia and Canada by the Commonwealth Aircraft Corporation.

How many still survive is a difficult question to answer, I don’t doubt that I will miss a few from the list. But to minimise the chance of this, the list will be broken into sections to make it more manageable as the largest group are the US registered aircraft – here they are all 211 of them.

The table below is the current list of surviving North American Mustangs on the US register as dated the 6th of August, these are all believed to be in a flyable condition although some of them may fly infrequently.

It is quite likely that the table will change from time to time, some will be added and in the event of accidents or sale some may be deleted – I will try and keep it up to date, any help would be appreciated.

 

Surviving P-51 Mustangs

Support this site.

It does take some time and effort to create these downloads, also there are a number of costs associated with running the site. So if you can consider supporting this site with a donation it would be helpful, if you find the site useful then why not treat me to a doughnut – or even a doughnut and a coffee if you’re feeling really flush.

But regardless of whether you donate or not, I hope that the contents of the files are of some use, also bear in mind that the files are as dated in the bar graph on the down load page – I will try and produce a new data set every month or more frequently if time allows.

Please note these files are provided for personal use, if you want to use them for any other purpose or if you want to make them available through your own site – get in touch first.

 

 

My data, your data.

Anyone who has visited the downloads page on this site will have seen that there are a number of files available, these files are created by me from a number of sources and I intend to add more files over time.

The files are created from official sources and come with any mistakes contained in those official sources, just because it comes from the Federal Aviation Authority doesn’t actually mean that it is correct. What has to be taken into account is the fact that there are probably few checks on the data, that the data is input by individuals and there are many ways for the individual to missconstrue that data.

Take as an example the North American P-51D Mustang, almost all of them are using the USAAF assigned serial number instaed of the North American manufactiring serial number. In some cases the USAAF serial number is hyphenated in other cases not, the aitcraft detail is also sometimes hyphenated and sometimes not as in P51 or P-51. Not that this is a problem in the case of the P-51D as the MSN can be tied to the USAAF serial with relative simplicity, it is just an example of how even data from official sources can be a bit ambiguous.

The P-51 is also recorded as a number of types, each with its own identifier in the FAA database download, these were the official type identifiers – so we also have the F-51 hyphenated and not along with the F6A. There can be incorect manufacturer names, one that comes to ming is American Avia INC – where the type is redorded as a “North American P-51B”.

It generally doesn’t matter, it may to the purist but for most plane spotters all there needs to be is a way of differentiating between aircraft of the same type.

There are many examples of this type error scattered throughout official data sources, generally considered too big a task to rectify these things tend to be left as they are  – just for ease of keeping relatively accurate records. In my data I have not ammended the serial number just because of the amount of work, what about your data?

 

Support this site.

It does take some time and effort to create these downloads, also there are a number of costs associated with running the site. So if you can consider supporting this site with a donation it would be helpful, if you find the site useful then why not treat me to a doughnut – or even a doughnut and a coffee if you’re feeling really flush.

But regardless of whether you donate or not, I hope that the contents of the files are of some use, also bear in mind that the files are as dated in the bar graph on the down load page – I will try and produce a new data set every month or more frequently if time allows.

Please note these files are provided for personal use, if you want to use them for any other purpose or if you want to make them available through your own site – get in touch first.

 

 

ADSB Global Hiding

The FAA’s decision to allow the obfuscation of private aircraft identities is not unique; it aligns with practices in other countries that have implemented similar measures. This alignment reflects a broader trend in international aviation regulations, where privacy and security concerns are increasingly prioritised. Here’s a closer look at how international practices and standards influence the FAA’s decision:

European Union (EU).

Mode S Transponders.

In the EU, the use of Mode S transponders is mandatory for most aircraft. Mode S transponders emit a unique ICAO hex code that can be tracked. However, similar to the FAA, certain provisions allow for the use of temporary codes, especially for government, military, or state aircraft.

Data Privacy Regulations.

Europe has stringent data privacy laws, such as the General Data Protection Regulation (GDPR), which influences how personal data, including flight data, is handled. There is a growing recognition in Europe that private aircraft ownership and flight movements constitute personal data that may require protection.

State Aircraft.

EASA allows state aircraft, including military, police, and customs aircraft, to use reserved ICAO 24-bit addresses, which are not tied to the usual civilian databases, thereby masking their identity.

United Kingdom (UK).

Block All.

At the moment the UK doesn’t seem to have a system where the aircraft can transmit a false Mode S code, however it is probably just a matter of time before this facility is incorporated in the legislation. Altough again here the good thing from a spotters perspective is the glacial progress that will be made by the legislators, along with the ineptitude of the teams that will be doing the work – so don’t expect it to happen soon.

Military and Government Flights.

Like the U.S., the UK permits the obfuscation of identities for military and government flights for security reasons. This practice influences civil aviation policies, allowing for more flexible approaches to privacy.

Australia.

Aircraft Privacy Option.

Australia’s Civil Aviation Safety Authority (CASA) provides an option for private aircraft owners to request privacy measures that limit the distribution of their aircraft’s identity and movement data. This is especially relevant for those who might face security risks.

State and VIP Aircraft.

Australia, like many other nations, allows state and VIP aircraft to use special codes that mask their identity for security and privacy purposes.

Canada.

National Defence and Private Aircraft.

In Canada, the Department of National Defence operates under specific regulations that permit the obfuscation of aircraft identities. Private aircraft owners also have some privacy protections, particularly in cases where there are security concerns.

NAV CANADA.

Canada’s air navigation service provider, NAV CANADA, supports privacy requests by limiting the display of certain aircraft on publicly accessible platforms.

International Civil Aviation Organization (ICAO) Guidelines.

State Aircraft and Reserved Codes.

ICAO, the international body that sets standards for aviation, recognizes the need for certain aircraft to operate under conditions of confidentiality. This includes the use of reserved ICAO 24-bit addresses and special call signs for state aircraft, which include military, police, and other government-operated flights.

Global Cooperation.

ICAO encourages member states to cooperate on matters of airspace security and privacy. This international cooperation often influences domestic policies, leading to the adoption of practices like those implemented by the FAA.

Middle Eastern Countries.

Security-Centric Policies.

In several Middle Eastern countries, where security concerns are high, obfuscation of aircraft identities is a common practice. This is often done to protect high-profile individuals, including royalty and government officials, from being tracked.

Influence on FAA Policy.

International Norms.

The FAA often aligns its regulations with international norms to maintain consistency and facilitate cooperation with other countries. When multiple countries adopt privacy measures for aircraft, it sets a standard that the FAA is likely to follow.

Reciprocity and Harmonization.

International aviation operates on principles of reciprocity and harmonisation. The FAA’s decision to allow identity obfuscation can be seen as part of an effort to ensure that U.S. practices are in line or ahead of other leading aviation authorities, where practical it does make sense to move towards regulatory alignment.

Summary

So the global aviation environment will probably move towards allowing high net worth individuals to hide the identity of their private aircraft, if they don’t remove the markings like registration or serial number from the aircraft it won’t cause more than anoyance from a spotting perspective – as the information will propagate up the spotting grapevine.

Spotters as I’ve said tend to be a fairly communicative bunch, they have even established world wide networks where information regarding aircraft identities is disseminated quite effectively. There may always be the case where an identity can’t be confirmed, but it is likely that these will be few and far between.