# PjaCon

Contact facility information for Parachute Jump Areas, including controlling frequencies and sector data

**Source:** NASR table `PJA_CON` · version `e25086c3e952` · effective 2026-04-16

> Ordered by PJA_ID and FAC_NAME, which together form the unique record key. References PJA_ID in PJA_BASE.

## Example query

```graphql
# Introspect the PjaCon type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    pjaId
    facId
    facName
  # }
}
```

Run at https://api.nav.sortie.co/graphql (GraphiQL available in-browser).

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `effDate` | `String` | The 28 Day NASR Subscription Effective Date in format YYYY/MM/DD |  |  |
| `pjaId` | `String` | PJA ID that uniquely identifies a Parachute Jump Area; references PJA_ID in PJA_BASE |  |  |
| `facId` | `String` | Contact Facility Identifier for the ATC or controlling facility associated with this PJA contact record |  |  |
| `facName` | `String` | Contact Facility Name for the ATC or controlling facility associated with this PJA contact record |  |  |
| `locId` | `String` | Related Location Identifier associated with the contact facility |  |  |
| `commercialFreq` | `Float` | Commercial (civil) frequency for contacting the facility regarding PJA operations | MHz |  |
| `commercialChartFlag` | `ContrFuelAvbl` | Indicates whether the commercial frequency is to be shown on a chart |  | `Y`=Yes, show commercial frequency on chart; `N`=No, do not show commercial frequency on chart |
| `milFreq` | `Float` | Military frequency for contacting the facility regarding PJA operations | MHz |  |
| `milChartFlag` | `ContrFuelAvbl` | Indicates whether the military frequency is to be shown on a chart |  | `Y`=Yes, show military frequency on chart; `N`=No, do not show military frequency on chart |
| `sector` | `String` | Sector description text identifying the ATC sector responsible for the PJA |  |  |
| `contactFreqAltitude` | `String` | Altitude description text indicating the altitude at which a specific contact frequency applies |  |  |

## Column provenance

Every field maps 1:1 to a column in the `PJA_CON` table of `nasr.db`. Original FAA column names:

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `pjaId` | `PJA_ID` |
| `facId` | `FAC_ID` |
| `facName` | `FAC_NAME` |
| `locId` | `LOC_ID` |
| `commercialFreq` | `COMMERCIAL_FREQ` |
| `commercialChartFlag` | `COMMERCIAL_CHART_FLAG` |
| `milFreq` | `MIL_FREQ` |
| `milChartFlag` | `MIL_CHART_FLAG` |
| `sector` | `SECTOR` |
| `contactFreqAltitude` | `CONTACT_FREQ_ALTITUDE` |