Getting a list of sources

GET /api/sources?// Pagination parameters
$limit=100&     // Maximum number of records to return.
$top=700        // Number of records to skip.

Provides a list of sources, which are available in the database.

Examples

Get a first sources

/api/sources?$limit=1&
$top=0

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "id": 6,
      "name": "Aeroflot2412Bv20.txt",
      "airac_cycle": "2412",
      "stream_id": 1,
      "comments": "test",
      "arinc_standard": 20,
      "created_at": "2024-12-18T16:41:20.387+03:00",
      "updated_at": "2024-12-18T16:41:20.387+03:00"
    }
  ]
}

Live Response:

Check out actual server response by click button next to URL

Updating source information

POST /api/sources/{source_id}

Body parameters:

// New source parameters "new_filename" : "new_filename.txt",// New filename "new_airac_cycle" : "2201",// New AIRAC cycle "new_comments" : "Updating comments",// New comments "new_arinc_standard" : "20",// New ARINC standard "new_stream_id" : "1"// New stream id }

Update source metadata with POST method.

Examples

Updating source

Request Body:

{
  "source_id": 1,
  "new_filename": "new_filename.txt",
  "new_airac_cycle": "2201",
  "new_comments": "Updating comments",
  "new_arinc_standard": "20",
  "new_stream_id": "1"
}

Prepared Response:

{
  "status": "Ok",
  "records": "Source updated successfully"
}

Searching ARINC information

GET /api/select?// Pagination parameters
$limit=100&     // Maximum number of records to return.
$top=700&       // Number of records to skip.

// Primary parameters: applicable for any request; Some of them define type of record(Airport, Waypoint, FIR/UIR, etc.)
source_id=1&                // Specifies source ID, where records are extracted from
CustomerAreaCode=EUR&       // Specifies customer area code
SectionCode=D&              // Helps to specify type of record
SubsectionCode=DB&          // Helps to specify type of record
ContinuationRecordNo=0&     // Specifies continuation record number (0 or 1 for primary and 2-9 or A-Z for continuation)
CycleDate=2201&             // Determines AIRAC cycle date
FileRecordNo=1&             // Record number in file
line_number=1&              // Line number in file

// Secondary parameters: applicable for specific type of record. Some examples...
AirportICAOIdentifier=EDDF&     // Parameter, available for filtering among: NAVAID, Airport, Airport Gate records)
RouteIdentifier=UA857&          // Parameter, available for filtering among: Enrote Airways, Enrote Airways Restriction, etc.

// Other parameters: applicable for any request
$fields=RouteIdentifier:ri,SectionCode:sc,ContunuationRecordNo&     // Comma-separated list of fields to include in the response. ':' is used to specify renaming.
$is_parsed=true                                                    // Filter by parsed status

Flexible endpoint for searching ARINC records using primary (define type of record) and type-specific secondary parameters. Supports filtering with starts_with(), ends_with(), contains() functions. Non-applicable parameters are ignored.

Examples

Get not parsed records with section code D

/api/select?$limit=1&
$top=1&
SectionCode=D&
$is_parsed=false

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": false,
      "klass": "ArincParser_20::ST",
      "RouteIdentifier": "",
      "RecordType": "T",
      "CustomerAreaCode": "EEU",
      "SectionCode": "D",
      "SubsectionCode": "X",
      "AirportICAOIdentifier": "    ",
      "FileRecordNo": "96277",
      "CycleDate": "2408",
      "row": "TEEUDX       AD    UH100038     N48275900E135084800                       T000000191      WGEKHABAROVSK/TSENTRALNY         962772408",
      "line_number": 996280
    }
  ],
  "source": {
    "id": 14,
    "name": "RSD2505Av15.rar",
    "stream_id": 1,
    "airac_cycle": "2505",
    "comments": "TEST0",
    "arinc_standard": 20,
    "created_at": "2025-05-19T15:10:14.582+03:00",
    "updated_at": "2025-05-19T15:10:14.582+03:00",
    "processing_details": "Processing duration 131.87 sec",
    "status": "OK"
  },
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Get Airport(PA) records

/api/select?$limit=1&
$top=1&
SectionCode=P&
SubsectionCode=A&
ContinuationRecordNo=1

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::Airport_PA",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "EUR",
      "SectionCode": "P",
      "AirportICAOIdentifier": "EDOP",
      "FileRecordNo": "08209",
      "CycleDate": "2205",
      "Blank": " ",
      "ICAOCode": "ED",
      "SubsectionCode": "A",
      "AtaIataDesignator": "SZW",
      "Reserved": "  ",
      "Blank2": "   ",
      "ContinuationRecordNo": "1",
      "SpeedLimitAltitude": "FL100",
      "LongestRunway": "098",
      "IFRCapability": "Y",
      "LongestRunwaySurfaceCode": "H",
      "AirportReferencePointLatitude": "N53253719",
      "AirportReferencePointLongitude": "E011470036",
      "MagneticVariation": "E0029",
      "AirportElevation": "00166",
      "SpeedLimit": "250",
      "RecommendedNavaid": "    ",
      "ICAOCode2": "  ",
      "TransitionsAltitude": "05000",
      "TransitionLevel": "     ",
      "PublicMilitaryIndicator": "C",
      "TimeZone": "A00",
      "DaylightIndicator": "Y",
      "MagneticTrueIndicator": "M",
      "DatumCode": "WGE",
      "AirportName": "SCHWERIN/PARCHIM              ",
      "row": "SEURP EDOPEDASZW     1FL100098YHN53253719E011470036E002900166250      05000     CA00YMWGE    SCHWERIN/PARCHIM              082092205",
      "line_number": 608210
    }
  ],
  "count": 2
}

Live Response:

Check out actual server response by click button next to URL

Get Airport(PA) records using function contains()

/api/select?$limit=1&
$top=1&
SectionCode=P&
SubsectionCode=A&
ContinuationRecordNo=1&
CustomerAreaCode=contains(ME)

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::Airport_PA",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "MES",
      "SectionCode": "P",
      "AirportICAOIdentifier": "OIMC",
      "FileRecordNo": "32769",
      "CycleDate": "1610",
      "Blank": " ",
      "ICAOCode": "OI",
      "SubsectionCode": "A",
      "AtaIataDesignator": "CKT",
      "Reserved": "  ",
      "Blank2": "   ",
      "ContinuationRecordNo": "1",
      "SpeedLimitAltitude": "10000",
      "LongestRunway": "127",
      "IFRCapability": "Y",
      "LongestRunwaySurfaceCode": "H",
      "AirportReferencePointLatitude": "N36291700",
      "AirportReferencePointLongitude": "E061041200",
      "MagneticVariation": "E0035",
      "AirportElevation": "00953",
      "SpeedLimit": "250",
      "RecommendedNavaid": "    ",
      "ICAOCode2": "  ",
      "TransitionsAltitude": "04000",
      "TransitionLevel": "     ",
      "PublicMilitaryIndicator": "C",
      "TimeZone": "C30",
      "DaylightIndicator": "Y",
      "MagneticTrueIndicator": "M",
      "DatumCode": "WGE",
      "AirportName": "SARAKHS                       ",
      "row": "SMESP OIMCOIACKT     110000127YHN36291700E061041200E003500953250      04000     CC30YMWGE    SARAKHS                       327691610",
      "line_number": 932768
    }
  ],
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Get Airport(PA) records using function ends_with()

/api/select?$limit=1&
$top=1&
SectionCode=P&
SubsectionCode=A&
ContinuationRecordNo=1&
CustomerAreaCode=ends_with(S)

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::Airport_PA",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "MES",
      "SectionCode": "P",
      "AirportICAOIdentifier": "LCEN",
      "FileRecordNo": "86465",
      "CycleDate": "1610",
      "Blank": " ",
      "ICAOCode": "LC",
      "SubsectionCode": "A",
      "AtaIataDesignator": "ECN",
      "Reserved": "  ",
      "Blank2": "   ",
      "ContinuationRecordNo": "1",
      "SpeedLimitAltitude": "     ",
      "LongestRunway": "090",
      "IFRCapability": "Y",
      "LongestRunwaySurfaceCode": "H",
      "AirportReferencePointLatitude": "N35085600",
      "AirportReferencePointLongitude": "E033295900",
      "MagneticVariation": "E0040",
      "AirportElevation": "00402",
      "SpeedLimit": "   ",
      "RecommendedNavaid": "ECN ",
      "ICAOCode2": "LC",
      "TransitionsAltitude": "09000",
      "TransitionLevel": "11000",
      "PublicMilitaryIndicator": "C",
      "TimeZone": "B00",
      "DaylightIndicator": "Y",
      "MagneticTrueIndicator": "M",
      "DatumCode": "WGE",
      "AirportName": "LEFKOSA/ERCAN INT             ",
      "row": "SMESP LCENLCAECN     1     090YHN35085600E033295900E004000402   ECN LC0900011000CB00YMWGE    LEFKOSA/ERCAN INT             864651610",
      "line_number": 886466
    }
  ],
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Get Airport(PA) records using function starts_with() and $fields parameter

/api/select?$limit=1&
$top=1&
SectionCode=P&
SubsectionCode=A&
ContinuationRecordNo=1&
AirportName=starts_with(ANKARA)&
$fields=AirportName

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "AirportName": "ANKARA/GUVERCINLIK            "
    }
  ],
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Get Runway records(PG)

/api/select?$limit=1&
$top=1&
SectionCode=P&
SubsectionCode=G&
ContinuationRecordNo=0

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::Runway_PG",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "AFR",
      "SectionCode": "P",
      "AirportICAOIdentifier": "AN01",
      "FileRecordNo": "33137",
      "CycleDate": "2303",
      "Blank": " ",
      "AirportICAOCode": "AN01",
      "ICAOCode": "FA",
      "SubsectionCode": "G",
      "RunwayIdentifier": "RW11 ",
      "Blank2": "   ",
      "ContinuationRecordNo": "0",
      "RunwayLength": "09843",
      "RunwayMagneticBearing": "107T",
      "Blank3": " ",
      "RunwayLatitude": "S70491390",
      "RunwayLongitude": "E011353110",
      "RunwayGradient": "-0733",
      "Blank4": "    ",
      "EllipsoidHeight": "      ",
      "LandingThresholdElevation": "01873",
      "DisplacedThresholdDistance": "0000",
      "Blank5": "  ",
      "RunwayWidth": "197",
      "THCValueIndicator": "D",
      "Localizer_MSL_GLS_RefPathIdentifier": "    ",
      "Localizer_MLS_GLS_CategoryClass": " ",
      "Stopway": "0295",
      "SecondLocalizer_MSL_GLS_RefPathIdentifier": "    ",
      "SecondLocalizer_MLS_GLS_CategoryClass": " ",
      "TresholdCrossHeight": "050",
      "Reserved": "   ",
      "RunwayDescription": "                      ",
      "row": "SAFRP AN01FAGRW11    009843107T S70491390E011353110-0733          018730000  197D     0295     050                         331372303",
      "line_number": 33138
    }
  ],
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Get Runway records(PG) with $fields parameter

/api/select?$limit=1&
$top=1&
SectionCode=P&
SubsectionCode=G&
ContinuationRecordNo=0&
$fields=RouteIdentifier:route_id,AirportICAOCode,RunwayLength:lenght

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "route_id": "",
      "AirportICAOCode": "AN01",
      "lenght": "09843"
    }
  ],
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Get FIR/UIR primary records(UF) and choose where name starts with 'NICOSIA' and cont. num. 0

/api/select?$limit=1&
$top=1&
SectionCode=U&
SubsectionCode=F&
ContinuationRecordNo=0&
FIR_UIR_Name=starts_with(NICOSIA)

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::FIR_UIR_UF",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "MES",
      "SectionCode": "U",
      "AirportICAOIdentifier": "LCCC",
      "FileRecordNo": "21799",
      "CycleDate": "2112",
      "SubsectionCode": "F",
      "FIRUIRIdentifier": "LCCC",
      "FIRUIRAddress": "ZRZX",
      "FIRUIRIndicator": "B",
      "SequenceNumber": "0010",
      "ContinuationRecordNo": "0",
      "AdjFIRIdent": "HECC",
      "AdjUIRIdent": "HECC",
      "ReportingUnitsSpeed": "1",
      "ReportingUnitsAltitude": "1",
      "EntryReport": "N",
      "Blank": " ",
      "BoundatyVia": "G ",
      "FIR_UIR_Latitude": "N31500000",
      "FIR_UIR_Longitude": "E033590000",
      "ArcOriginLatitude": "         ",
      "ArcOriginLongitude": "          ",
      "ArcDistance": "    ",
      "ArcBearing": "    ",
      "FIRUpperLimit": "FL660",
      "UIRLowerLimit": "FL660",
      "UIRUpperLimit": "UNLTD",
      "CruiseTableInd": "  ",
      "FIR_UIR_Name": "NICOSIA FIR/UIR          ",
      "row": "SMESUFLCCCZRZXB00100HECCHECC11N G N31500000E033590000                           FL660FL660UNLTD   NICOSIA FIR/UIR          217992112",
      "line_number": 1021800
    }
  ],
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Selecting FIRs/UIRs with AirportICAOIdentifier = DAAA. Selecting only SequenceNumber, Latitude and Longitude fields

/api/select?$limit=1&
$top=1&
SectionCode=U&
SubsectionCode=F&
ContinuationRecordNo=0&
AirportICAOIdentifier=DAAA&
$fields=SequenceNumber:seq,FIR_UIR_Latitude:lat,FIR_UIR_Longitude:lon

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "seq": "0020",
      "lat": "N37122000",
      "lon": "E008341000"
    }
  ],
  "source": {
    "id": 13,
    "name": "Aeroflot2412Bv20.zip",
    "airac_cycle": "2413",
    "comments": "Test Aeroflot2412Bv20.zip upload (wrong airac cycle 2413 for debug)",
    "arinc_standard": 20,
    "created_at": "2024-12-25T09:22:48.620+03:00",
    "updated_at": "2025-01-13T19:53:48.608+03:00"
  },
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Get Enroute Airways primary records(ER) and choose where Route Identifier starts with 'A902' and cont. num. 1

/api/select?$limit=1&
$top=1&
SectionCode=E&
SubsectionCode=R&
RouteIdentifier=starts_with(A902)

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::EnrouteAirways_ER",
      "RouteIdentifier": "A902 ",
      "RecordType": "S",
      "CustomerAreaCode": "EEU",
      "SectionCode": "E",
      "AirportICAOIdentifier": "    ",
      "FileRecordNo": "71334",
      "CycleDate": "2013",
      "SubsectionCode": "R",
      "Blank": "       ",
      "Reserved": " ",
      "Blank2": "      ",
      "SequenceNumber": "0010",
      "FixIdentifier": "PARAT",
      "ICAOCode": "UR",
      "SectionCode2": "E",
      "SubsectionCode2": "A",
      "ContinuationRecordNo": "2",
      "ApplicationType": "P",
      "StartEndIndicator": " ",
      "Blank3": "                         ",
      "RestrictedAirspaceICAOCode": "  ",
      "RestrictedAirspaceType": " ",
      "RestrictedAirspaceDesignation": "          ",
      "RestrictedAirspaceMultipleCode": " ",
      "RestrictedAirspaceICAOCode2": "  ",
      "RestrivtedAirspaceType2": " ",
      "RestrictedAirspaceDesignation2": "          ",
      "RestrictedAirspaceMultipleCode2": " ",
      "RestrictedAirspaceICAOCode3": "  ",
      "RestrictedAirspaceType3": " ",
      "RestrictedAirspaceDesignation3": "          ",
      "RestrictedAirspaceMultipleCode3": " ",
      "RestrictedAirspaceICAOCode4": "  ",
      "RestrictedAirspaceType4": " ",
      "RestrictedAirspaceDesignation4": "          ",
      "RestrictedAirspaceMultipleCode4": " ",
      "RestrictedAirspaceLinkContinuation": " ",
      "row": "SEEUER       A902        0010PARATUREA2P                                                                                   713342013",
      "line_number": 171333
    }
  ],
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Get primary Waypoint Records(EA) and choose where cont. num. 1

/api/select?$limit=1&
$top=1&
SectionCode=E&
SubsectionCode=A&
ContinuationRecordNo=1

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::Waypoint_EA",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "EUR",
      "SectionCode": "E",
      "AirportICAOIdentifier": "ENRT",
      "FileRecordNo": "26006",
      "CycleDate": "2302",
      "SubsectionCode": "A",
      "Blank": " ",
      "RegionCode": "ENRT",
      "ICAOCode": "  ",
      "WaypointIdentifier": "2940N",
      "Blank2": " ",
      "ICAOCode2": "LP",
      "ContinuationRecordNo": "1",
      "Blank3": "    ",
      "WaypointType": "WUZ",
      "WaypointUsage": " H",
      "Blank4": " ",
      "WaypointLatitude": "N29000000",
      "WaypointLongitude": "W040000000",
      "Blank5": "                       ",
      "DynamycMagneticVariation": "W0130",
      "Reserved": "     ",
      "DatumCode": "WGE",
      "Reserved2": "        ",
      "NameFormatIndicator": "L  ",
      "WaypointNameDescrption": "29N040W (NAT)            ",
      "row": "SEUREAENRT   2940N LP1    WUZ H N29000000W040000000                       W0130     WGE        L  29N040W (NAT)            260062302",
      "line_number": 526005
    }
  ],
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Get primary Waypoint Records(PC) and choose where cont. num. 1

/api/select?$limit=1&
$top=1&
SectionCode=P&
SubsectionCode=C&
ContinuationRecordNo=1

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::Waypoint_PC",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "EUR",
      "SectionCode": "P",
      "AirportICAOIdentifier": "BGSF",
      "FileRecordNo": "76920",
      "CycleDate": "2403",
      "Blank": " ",
      "SubsectionCode": "C",
      "RegionCode": "BGSF",
      "ICAOCode": "BG",
      "WaypointIdentifier": "CL09 ",
      "Blank2": " ",
      "ICAOCode2": "BG",
      "ContinuationRecordNo": "1",
      "Blank3": "    ",
      "WaypointType": "ICF",
      "WaypointUsage": "  ",
      "Blank4": " ",
      "WaypointLatitude": "N66542603",
      "WaypointLongitude": "W051121677",
      "Blank5": "                       ",
      "DynamycMagneticVariation": "W0280",
      "Reserved": "     ",
      "DatumCode": "WGE",
      "Reserved2": "        ",
      "NameFormatIndicator": "   ",
      "WaypointNameDescrption": "ISF268ISF0140            ",
      "row": "SEURP BGSFBGCCL09  BG1    ICF   N66542603W051121677                       W0280     WGE           ISF268ISF0140            769202403",
      "line_number": 576919
    }
  ],
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Flight Planning Arrival/Departure Data Records (PR) and choose where cont. num. 1

/api/select?$limit=1&
$top=1&
SectionCode=P&
SubsectionCode=R&
ContinuationRecordNo=1

Prepared Response:

{
  "status": "Ok",
  "records": [],
  "count": 0
}

Live Response:

Check out actual server response by click button next to URL

Heliport Terminal Waypoint Records (HC) and choose where cont. num. 1

/api/select?$limit=1&
$top=1&
SectionCode=H&
SubsectionCode=C&
ContinuationRecordNo=1

Prepared Response:

{
  "status": "Ok",
  "records": [],
  "count": 0
}

Live Response:

Check out actual server response by click button next to URL

Choose Enrote Airway record from latest ARINC with defined id and related with known VHF NAVAID Record (D)

/api/select?$limit=1&
source_id=latest&
SectionCode=E&
SubsectionCode=R&
SectionCode2=D&
SubsectionCode2=%20&
ContinuationRecordNo=1&
FixIdentifier=starts_with(CVO)&
RouteIdentifier=starts_with(A16)&
ICAOCode=HE

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::EnrouteAirways_ER",
      "RouteIdentifier": "A16  ",
      "RecordType": "S",
      "CustomerAreaCode": "AFR",
      "SectionCode": "E",
      "AirportICAOIdentifier": "    ",
      "FileRecordNo": "11627",
      "CycleDate": "1613",
      "SubsectionCode": "R",
      "Blank": "       ",
      "Reserved": " ",
      "Blank2": "      ",
      "SequenceNumber": "3270",
      "FixIdentifier": "CVO  ",
      "ICAOCode": "HE",
      "SectionCode2": "D",
      "SubsectionCode2": " ",
      "ContinuationRecordNo": "1",
      "WaypointDescriptionCode": "VEC ",
      "BoundaryCode": " ",
      "RouteType": "O",
      "Level": "B",
      "DirectionRestriction": " ",
      "CruiseTableIndicator": "  ",
      "EUIndicator": " ",
      "RecommendedNAVAID": "    ",
      "ICAOCode2": "  ",
      "RNP": "050",
      "Blank3": "   ",
      "Theta": "    ",
      "Rho": "    ",
      "OutboundMagneticCource": "0000",
      "RouteDistanceFrom": "0000",
      "InboundMagneticCource": "1670",
      "Blank4": " ",
      "MinAltitude1": "     ",
      "MinAltitude2": "     ",
      "MaxAltitude": "     ",
      "FixRadiusTrasitionIndicator": "   ",
      "VerticalScaleFactor": "   ",
      "RVSMMinLvl": "   ",
      "VSF_RVM_MaximumLevel": "   ",
      "Reserved2": "    ",
      "Blank5": "         ",
      "row": "SAFRER       A16         3270CVO  HED 1VEC  OB          050           000000001670                                         116271613",
      "line_number": 11628
    }
  ],
  "source": {
    "id": 3,
    "status": "OK",
    "name": "Aeroflot2501Bv20.txt",
    "stream_id": 1,
    "airac_cycle": "2501",
    "comments": "Test .txt upload",
    "arinc_standard": 20,
    "processing_details": "Processing duration 150.67 sec",
    "created_at": "2025-04-17T16:50:31.445+03:00",
    "updated_at": "2025-04-17T16:50:31.445+03:00"
  },
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Choose primary VHF NAVAID record from latest ARINC with defined identifier and ICAOCode2 field

/api/select?$limit=1&
source_id=latest&
SectionCode=D&
SubsectionCode=%20&
ContinuationRecordNo=1&
VORIdentifier=starts_with(CVO)&
ICAOCode2=HE

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::VHF_NAVAID_D",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "AFR",
      "SectionCode": "D",
      "AirportICAOIdentifier": "    ",
      "FileRecordNo": "00151",
      "CycleDate": "2201",
      "SubsectionCode": " ",
      "ICAOCode": "  ",
      "Blank": "   ",
      "VORIdentifier": "CVO ",
      "Blank2": "  ",
      "ICAOCode2": "HE",
      "ContinuationRecordNo": "1",
      "VORFrequency": "11520",
      "NAVAIDClass": "VDU  ",
      "VORLatitude": "N30053230",
      "VORLongitude": "E031231830",
      "DMEIdent": "    ",
      "DMELatitude": "N30053230",
      "DMELongitude": "E031231830",
      "StationDeclination": "E0050",
      "DMEElevation": "00460",
      "FigureOfMerit": "2",
      "ILS_DME_Bias": "  ",
      "FrequencyProtection": "265",
      "DatumCode": "WGE",
      "VORName": "CAIRO                    ",
      "RouteInappropriateDME": " ",
      "DMEOperationalServiceVolume": "U",
      "row": "SAFRD        CVO   HE111520VDU  N30053230E031231830    N30053230E031231830E0050004602  265WGECAIRO                        U001512201",
      "line_number": 152
    }
  ],
  "source": {
    "id": 3,
    "status": "OK",
    "name": "Aeroflot2501Bv20.txt",
    "stream_id": 1,
    "airac_cycle": "2501",
    "comments": "Test .txt upload",
    "arinc_standard": 20,
    "processing_details": "Processing duration 150.67 sec",
    "created_at": "2025-04-17T16:50:31.445+03:00",
    "updated_at": "2025-04-17T16:50:31.445+03:00"
  },
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Choose Enrote Airway record from latest ARINC with defined id and related with known NDB NAVAID Record (DB)

/api/select?$limit=1&
source_id=latest&
SectionCode=E&
SubsectionCode=R&
SectionCode2=D&
SubsectionCode2=B&
ContinuationRecordNo=1&
FIXIdentifier=starts_with(AUB)&
RouteIdentifier=starts_with(B27)&
ICAOCode=PA

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::EnrouteAirways_ER",
      "RouteIdentifier": "B27  ",
      "RecordType": "S",
      "CustomerAreaCode": "CAN",
      "SectionCode": "E",
      "AirportICAOIdentifier": "    ",
      "FileRecordNo": "08066",
      "CycleDate": "2406",
      "SubsectionCode": "R",
      "Blank": "       ",
      "Reserved": " ",
      "Blank2": "      ",
      "SequenceNumber": "6110",
      "FixIdentifier": "HHM  ",
      "ICAOCode": "PA",
      "SectionCode2": "D",
      "SubsectionCode2": "B",
      "ContinuationRecordNo": "1",
      "WaypointDescriptionCode": "N C ",
      "BoundaryCode": " ",
      "RouteType": "O",
      "Level": "L",
      "DirectionRestriction": " ",
      "CruiseTableIndicator": "  ",
      "EUIndicator": " ",
      "RecommendedNAVAID": "    ",
      "ICAOCode2": "  ",
      "RNP": "   ",
      "Blank3": "   ",
      "Theta": "    ",
      "Rho": "    ",
      "OutboundMagneticCource": "1919",
      "RouteDistanceFrom": "1601",
      "InboundMagneticCource": "0000",
      "Blank4": " ",
      "MinAltitude1": "06000",
      "MinAltitude2": "     ",
      "MaxAltitude": "17500",
      "FixRadiusTrasitionIndicator": "   ",
      "VerticalScaleFactor": "   ",
      "RVSMMinLvl": "   ",
      "VSF_RVM_MaximumLevel": "   ",
      "Reserved2": "    ",
      "Blank5": "         ",
      "row": "SCANER       B27         6110HHM  PADB1N C  OL                        191916010000 06000     17500                         080662406",
      "line_number": 108067
    }
  ],
  "source": {
    "id": 3,
    "status": "OK",
    "name": "Aeroflot2501Bv20.txt",
    "stream_id": 1,
    "airac_cycle": "2501",
    "comments": "Test .txt upload",
    "arinc_standard": 20,
    "processing_details": "Processing duration 150.67 sec",
    "created_at": "2025-04-17T16:50:31.445+03:00",
    "updated_at": "2025-04-17T16:50:31.445+03:00"
  },
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Choose primary NDB NAVAID record from latest ARINC with defined identifier and ICAOCode2 field

/api/select?$limit=1&
source_id=latest&
SectionCode=D&
SubsectionCode=B&
ContinuationRecordNo=1&
NDBIdentifier=starts_with(AUB)&
ICAOCode2=PA

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::NDB_NAVAID_DB",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "CAN",
      "SectionCode": "D",
      "AirportICAOIdentifier": "    ",
      "FileRecordNo": "99229",
      "CycleDate": "1605",
      "SubsectionCode": "B",
      "ICAOCode": "  ",
      "Blank": " ",
      "NDBIdentifier": "AUB ",
      "Blank2": "  ",
      "ICAOCode2": "PA",
      "ContinuationRecordNo": "1",
      "NDBFrequency": "03550",
      "NDBClass": "H MW ",
      "NDBLatitude": "N58441380",
      "NDBLongitude": "W156464191",
      "Blank3": "                       ",
      "MagneticVariation": "E0160",
      "Blank4": "      ",
      "Reserved": "     ",
      "DatumCode": "NAR",
      "NDBName": "CHINOOK                       ",
      "row": "SCANDB       AUB   PA103550H MW N58441380W156464191                       E0160           NARCHINOOK                       992291605",
      "line_number": 99230
    }
  ],
  "source": {
    "id": 3,
    "status": "OK",
    "name": "Aeroflot2501Bv20.txt",
    "stream_id": 1,
    "airac_cycle": "2501",
    "comments": "Test .txt upload",
    "arinc_standard": 20,
    "processing_details": "Processing duration 150.67 sec",
    "created_at": "2025-04-17T16:50:31.445+03:00",
    "updated_at": "2025-04-17T16:50:31.445+03:00"
  },
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Choose Enrote Airway record from latest ARINC with defined id and related with known Waypoint Record (EA)

/api/select?$limit=1&
source_id=latest&
SectionCode=E&
SubsectionCode=R&
SectionCode2=E&
SubsectionCode2=A&
ContinuationRecordNo=1&
FIXIdentifier=starts_with(RASDA)&
RouteIdentifier=starts_with(B27)&
ICAOCode=PA

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::EnrouteAirways_ER",
      "RouteIdentifier": "B27  ",
      "RecordType": "S",
      "CustomerAreaCode": "CAN",
      "SectionCode": "E",
      "AirportICAOIdentifier": "    ",
      "FileRecordNo": "08072",
      "CycleDate": "2406",
      "SubsectionCode": "R",
      "Blank": "       ",
      "Reserved": " ",
      "Blank2": "      ",
      "SequenceNumber": "6140",
      "FixIdentifier": "BIBNE",
      "ICAOCode": "PA",
      "SectionCode2": "E",
      "SubsectionCode2": "A",
      "ContinuationRecordNo": "1",
      "WaypointDescriptionCode": "E C ",
      "BoundaryCode": " ",
      "RouteType": "O",
      "Level": "L",
      "DirectionRestriction": " ",
      "CruiseTableIndicator": "  ",
      "EUIndicator": " ",
      "RecommendedNAVAID": "    ",
      "ICAOCode2": "  ",
      "RNP": "   ",
      "Blank3": "   ",
      "Theta": "    ",
      "Rho": "    ",
      "OutboundMagneticCource": "1384",
      "RouteDistanceFrom": "0701",
      "InboundMagneticCource": "1384",
      "Blank4": " ",
      "MinAltitude1": "03000",
      "MinAltitude2": "     ",
      "MaxAltitude": "17500",
      "FixRadiusTrasitionIndicator": "   ",
      "VerticalScaleFactor": "   ",
      "RVSMMinLvl": "   ",
      "VSF_RVM_MaximumLevel": "   ",
      "Reserved2": "    ",
      "Blank5": "         ",
      "row": "SCANER       B27         6140BIBNEPAEA1E C  OL                        138407011384 03000     17500                         080722406",
      "line_number": 108073
    }
  ],
  "source": {
    "id": 3,
    "status": "OK",
    "name": "Aeroflot2501Bv20.txt",
    "stream_id": 1,
    "airac_cycle": "2501",
    "comments": "Test .txt upload",
    "arinc_standard": 20,
    "processing_details": "Processing duration 150.67 sec",
    "created_at": "2025-04-17T16:50:31.445+03:00",
    "updated_at": "2025-04-17T16:50:31.445+03:00"
  },
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Choose primary Waypoint Record (EA) record from latest ARINC with defined identifier and ICAOCode2 field

/api/select?$limit=1&
source_id=latest&
SectionCode=E&
SubsectionCode=A&
ContinuationRecordNo=1&
WaypointIdentifier=starts_with(RASDA)&
ICAOCode2=LC

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "is_parsed": true,
      "klass": "ArincParser_20::Waypoint_EA",
      "RouteIdentifier": "",
      "RecordType": "S",
      "CustomerAreaCode": "MES",
      "SectionCode": "E",
      "AirportICAOIdentifier": "ENRT",
      "FileRecordNo": "62434",
      "CycleDate": "1003",
      "SubsectionCode": "A",
      "Blank": " ",
      "RegionCode": "ENRT",
      "ICAOCode": "  ",
      "WaypointIdentifier": "RASDA",
      "Blank2": " ",
      "ICAOCode2": "LC",
      "ContinuationRecordNo": "1",
      "Blank3": "    ",
      "WaypointType": "RUZ",
      "WaypointUsage": " L",
      "Blank4": " ",
      "WaypointLatitude": "N33060000",
      "WaypointLongitude": "E030570000",
      "Blank5": "                       ",
      "DynamycMagneticVariation": "E0048",
      "Reserved": "     ",
      "DatumCode": "WGE",
      "Reserved2": "        ",
      "NameFormatIndicator": "   ",
      "WaypointNameDescrption": "RASDA                    ",
      "row": "SMESEAENRT   RASDA LC1    RUZ L N33060000E030570000                       E0048     WGE           RASDA                    624341003",
      "line_number": 862435
    }
  ],
  "source": {
    "id": 3,
    "status": "OK",
    "name": "Aeroflot2501Bv20.txt",
    "stream_id": 1,
    "airac_cycle": "2501",
    "comments": "Test .txt upload",
    "arinc_standard": 20,
    "processing_details": "Processing duration 150.67 sec",
    "created_at": "2025-04-17T16:50:31.445+03:00",
    "updated_at": "2025-04-17T16:50:31.445+03:00"
  },
  "count": 1
}

Live Response:

Check out actual server response by click button next to URL

Download source

GET /api/sources/download/{source_id}

Allows to get source with specified id in text file inside .zip archive.

Delete source

DELETE /api/sources/{source_id}

Allows to delete source with specified id.

Examples

Delete source with id 15

Prepared Response:

{
  "status": "Ok",
  "records": "1 arinc source(s) with id: 15 was deleted"
}

Uploading new source

POST /api/sources

Allows to upload new source with sending following parameters in form-data: file, airac_cycle, comments, arinc_standard.

Examples

Uploading new source with valid parameters

Prepared Response:

{
  "status": "Ok",
  "records": "File was accepted"
}

Create new stream

POST /api/streams

Body parameters:

// Stream parameters "name" : "Example of stream name",// Stream name which you create "description" : "Some description, which you want to attach to stream"// Description of stream }

Allows to create new stream with specified parameters. Stream name must be unique in database

Examples

Create new stream

Request Body:

{
  "name": "Example of stream name",
  "description": "Some description, which you want to attach to stream"
}

Prepared Response:

{
  "status": "Ok",
  "records": "Stream created successfully. Stream id: 10"
}

Getting a list of streams

GET /api/streams?// Pagination parameters
$limit=100&     // Maximum number of records to return.
$top=700        // Number of records to skip.

Provides a list of streams existing in the database.

Examples

Get a first stream

/api/streams?$limit=1&
$top=0

Prepared Response:

{
  "status": "Ok",
  "records": [
    {
      "id": 2,
      "name": "Default",
      "description": "Default stream when other not referenced",
      "created_at": "2024-12-18T16:41:20.387+03:00",
      "updated_at": "2024-12-18T16:41:20.387+03:00"
    }
  ]
}

Live Response:

Check out actual server response by click button next to URL

Updating stream

PUT /api/streams/{stream_id}

Body parameters:

// New stream parameters "new_streamname" : "Example of new stream name",// New stream name "new_description" : "Some new description, which you want to attach to stream"// New stream description }

Update existing stream with new values.

Examples

Updating stream

Request Body:

{
  "stream_id": 2,
  "new_streamname": "Example of new stream name",
  "new_description": "Example of new description"
}

Prepared Response:

{
  "status": "Ok",
  "records": "Stream updated successfully"
}

Delete stream

DELETE /api/streams/{stream_id}

Allows to delete stream with specified id.

Examples

Delete source with id 15

Prepared Response:

{
  "status": "Ok",
  "records": "1 stream with id: 15 was deleted"
}