# AptCon

Airport contact information including managers, owners, and other facility contacts

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

> Ordered by SITE_NO, SITE_TYPE_CODE, TITLE

## Example query

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

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 |  |  |
| `siteNo` | `String` | Landing facility site number; references SITE_NO in APT_BASE |  |  |
| `siteTypeCode` | `SiteTypeCode` | Landing facility type code |  | `A`=AIRPORT; `B`=BALLOONPORT; `C`=SEAPLANE BASE; `G`=GLIDERPORT; `H`=HELIPORT; `U`=ULTRALIGHT |
| `stateCode` | `String` | Associated state post office code |  |  |
| `arptId` | `String` | Location identifier; references ARPT_ID in APT_BASE |  |  |
| `city` | `String` | Airport associated city name |  |  |
| `countryCode` | `String` | Country post office code where airport is located |  |  |
| `title` | `Title` | Title of contact such as MANAGER, OWNER, ASST-MGR, etc. |  | `ADDTL CTC`, `AFLD OPS`, `AOPS MGR`, … (31 values) |
| `name` | `String` | Facility contact name for the title |  |  |
| `address1` | `String` | Contact address line 1 |  |  |
| `address2` | `String` | Contact address line 2 |  |  |
| `titleCity` | `String` | Contact city |  |  |
| `state` | `String` | Contact state code |  |  |
| `zipCode` | `String` | Contact zip code |  |  |
| `zipPlusFour` | `String` | Contact zip code plus four digit extension |  |  |
| `phoneNo` | `String` | Contact phone number |  |  |

## Enum values

### `title` (`Title`)

| Code | Description |
|---|---|
| `ADDTL CTC` | Additional Contact |
| `AFLD OPS` | Airfield Operations |
| `AOPS MGR` | Airport Operations Manager |
| `ARPT BOARD` | Airport Board |
| `ARPT CTR` | Airport Controller |
| `ARPT OPNS` | Airport Operations |
| `ARPT SPVR` | Airport Supervisor |
| `ARPT SUPVR` | Airport Supervisor (alternate spelling) |
| `ARPTS CTR` | Airports Controller |
| `ARPTS DIR` | Airports Director |
| `ASST_MGR` | Assistant Manager |
| `CO-MANAGER` | Co-Manager |
| `DIR OF AVN` | Director of Aviation |
| `DIR OF OPS` | Director of Operations |
| `EMS OFFICE` | EMS Office |
| `HELI CTR` | Helicopter Controller |
| `LEASEE` | Leasee |
| `MANAGER` | Manager |
| `ON A/P MGR` | On-Airport Manager |
| `ON SITE` | On Site |
| `OPERATOR` | Operator |
| `OPNS MGR` | Operations Manager |
| `OPRNS MGR` | Operations Manager (alternate spelling) |
| `OPS DIR` | Operations Director |
| `OPS MGR` | Operations Manager |
| `OTHER` | Other |
| `OWNER` | Owner |
| `PRESIDENT` | President |
| `SAFETY OFC` | Safety Officer |
| `SITE SUPT` | Site Superintendent |
| `SR PGM MGR` | Senior Program Manager |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `siteNo` | `SITE_NO` |
| `siteTypeCode` | `SITE_TYPE_CODE` |
| `stateCode` | `STATE_CODE` |
| `arptId` | `ARPT_ID` |
| `city` | `CITY` |
| `countryCode` | `COUNTRY_CODE` |
| `title` | `TITLE` |
| `name` | `NAME` |
| `address1` | `ADDRESS1` |
| `address2` | `ADDRESS2` |
| `titleCity` | `TITLE_CITY` |
| `state` | `STATE` |
| `zipCode` | `ZIP_CODE` |
| `zipPlusFour` | `ZIP_PLUS_FOUR` |
| `phoneNo` | `PHONE_NO` |