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.

N2185ULethin Savanna C · Anchorage, AKBuilt 1974 · S/N U20602354N218CCSotally Tober LLC · Wilmington, DEBuilt 1979 · S/N 21063297N219BTDacy Justin A · Boerne, TXBuilt 1976 · S/N 21061568N21BESpecialized Helicopter Training LLC · Middleton, IDBuilt 1979 · S/N P21000456N21BMGandee James T · Bullhead City, AZS/N 21061941N21CTFerreira Douglas B Trustee · Chico, CABuilt 1978 · S/N P21000021N21KRNorcon Enterprises Inc · Amarillo, TXFirst renewal noticeBuilt 1979 · S/N P21000285N21LTMission Flight · El Monte, CABuilt 1979 · S/N P21000216N21RGMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700066N2206RKahonees Travel Services LLC · Pleasanton, TXBuilt 1968 · S/N T210-0356N2209RPilotsgirl LLC · Goldsboro, NCBuilt 1968 · S/N T210-0359N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000593N220TJJaco Oil Co · Bakersfield, CAS/N 21063139N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194N2210RCarroll James K · Paso Robles, CAS/N T210-0360N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711N2216FSummit North LLC · Anchorage, AKBuilt 1982 · S/N U20606504N2216URegistered aircraftBuilt 1974 · S/N U20602355N2217RParke Mike D · Twin Falls, IDBuilt 1968 · S/N T210-0367N221AARegistered aircraftBuilt 1977 · S/N 21062293N221JEElgee John O · Anchorage, AKBuilt 1973 · S/N U20601990N22202Gifford Gregory L · Naples, FLBuilt 1972 · S/N 21059717N2220SSb Meridian LLC · Heber, CABuilt 1976 · S/N 21061165N22232Engeseth James Jr · Parker, COBuilt 1972 · S/N 21059730N2223SDavis Aaron B · Lascassas, TNBuilt 1976 · S/N 21061168N2226RChampion Crane Service Inc · Des Moines, IABuilt 1968 · S/N T210-0376N2226SE S P Aviation LLC · Wilmington, DEBuilt 1976 · S/N 21061171N2228SHannaford Edward M · Roseville, MIBuilt 1976 · S/N 21061173N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174N222ATSierra 1 Tech Inc · Blue Jay, CABuilt 1968 · S/N 21059098N222ETValiair Lc Trustee · Casper, WYBuilt 1981 · S/N P21000626N222LSLj Bickford Companies LLC · Wasilla, AKBuilt 1972 · S/N U206-01751N222MHJones Jimmy N · Bremond, TXBuilt 1972 · S/N U20601931N222SGPacific Aviation Aircraft Management Inc · Fresno, CAS/N 210-64410N222SJTriple Deuce LLC · Harrisonville, MOBuilt 1972 · S/N 21059732N2233SRichardson Robert O · Spring Grove, ILBuilt 1976 · S/N 21061178N2234RJones Lennis William III · Rule, TXBuilt 1968 · S/N T210-0384N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180N2236RSouthern Skies Aviation Inc · Cedar City, UTS/N T210-0386N22396Jordan Lennon D · Bartow, FLBuilt 1972 · S/N 21059741N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999N2241RHappy Landings Aero LLC · Wilmington, DEBuilt 1968 · S/N T210-0391N2241SEdmondson James K · Lemoore, CABuilt 1976 · S/N 21061186N22459Hatch Leasing Company LLC · Flagstaff, AZBuilt 1972 · S/N 21059754N2246RMontgomery Brian · Houston, TXBuilt 1968 · S/N T210-0396N2247SCarnes Andrew P · Wichita Falls, TXBuilt 1976 · S/N 21061191N2248RVan Heemst Jeffrey A · West Palm Beach, FLFirst renewal noticeBuilt 1968 · S/N T210-0398N2249SDlw Flight Services LLC · Waterloo, ILBuilt 1976 · S/N 21061193N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812N224MHFeely Daniel R · Pasadena, CABuilt 1978 · S/N P21000089
Back to AD 2002-07-01