Home	Free Reports and Queries   Fee Based Services   Database Description   Database Access

Table description for AIRMAN in subject area AIRMEN
AIRMAN
Primary key: KEY
Indexes

• KEY
• LAST_NAME_SUFFIX

Number of rows: 1,001,094
Comment
      Includes pilots, ground and flight instructors, flight engineers, navigators, dispatchers, mechanics, riggers, and control tower operators registered with the FAA including both domestic and foreign airman. Some of the columns of the source table have been normalized to the AIRMAN_RATING TABLE

COLUMN NAME	DATA TYPE	LENGTH	PRECISION	NULLABLE	COMMENT
KEY	varchar	8	0	NO
FIRST_MIDDLE_NAME	varchar	30	0	YES
LAST_NAME_SUFFIX	varchar	30	0	YES
STREET_1	varchar	33	0	YES
STREET_2	varchar	33	0	YES
CITY	varchar	17	0	YES
STATE	varchar	2	0	YES
ZIP_CODE	varchar	10	0	YES
COUNTRY_NAME	varchar	18	0	YES
REGION	varchar	18	0	YES
MEDICAL_CLASS	varchar	1	0	YES
MEDICAL_DATE	date	4	0	YES
MEDICAL_EXPIRE_DATE	date	4	0	YES
ADDED_TIMESTAMP	timestamp	8	0	NO
MODIFIED_TIMESTAMP	timestamp	8	0	YES

---

Legal

Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved

Contact Us