# AptRwy

Runway data including physical dimensions, surface type, pavement classification, and weight-bearing capacity

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

> Ordered by SITE_NO, SITE_TYPE_CODE, RWY_ID

## Example query

```graphql
# Introspect the AptRwy 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 |  |  |
| `rwyId` | `String` | Runway identification |  |  |
| `rwyLen` | `Int` | Physical runway length to the nearest foot | feet |  |
| `rwyWidth` | `Int` | Physical runway width to the nearest foot | feet |  |
| `surfaceTypeCode` | `SurfaceTypeCode` | Runway surface type; may be a combination of two types when runway is composed of distinct sections |  | `CONC`, `ASPH`, `SNOW`, … (51 values) |
| `cond` | `Cond` | Runway surface condition |  | `EXCELLENT`=Excellent; `GOOD`=Good; `FAIR`=Fair; `POOR`=Poor; `FAILED`=Failed |
| `treatmentCode` | `TreatmentCode` | Runway surface treatment |  | `GRVD`=Saw-cut or plastic grooved; `PFC`=Porous friction course; `AFSC`=Aggregate friction seal coat; `RFSC`=Rubberized friction seal coat; `WC`=Wire comb or wire tine; `NONE`=No special surface treatment |
| `pcn` | `Int` | Pavement classification number (PCN); see FAA Advisory Circular 150/5335-5 for code definitions and PCN determination formula |  |  |
| `pavementTypeCode` | `PavementTypeCode` | Pavement type |  | `R`=Rigid; `F`=Flexible |
| `subgradeStrengthCode` | `SubgradeStrengthCode` | Subgrade strength code (letters A-F) |  | `A`=Subgrade strength A (highest); `B`=Subgrade strength B; `C`=Subgrade strength C; `D`=Subgrade strength D (lowest) |
| `tirePresCode` | `TirePresCode` | Tire pressure code (letters W-Z) |  | `W`=Tire pressure code W; `X`=Tire pressure code X; `Y`=Tire pressure code Y; `Z`=Tire pressure code Z |
| `dtrmMethodCode` | `DtrmMethodCode` | PCN determination method |  | `T`=Technical; `U`=Using aircraft |
| `rwyLgtCode` | `RwyLgtCode` | Runway lights edge intensity |  | `HIGH`, `MED`, `LOW`, … (7 values) |
| `rwyLenSource` | `ArptElevSource` | Runway length source |  | `3RD PARTY SURVEY`, `ADAM`, `ADO`, … (18 values) |
| `lengthSourceDate` | `String` | Runway length source date (YYYY/MM/DD) |  |  |
| `grossWtSw` | `Float` | Runway weight-bearing capacity for single wheel type landing gear | thousands of pounds |  |
| `grossWtDw` | `Float` | Runway weight-bearing capacity for dual wheel type landing gear | thousands of pounds |  |
| `grossWtDtw` | `Float` | Runway weight-bearing capacity for two dual wheels in tandem type landing gear | thousands of pounds |  |
| `grossWtDdtw` | `Float` | Runway weight-bearing capacity for two dual wheels in tandem/two dual wheels in double tandem body gear type landing gear | thousands of pounds |  |

## Enum values

### `surfaceTypeCode` (`SurfaceTypeCode`)

| Code | Description |
|---|---|
| `CONC` | Portland cement concrete |
| `ASPH` | Asphalt or bituminous concrete |
| `SNOW` | Snow |
| `ICE` | Ice |
| `MATS` | Pierced steel planking (PSP); landing mats; membranes |
| `TREATED` | Oiled; soil cement or lime stabilized |
| `GRAVEL` | Gravel; cinders; crushed rock; coral or shells; slag |
| `TURF` | Grass; sod |
| `DIRT` | Natural soil |
| `PEM` | Partially concrete asphalt or bitumen-bound macadam |
| `ROOF-TOP` | Material not specified (rooftop) |
| `WATER` | Water |
| `ALUMINUM` | Aluminum |
| `BRICK` | Brick |
| `CALICHE` | Caliche |
| `CORAL` | Coral |
| `DECK` | Deck |
| `GRASS` | Grass |
| `METAL` | Metal |
| `SAND` | Sand |
| `SOD` | Sod |
| `STEEL` | Steel |
| `TRTD` | Treated |
| `WOOD` | Wood |
| `ASPH-CONC` | Asphalt and concrete combination |
| `ASPH-DIRT` | Asphalt and dirt combination |
| `ASPH-GRVL` | Asphalt and gravel combination |
| `ASPH-TRTD` | Asphalt and treated combination |
| `ASPH-TURF` | Asphalt and turf combination |
| `CONC-DIRT` | Concrete and dirt combination |
| `CONC-GRVL` | Concrete and gravel combination |
| `CONC-TRTD` | Concrete and treated combination |
| `CONC-TURF` | Concrete and turf combination |
| `DIRT-GRVL` | Dirt and gravel combination |
| `DIRT-TRTD` | Dirt and treated combination |
| `DIRT-TURF` | Dirt and turf combination |
| `GRVL-DIRT` | Gravel and dirt combination |
| `GRVL-TRTD` | Gravel and treated combination |
| `GRVL-TURF` | Gravel and turf combination |
| `TURF-DIRT` | Turf and dirt combination |
| `TURF-GRVL` | Turf and gravel combination |
| `TURF-SAND` | Turf and sand combination |
| `STEEL-CONC` | Steel and concrete combination |
| `PFC` | Porous friction course |
| `PSP` | Pierced steel planking |
| `OIL&CHIP-T` | Oil and chip treated |
| `OR` | Other |
| `ROOFTOP` | Rooftop |
| `ALUM` | ALUM |
| `GRVL` | GRVL |
| `TRTD-DIRT` | TRTD-DIRT |

### `rwyLgtCode` (`RwyLgtCode`)

| Code | Description |
|---|---|
| `HIGH` | High intensity |
| `MED` | Medium intensity |
| `LOW` | Low intensity |
| `FLD` | Flood lighting |
| `NSTD` | Non-standard lighting system |
| `PERI` | Perimeter lighting |
| `STRB` | Strobe lighting |

### `rwyLenSource` (`ArptElevSource`)

| Code | Description |
|---|---|
| `3RD PARTY SURVEY` | Third party survey |
| `ADAM` | ADAM |
| `ADO` | FAA District Office |
| `AIP` | Aeronautical Information Publication |
| `ARPTS CONTRACTOR` | Airports contractor |
| `AVN` | Aviation |
| `DOD (NGA)` | Department of Defense National Geospatial-Intelligence Agency |
| `FAA` | Federal Aviation Administration |
| `FAA OE/AAA` | FAA Obstruction Evaluation/Airport Airspace Analysis |
| `FAA-EST` | FAA Estimated |
| `FAA-EST IMAGERY` | FAA Estimated from Imagery |
| `MILITARY` | Military |
| `NACO` | National Aeronautical Charting Office |
| `NGS` | National Geodetic Survey |
| `NGS-CALCULATED` | NGS Calculated |
| `OWNER` | Airport Owner |
| `REGION` | FAA Region |
| `STATE` | State |

## Relationships

| Field | Returns | Joined on |
|---|---|---|
| `aptRwyEnd` | [`[AptRwyEnd]`](./AptRwyEnd.md) | `SITE_NO, RWY_ID` |

## Column provenance

Every field maps 1:1 to a column in the `APT_RWY` 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` |
| `rwyId` | `RWY_ID` |
| `rwyLen` | `RWY_LEN` |
| `rwyWidth` | `RWY_WIDTH` |
| `surfaceTypeCode` | `SURFACE_TYPE_CODE` |
| `cond` | `COND` |
| `treatmentCode` | `TREATMENT_CODE` |
| `pcn` | `PCN` |
| `pavementTypeCode` | `PAVEMENT_TYPE_CODE` |
| `subgradeStrengthCode` | `SUBGRADE_STRENGTH_CODE` |
| `tirePresCode` | `TIRE_PRES_CODE` |
| `dtrmMethodCode` | `DTRM_METHOD_CODE` |
| `rwyLgtCode` | `RWY_LGT_CODE` |
| `rwyLenSource` | `RWY_LEN_SOURCE` |
| `lengthSourceDate` | `LENGTH_SOURCE_DATE` |
| `grossWtSw` | `GROSS_WT_SW` |
| `grossWtDw` | `GROSS_WT_DW` |
| `grossWtDtw` | `GROSS_WT_DTW` |
| `grossWtDdtw` | `GROSS_WT_DDTW` |