AC_ACI_AIRCRAFT_INFO

This is an aircraft master table that stores master details of aircraft. It provides structured reference data about aircraft, parts, and components used for linking transactions with accurate technical information.

Process: MAINTPLANNING · Component: BASAircraft · Table type: Master Table Category: Holds master details of aircraft, parts, and components for accurate technical and operational reference in transactions.

This table is the canonical store for the Aircraft entity.

Primary key

ACI_AIRCRAFT_REG_NO, ACI_OUINSTANCE

Columns (125)

#	Column	Type	Description
1	`ACI_OUINSTANCE` 🔑	varchar	Organization Unit instance for the aircraft
2	`ACI_AIRCRAFT_REG_NO` 🔑	varchar	Aircraft registration number
3	`ACI_MDL_MODEL`	#N/A	Model of the aircraft
4	`ACI_MDL_OUINSTANCE`	varchar	Organization Unit instance of the aircraft model
5	`ACI_SERIAL_NO`	varchar	Aircraft serial number
6	`ACI_TAB_NO`	varchar	Tab number of the aircraft
7	`ACI_TAIL_NO`	varchar	Tail number of the aircraft
8	`ACI_CONFIGURATION_ID`	varchar	Configuration ID of the aircraft
9	`ACI_REVISION_NO`	varchar	Revision number of the aircraft record
10	`ACI_REG_CERTIFICATE_NO`	datetime	Registration certificate number
11	`ACI_ISSUE_DATE`	Varchar	Issue date of the registration certificate
12	`ACI_REGULATORY_AUTH`	varchar	Regulatory authority issuing the certificate
13	`ACI_COUNTRY`	varchar	Country of registration
14	`ACI_OWNERSHIP`	varchar	Ownership type of the aircraft
15	`ACI_LEASE_TYPE`	#N/A	Lease type of the aircraft
16	`ACI_PLANNING_BASE`	#N/A	Planning base for aircraft operations
17	`ACI_MAINTENANCE_BASE`	varchar	Maintenance base for the aircraft
18	`ACI_PLANNER_CODE`	datetime	Planner code responsible for the aircraft
19	`ACI_INDUCTION_DATE`	datetime	Induction date of the aircraft
20	`ACI_OPERATIONAL_DATE`	Varchar	Operational start date of the aircraft
21	`ACI_USAGE_TYPE`	Varchar	Usage type of the aircraft
22	`ACI_AIRCRAFT_TYPE`	varchar	Aircraft type
23	`ACI_AIRCRAFT_CONDITION`	datetime	Condition of the aircraft
24	`ACI_FROM_DATE`	varchar	From date of record or validity
25	`ACI_LEAD_PARAMETER`	varchar	Lead parameter associated with aircraft operations
26	`ACI_PO_NUMBER`	datetime	Purchase order number
27	`ACI_PO_DATE`	decimal	Purchase order date
28	`ACI_ACQUISITION_VALUE`	decimal	Acquisition value of the aircraft
29	`ACI_BOOK_VALUE`	Varchar	Book value of the aircraft
30	`ACI_USER_DEF1`	Varchar	User-defined field 1
31	`ACI_USER_DEF2`	Varchar	User-defined field 2
32	`ACI_USER_DEF3`	Varchar	User-defined field 3
33	`ACI_AIRCRAFT_DET1`	Varchar	Aircraft detail field 1
34	`ACI_AIRCRAFT_DET2`	Varchar	Aircraft detail field 2
35	`ACI_AIRCRAFT_DET3`	varchar	Aircraft detail field 3
36	`ACI_STATUS`	varchar	Status of the aircraft record
37	`ACI_NOTES`	varchar	Notes related to the aircraft
38	`ACI_COMMENTS`	varchar	Comments on the aircraft record
39	`ACI_CREATED_BY`	datetime	Created by user
40	`ACI_CREATIONDATE`	varchar	Creation date of the record
41	`ACI_MODIFIED_BY`	datetime	Modified by user
42	`ACI_MODIFIEDDATE`	#N/A	Modification date of the record
43	`ACI_TIMESTAMP`	varchar	Timestamp of the record
44	`ACI_AC_REG_PREFIX`	varchar	Aircraft registration prefix
45	`ACI_AC_REG_SUFFIX`	varchar	Aircraft registration suffix
46	`ACI_MSN_PREFIX`	varchar	Manufacturer serial number prefix
47	`ACI_MSN_SUFFIX`	varchar	Manufacturer serial number suffix
48	`ACI_TAB_PREFIX`	varchar	Tab prefix
49	`ACI_TAB_SUFFIX`	varchar	Tab suffix
50	`ACI_TAIL_PREFIX`	varchar	Tail prefix
51	`ACI_TAIL_SUFFIX`	datetime	Tail suffix
52	`ACI_MANUFACTURE_DATE`	varchar	Aircraft manufacture date
53	`ACI_INV_PART_NO`	varchar	Inventory part number
54	`ACI_CUST_EFF_CODE`	varchar	Customer effectivity code
55	`ACI_ENGINE_SET_NO`	decimal	Engine set number
56	`ACI_POLOCATION_OU`	varchar	Purchase order location Organization Unit
57	`ACI_OWNAGENCY_NO`	decimal	Owning agency number
58	`ACI_OWNAGENCY_OU`	varchar	Owning agency Organization Unit
59	`ACI_ENGAGEMENT_TYPE`	varchar	Engagement type of the aircraft
60	`ACI_PREV_AC_REG_NO`	varchar	Previous aircraft registration number
61	`aci_base_ac_reg_no`	varchar	Base aircraft registration number
62	`ACOI_BASE_AC_REG_NO`	varchar	Aircraft base registration reference
63	`ACI_ASSET_NO`	int	Asset number of the aircraft
64	`ACI_ASSET_TAG`	varchar	Asset tag
65	`ACI_ASSET_MODIFIED_BY`	varchar	Modified by user for asset
66	`ACI_ASSET_MODIFIED_DATE`	varchar	Asset modification date
67	`ACI_PREF_STATUS`	varchar	Preferred status of the aircraft
68	`ACI_RETMNT_DATETIME`	datetime	Return maintenance datetime
69	`ACI_AOG_FROMDATE`	varchar	AOG (Aircraft on Ground) start date
70	`ACI_ACREG_STATUS`	datetime	Aircraft registration status
71	`ACI_STATUS_FROMDATE`	Datetime	Status effective from date
72	`aci_operational_time`	varchar	Operational time of the aircraft
73	`ACI_FHLOGMODE`	varchar	Flight hour log mode
74	`ACI_QRNTN`	varchar	Quarantine status
75	`ACI_holdingfb`	datetime	Holding flight hours
76	`ACI_holdingfb_date`	datetime	Holding flight hours date
77	`ACI_operatedfor_date`	varchar	Date operated for a specific purpose
78	`ACI_operatedfor`	datetime	Operated for specific purpose
79	`ACI_analysiscode_date`	varchar	Analysis code date
80	`ACI_analysiscode`	datetime	Analysis code
81	`ACI_subanalysis_date`	varchar	Sub-analysis date
82	`ACI_subanalysis`	numeric	Sub-analysis
83	`ACI_REM_FH`	numeric	Remaining flight hours
84	`ACI_REM_FC`	numeric	Remaining flight cycles
85	`ACI_REM_DAYS`	varchar	Remaining days
86	`ACI_NotesID`	varchar	Notes ID
87	`aci_maint_operator_code`	varchar	Maintenance operator code
88	`ACI_TRG_PARAM`	numeric	Target parameter
89	`ACI_TRG_VALUE`	datetime	Target value
90	`aci_calendar_sch_date`	varchar	Scheduled calendar date
91	`ACI_MODE_OF_USAGE`	varchar	Mode of usage
92	`ACI_TRANSFER_STATUS`	varchar	Transfer status
93	`ACI_endcust_no`	Datetime	End customer number
94	`ACI_USER_DATE1`	Datetime	User-defined date 1
95	`ACI_USER_DATE2`	Char	User-defined date 2
96	`aci_acwing_type`	varchar	Aircraft wing type
97	`aci_drvd_ownagency_no`	varchar	Derived owning agency number
98	`ACI_ETOPS`	int	ETOPS applicability
99	`aci_defcdl_cnt`	int	Deferred CDL count
100	`aci_defmel_cnt`	int	Deferred MEL count
101	`aci_defoth_cnt`	varchar	Other deferred items count
102	`aci_remarks`	varchar	Remarks
103	`aci_rvsm_flg`	varchar	RVSM flag
104	`aci_due_tskdesc`	varchar	Due task description
105	`aci_duedp_desc`	numeric	Due document description
106	`aci_duetsk_rfh`	numeric	Due task remaining flight hours
107	`aci_duetsk_rdays`	varchar	Due task remaining days
108	`aci_duetsk_tprm`	numeric	Due task remaining parameter
109	`aci_duetsk_tval`	datetime	Due task target value
110	`aci_duetsk_schdt`	varchar	Due task scheduled date
111	`aci_duetsk_no`	numeric	Due task number
112	`aci_duedp_rfh`	numeric	Due document remaining flight hours
113	`aci_duedp_rfc`	numeric	Due document remaining flight cycles
114	`aci_duedp_rdays`	varchar	Due document remaining days
115	`aci_duedp_tprm`	numeric	Due document remaining parameter
116	`aci_duedp_tval`	datetime	Due document target value
117	`aci_duedp_schdt`	varchar	Due document scheduled date
118	`aci_duedp_no`	varchar	Due document number
119	`aci_act_last`	varchar	Last actual task completed
120	`aci_act_lastprog`	numeric	Last programmed task completed
121	`aci_duetsk_rfc`	Bigint	Due task remaining flight cycles
122	`aci_act_trackid`	int	Activity tracking ID
123	`aci_opensos_cnt`	varchar	Open SOS count
124	`aci_dueeo`	varchar	Due Engineering Order
125	`aci_dueeodesc`	#N/A	Due EO description

Relationships (3)

AMEPackage (FLOG_TLGMN_TECH_LOG_HDR) → FOR_AIRCRAFT (this table is target)
- Join: FLOG_TLGMN_TECH_LOG_HDR.TLGMN_AIRCRAFT_REG_NO = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
- AME Package is for a specific aircraft
Discrepancy (DP_DISCP_DISCREPANCY_DTL) → FOR_AIRCRAFT (this table is target)
- Join: DP_DISCP_DISCREPANCY_DTL.DISCP_AIRCRAFT_NO = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
- Discrepancy reported for aircraft
ShopWorkOrder (swo_swoh_shop_wo_hdr) → FOR_AIRCRAFT (this table is target)
- Join: swo_swoh_shop_wo_hdr.swoh_rem_aircraft_reg_no = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
- SWO is for aircraft

Sample rows (from live DB)

`ACI_OUINSTANCE`	`ACI_AIRCRAFT_REG_NO`	`ACI_MDL_MODEL`	`ACI_MDL_OUINSTANCE`	`ACI_SERIAL_NO`	`ACI_TAB_NO`
2.0	1132	B767-200	2.0	1132	1132

Showing 1 of 1,025 rows.

AC_ACI_AIRCRAFT_INFO

Primary key

Columns (125)

Relationships (3)

Sample rows (from live DB)

See also