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.

N763United States Department Of Interior · Boise, IDBuilt 1986 · S/N U20606943N764Usda Forest Servic Fepp · Columbia, SCBuilt 1975 · S/N U20602672N764RBReo & Bpo LLC · Lewes, DEBuilt 1982 · S/N 21064674N764SAerotrans Management LLC · Mercer Island, WABuilt 1979 · S/N U20604957N767RFAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N P21000161N7685NFranklin Construction Inc · Chico, CAS/N 21063247N7691DScout Aviation LLC · Homer, AKBuilt 1968 · S/N U206-1015N769BSWells Donald T · Seattle, WABuilt 1968 · S/N U206-1251N76BLBravo Lima Corp · Lakewood, COBuilt 1973 · S/N 21059808N76DACessna 76da LLC · Warsaw, VABuilt 1977 · S/N U20604208N76EDFlying Hawks Ranch LLC · Bruning, NEBuilt 1968 · S/N P206-0487N770CFKopp Adrian D · Brookville, INBuilt 1978 · S/N U20604569N7711DCaldwell Joel A · Kenai, AKBuilt 1976 · S/N U206-03170N7711GTrans Meridian LLC · Fort Myers Beach, FLFirst renewal noticeS/N P21000072N77206Venture Alaska LLC · Homer, AKBuilt 1977 · S/N U20603771N7723MDdw Inc · Gardner, COBuilt 1968 · S/N T210-0357N7736KValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000420N773DWWalerius Dennis · Sylvania, OHBuilt 1976 · S/N U20603202N774CSWyo Ventures LLC · Buffalo, WYBuilt 1976 · S/N 21061359N774RDDemuth Roger C Trustee · Valley View, TXBuilt 1974 · S/N 21060229N77554U S Department Of The Interior · Boise, IDBuilt 1976 · S/N U20603408N776TMAero Performance LLC · Scooba, MSBuilt 1976 · S/N 21061480N7774BAdair Aviation LLC · Broken Arrow, OKBuilt 1981 · S/N U20606224N7776HAcevedo Adriel · San Antonio, TXBuilt 1976 · S/N 21061194N7777ALibby Stephen R Trustee · Anchorage, AKBuilt 1978 · S/N U20604391N7777SHood Company LLC · Nashville, TNBuilt 1972 · S/N 21059611N777BMJet Air Of South Florida Inc · Deerfield Beach, FLBuilt 1978 · S/N 21063156N777CFCp Aviation LLC · Pasco, WABuilt 1977 · S/N 21062059N777DLShamrock Kelly Energy Inc · Blanco, TXBuilt 1979 · S/N P21000373N777FWLewis Kent · Lake Oswego, ORBuilt 1974 · S/N 21060167N777FYQualitair LLC Trustee · ChelstadtBuilt 1979 · S/N P21000276N777HSJohnson Erik L · Long Beach, CABuilt 1975 · S/N 21060835N777NTN777nt LLC · Fort Mill, SCBuilt 1975 · S/N 21060972N777RKing Winn K · Gladewater, TXBuilt 1972 · S/N 21059551N777RRChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21061729N777SZMullen John J Jr Trustee · Henderson, NVBuilt 1970 · S/N 21059265N777WLAerospace Trust Mangement LLC Trustee · Wilmington, DEBuilt 1970 · S/N 21059376N778CWGarbati Thomas Jr · Waterford, CTBuilt 1981 · S/N U20606184N778VKPuerto Rico Management Services Inc · Coral Gables, FLS/N 21062895N7798NGebhard John M · Hartland, WIBuilt 1977 · S/N U20603718N77BVRegistered aircraftBuilt 1979 · S/N P21000221N77CKRaiz Coaching LLC · Fort Worth, TXBuilt 1976 · S/N 20700343N77CRVolatile Aero Ventures LLC · Boulder City, NVBuilt 1976 · S/N U20603458N77GSSouth Carolina Flyers LLC · Aiken, SCBuilt 1981 · S/N P21000613N77KRMarsh Aviation LLC · Old Lyme, CTBuilt 1981 · S/N P21000703N77RASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 21063846N77WSRegistered aircraftBuilt 1969 · S/N P206-0628N7806SAeroquest LLC · Plano, TXBuilt 1978 · S/N U20604168N780ALas Margaritas Aviation LLC · Qulin, MOBuilt 1978 · S/N U20604463N780ESFlying Pineapple LLC · Naples, FLS/N U20604272
Back to AD 2002-07-01