anything
AirNav Radar
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Database explorer  (Read 6944 times)

0 Members and 1 Guest are viewing this topic.

deedaa_andy

  • New Member
  • *
  • Posts: 23
Database explorer
« on: May 29, 2021, 07:13:38 PM »
I am new to Airnav and wish to know what are all the abbreviation stand for in the database explorer

Runway 31

  • Moderator
  • Hero Member
  • *****
  • Posts: 34102
Re: Database explorer
« Reply #1 on: May 29, 2021, 09:25:46 PM »
Andy

Aircraft table

MS Hex code
AR Registration
CN Construction number
AI ICAO Type code
AT Aircraft model
CO Operator
COIACO IACO operator code

Alan

deedaa_andy

  • New Member
  • *
  • Posts: 23
Re: Database explorer
« Reply #2 on: May 30, 2021, 09:46:59 AM »
On my list I have got Airline list is MS, AR, AT, AN, AC, CN, PT, LK, PT2, LK2.
There is no AI, CO, OR COIACO ON.
But there is also other list in my database explorer
Actype, AT, AN & AG
Airlines,CN, C3, CM & C2
Airports, p4, p3, pn, pc, ps, pt, pm, pa & po
Routes, FN, NO, ND, NV & CH

Runway 31

  • Moderator
  • Hero Member
  • *****
  • Posts: 34102
Re: Database explorer
« Reply #3 on: May 30, 2021, 06:43:13 PM »
The easist way is to look at what is actually on the tables contained within the codes you detail to see examples

You state Airline list, all those are on the aircraft list

MS hex code, AR Registration  AT ICAO Aircraft code, AN Aircraft model details, AC Operator, CN Construction Number,  PT Photographer, LK Link to the photograph, PT2 Photographer 2. LK 2 Link to photograph 2,

actype  AT ICAO type code,  AN Aircraft model,  AG engine type

Airlines  CN Airline name, C3 ICAO Operator code C, no idea, C2 IATA Operator code

Airports p4 FAA/ICAO Code, p3 IATA Code, pn Airport name. pc airport city in,  ps state/county/province airport in, pt country airport in, pm no idea,  pa latitude, po lingtitude

Roures fn Flight ID, NO Departure airport, ND Arrival airport, NV via airport, CH timestamp for when database entry was made

Alan