OpenAirDocs.org
AD 76-08-02 R2

Registered aircraft · 2,553

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:76-08-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2')
  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.

N8166QE S P Aviation LLC · Wilmington, DEBuilt 1972 · S/N 310Q0633N8167MFrick Richard W · Sidell, ILBuilt 1964 · S/N 310I0167N8168MWilliams Charles S · Kingwood, TXBuilt 1964 · S/N 310I0168N816GHSteim Joseph M · Shirley, MABuilt 1978 · S/N 310R1507N816LHL Howard Construction Inc · Abernathy, TXS/N 421B0565N8175QMillenium Enterprises LLC · Naples, FLS/N 340-0522N8177MSouthern Sky Enterprises LLC · Lafayette, LABuilt 1964 · S/N 310I0177N8178MAcevedo Xochil · San Antonio, TXS/N 310I0178N8179QCruce Aircraft Services LLC · Clewiston, FLBuilt 1972 · S/N 310Q0635N817GCMountain View Aeromotive Inc · Del Norte, COBuilt 1975 · S/N 310R0264N817JPOdom Johnny C · Fredericksburg, TXBuilt 1976 · S/N 414-0850N8184MAndrey Granin · Wantagh, NYBuilt 1964 · S/N 310I0184N8184QJohn Richard A · Southwest Ranches, FLBuilt 1972 · S/N 310Q0636N8188QI Will Rise LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0638N8191MWalters Larry C · Wasilla, AKBuilt 1964 · S/N 310I0191N8195MPeed Robert M · Gilbert, AZBuilt 1964 · S/N 310I0195N8195QD&M Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 414-0095N81ADMr Dent Inc · Manheim, PAS/N 401A0023N81NNNona Tech LLC · Orlando, FLBuilt 1964 · S/N 320C0025N81RTN81rt LLC · Middlebury, CTBuilt 1973 · S/N 310Q0742N81WAAdmiral Aviation Inc · New Castle, DEBuilt 1976 · S/N 310R0693N821BTN821bt Aviation LLC · Dover, DEBuilt 1978 · S/N 310R1298N8221QSouthwest Aircraft LLC · Fairacres, NMBuilt 1971 · S/N 414-0151N8223QBas Part Sales LLC · Greeley, COS/N 414-0153N8229QSeppala Wayne H Trustee · El Cajon, CABuilt 1971 · S/N 414-0159N822AMBmg Aviation Leasing LLC · Bloomington, INBuilt 1975 · S/N 310R0161N8237QAircon LLC · New Franklin, OHBuilt 1974 · S/N 340-0524N8241QRolling Hills LLC · Plainfield, ILBuilt 1971 · S/N 4140171N8242MGumar Sherko · Scottsdale, AZBuilt 1960 · S/N 39101N8242QBirds Eye View Inc · Farmington, NMBuilt 1973 · S/N 310Q0715N8243QAnderson Cattle Co Inc · Emporia, KSBuilt 1971 · S/N 414-0173N825GSRed River Ranch LLC · Wilmington, DEBuilt 1972 · S/N 310Q0510N829EDiaz Maria · Kansas City, MOS/N 401A0014N82TAJanes Paul A · Ontario, ORBuilt 1968 · S/N 402-0156N82TRExecutive Autopilots DBA · Sacramento, CABuilt 1972 · S/N 414-0273N830LMarlow Aviation LLC · Lamoni, IAS/N 35514N830TTThuen Douglas · Andover, NJBuilt 1972 · S/N 3400186N831CPConstant Pleasure LLC · Paso Robles, CAS/N 310Q0813N831WCEpic Vibes Consulting Group Lp · Princeton, NJS/N 414-0467N83GHTebow William · Bunkie, LABuilt 1978 · S/N 310R1285N83JBHuie Ag Service LLC · Beeville, TXS/N 3400061N83JTLewis Thomas · Belton, TXBuilt 1976 · S/N 414-0835N8422FTownsend David · Piedmont, SCS/N 402-0270N845YCFruscella Alfredo J · Tampa, FLBuilt 1973 · S/N 421B0351N849JBDodson International Parts Inc · Rantoul, KSS/N 421A0075N84RTChannell Robert D · Moreland, GABuilt 1973 · S/N 421B0355N850KFInternational Air Services Inc Trustee · Carson City, NVS/N 310Q-0041N852TSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 414-0804N8571GTravelairatl LLC · Roswell, GAS/N 310R0937N85AMLitchfield Lantz Dr · Las Vegas, NVBuilt 1973 · S/N 414-0435
Back to AD 76-08-02 R2