Aircraft

A registered aircraft in the operator's fleet. In Ramco Aviation, every maintenance, discrepancy, and shop work order traces back to a specific aircraft reg. The aircraft reg is the hero key of the whole data model.

Canonical table: AC_ACI_AIRCRAFT_INFO · Key column: ACI_AIRCRAFT_REG_NO

Example record

• ACI_OUINSTANCE: 2.0
• ACI_AIRCRAFT_REG_NO: 0707
• ACI_MDL_MODEL: A310
• ACI_MDL_OUINSTANCE: 2.0
• ACI_SERIAL_NO: 0707
• ACI_TAB_NO: 0707
• ACI_TAIL_NO: 0707
• ACI_CONFIGURATION_ID: 301

Incoming relationships (3)

• AMEPackage → FOR_AIRCRAFT
  • via FLOG_TLGMN_TECH_LOG_HDR.TLGMN_AIRCRAFT_REG_NO = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
• Discrepancy → FOR_AIRCRAFT
  • via DP_DISCP_DISCREPANCY_DTL.DISCP_AIRCRAFT_NO = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
• ShopWorkOrder → FOR_AIRCRAFT
  • via swo_swoh_shop_wo_hdr.swoh_rem_aircraft_reg_no = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO

See also

• AC_ACI_AIRCRAFT_INFO
• AMEPackage
• Discrepancy
• ShopWorkOrder