AIRMEN TABLE
NAME	TYPE	LENGTH	DESCRIPTION
UNIQUEID	C	8	ID NUMBER FOR EACH PILOT
RECTYPE	C	2	RECORD TYPE; '00' = Airmen basic record
RESTNAME	C	30	FIRST & MIDDLE NAME
LAST	C	30	LAST NAME & SUFFIX
STREET1	C	33	STREET
STREET2	C	33	STREET 2
CITY	C	17	CITY
STATE	C	2	STATE
ZIP	C	10	ZIP
COUNTRY 	C	18	COUNTRY IF NOT U.S. ADDRESS
REGION	C	2
MEDCLASS 	C	1	1=FIRST 2= SECOND 3=THIRD
MEDDTCH	C	6	MMYYYY (PILOT'S ONLY),;
NICARMEDMONTH	C	2	MEDICAL DATE MONTH (NICAR CONVERTED)
NICARMEDYEAR	C	4	MEDICAL DATE YEAR (NICAR CONVERTED)


AIR_CERT TABLE
NAME	TYPE	LENGTH	DESCRIPTION
UNIQUEID	C	8	ID NUMBER FOR EACH PILOT
RECTYPE	C	2	RECORD TYPE (will be 01-15 in the air-cert table)
CERTYPE	C	1	CERTIFICATE TYPE (see HELP.PDF pg 6)
PILOT	C	2	P = PILOT; NP = NONPILOT
CERTLEV	C	1	CERTIFICATE LEVEL (see HELP.PDF pg 6)
CEREXPCH	C	8	CERTIFICATE EXPIRE DATE
NICARCERTEXP	D		CERTIFICATE EXPIRE DATE (NICAR CONVERTED)
RATE1	C	9	RATING 1
RATE2	C	9	RATING 2
RATE3	C	9	RATING 3
RATE4	C	9	RATING 4
RATE5	C	9	RATING 5
RATE6	C	9	RATING 6
RATE7	C	9	RATING 7
RATE8	C	9	RATING 8
RATE9	C	9	RATING 9
RATE10	C	9	RATING 10
RATE11	C	9	RATING 11
TYPERATE1 thru 90	C	10