AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: deedaa_andy on May 29, 2021, 07:13:38 PM

Title: Database explorer
Post by: deedaa_andy 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

Title: Re: Database explorer
Post by: Runway 31 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

Title: Re: Database explorer
Post by: deedaa_andy 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

Title: Re: Database explorer
Post by: Runway 31 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