Select Page

About

This is a new site, with a new hosting company. But in essence the data remains the same, well the free files are – there are some files now that are specifically aimed at covering the site costs. These files have a lot more data in them and are much more useful, the chargeable files are aimed at business and research users.

The Free Files

The free files are for plane spotters and aviation enthusiasts, where people would just like a simple reference file – the data is limited. Just the registration, manufacturer, model, construction number and registrant. Just five data points, cross references the registration to the airframe detail. You can import these files into your own application, where you can add what you want to it – or save a bit of work and buy our Excel data set for spotters. This has the additional data points with the build year and the ADSB code.

The Chargeable Files

If you have a need for more data, you should consider these files, by default they are in an Excel format – although they are also available in a comma separated format. These are much larger files, with so much more in them.

b

Enthusiast Data

The simplest of the data sets, containing eight data points for each aircraft. In ascending order by N-Number, the data points are.

  • N-Number (Registration)
  • Manufacturer Name
  • Model Name
  • Manufacturers Serial Number
  • Registrant
  • Build Year
  • ADSB Code
  • The Aircraft Class
i

Business Data

The intermediate or business data set, this is the one if you want to sell into the aviation community. All the enthusiast data plus:-

  • USPS Compliant Address
  • Includes Zip+4 Zip Code
  • Region
  • County
  • Country
  • Surname
  • Forename
  • Registrant Class (Individual, LLC, etc..)

Research Data

This is the full data set, there are twenty eight data points per record. In addition to all the business date, the following  data points are added.

  • Engine Type
  • Engine Manufacturer
  • Engine Model
  • Airworthiness Date
  • Certificate Issue Date
  • Certificate Expirey Date
  • Certification Types
  • Status

Available Formats

When it comes to the format of the data, we can supply the most common ones. These are Adobe Portable Document Format (PDF), Microsoft Excel and Comma Seperated Values (CSV). With the files being available in all three formats in each of the available downloads, should you require a different format like Json or pipe delimited please contact us.

This makes for some fairly large downloads, ranging in size from 100 to nearly 400Mb. Each data set also contains the “deregistered aircraft” file, with the matching data for around 380,000 historical records. It should however be noted that information in the deregistered file may be incomplete, due to the aged nature of the data. The files are delivered as compressed Zip files, just unzip and off you go, the data can be ammended, copied or imported.

Adobe Portable Document Format

An Adobe PDF (Portable Document Format) is like a digital version of a printed page.

  • It’s a type of file that keeps a document looking the same no matter where you open it – on a computer, phone, tablet, or printer.

  • Unlike a Word file or Google Doc, which can shift around depending on the software or fonts installed, a PDF locks in the layout.

  • That’s why PDFs are often used for things like tables and data, you know the person on the other end will see it exactly as you made it.

Think of a PDF as a “snapshot” of a document that’s still smart enough to let you copy text, search for words, and sometimes even fill out forms.

Microsoft Excel Spread Sheet

Think of it like a big piece of graph paper on your computer.

  • The little boxes (called cells) are like the squares on the graph paper. Each box can hold a piece of information – a number, a word or a date.

  • A whole page of these boxes is called a worksheet, and a file can have multiple worksheets – like different tabs in a notebook.

  • You can use it just to make neat lists, but you can simply add additional columns for whatever you want.

  • You can very quickly filter data based on columns, e.g. show only Cessna’s in Oregon.

  • Where MS Excel really comes into its own, when used in conjunction with other applications for things like mail merges.

Comma Separated Value

A Comma Separated Values (CSV) file is just a simple text file that stores data in a table format, like a spreadsheet, but without all the fancy formatting.

  • Each row in the file is one line of text.

  • Each column is separated by a comma.

  • The first line often contains the headers (column names).

  • After that, each line is one entry of data.

  • You can open it with any text editor (it looks like plain text), or in Excel/Google Sheets (it looks like a neat table).

It’s basically a very lightweight way to move data between programs without needing special software.

So think of the comma separated values file as the raw data, it can generally go anywhere and be opened by any software.

Special Requirements?

If you have a specific requirement, please reach out to us and we will endeavour to assist you.

12 Alford Place, Irvine, Ayrshire, KA11 1RZ

+44 77 88 71 03 06

contact@aeronumerology.com

Leave A Message