AD 2002-07-01

Registered aircraft · 3,466

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N781CBMiller Charles Litle Trustee · Fresno, CABuilt 1977 · S/N 21062235N781DBCooper Roy · Lamesa, TXS/N P21000293N784DJAlta Volare LLC · Wilmington, DEBuilt 1968 · S/N 21059104N7874J2f Trade LLC · Collinsville, TXS/N 21060597N787AECoordinate Productions LLC · Waterloo, IABuilt 1972 · S/N 21059799N78KWVolz James R · Laredo, TXBuilt 1974 · S/N U20602647N78MKNelleh LLC · Liberal, KSBuilt 1978 · S/N 21062587N78MWSymple Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603205N78WVOrange Motion Trading LLC · Las Vegas, NVBuilt 1977 · S/N 21062214N7917NWrangell Mountain Air Inc · Palmer, AKBuilt 1977 · S/N U20603720N799ACYeates Jeffrey B · Battle Ground, WAS/N U20605827N799KTAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1976 · S/N U20603580N79CHPala Angel E · Taos, NMBuilt 1978 · S/N 21062615N79DVDiscovery Associates Inc · Midland, TXBuilt 1979 · S/N P21000233N79RCBach II LLC · Lafayette, LABuilt 1982 · S/N 21064697N79VK3g'S Aviation LLC · St Simons Island, GABuilt 1979 · S/N 21063322N7ALFlying Fortress Of Swfl LLC · Fort Myers, FLS/N 21063261N7JZR & R Vehicles LLC · Davie, FLBuilt 1977 · S/N 21062116N7LTRobertson Cameron Lee · Las Vegas, NVS/N 21060936N7LVBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000506N7MFBarger Christopher H Trustee · Mesa, AZBuilt 1980 · S/N P21000583N7RDSchipper Properties Inc · San Jose, CABuilt 1967 · S/N 21058847N7RRTavan Richard M · Saratoga, CAS/N 21063468N7UBWhite James V · Prescott, AZBuilt 1976 · S/N 21061593N800DFFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 20700621N800FUKing Air 3 Au LLC · Ozark, MOBuilt 1978 · S/N 21062792N800LGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000669N800NLNewhalen Lodge Inc · Anchorage, AKBuilt 1979 · S/N U20604860N802MSMarotta Scientific Controls Inc · Montville, NJBuilt 1983 · S/N 21064780N802UMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700067N8052MEcho Romeo LLC · Stamford, CTBuilt 1977 · S/N 21062031N805AJMoyer Aviation Inc · Ulysses, KSS/N 20601769N8063EHale Mitchell D · Chugiak, AKS/N U2060926N806HUAstra Engineering LLC · Twin Falls, IDBuilt 1979 · S/N U20605215N807WCEt Fly Home LLC · Auburn, ALBuilt 1977 · S/N 21061775N808FSBradley Supply Company LLC · Mesquite, NVS/N 21061586N80CRRdp Construction LLC · Sitka, AKBuilt 1980 · S/N U20605548N80GWSnyder Michael P · Las Vegas, NVBuilt 1974 · S/N 21060425N80MTMeloche Michael S Trustee · Hamilton, MTBuilt 1979 · S/N U20605467N80SGFerland Henry L III · Vidalia, GABuilt 1980 · S/N 21064014N8116GJrb12 Inc · Shorewood, ILBuilt 1971 · S/N 21059416N811ECChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1975 · S/N 21060702N8121GTwo One Golf Ltd · Waterloo, IABuilt 1971 · S/N 21059421N8123GBlattmachr Matthew · Anchorage, AKS/N U20603770N8123Q8123q LLC · Olympia, WABuilt 1975 · S/N U20603093N8127L2f Trade LLC · Gainesville, TXS/N 21060614N8128LSayco Aviation LLC · Fayetteville, GABuilt 1974 · S/N 21060615N8129GJohnson Richard A Trustee · Chandler, AZBuilt 1971 · S/N 21059429N812WJjc Enterprises Inc · Dillingham, AKBuilt 1975 · S/N U20602770N8130LPerfect 10 Roofing · Billings, MTS/N 21060617
Back to AD 2002-07-01