OpenAirDocs.org
AD 76-08-02 R2

Registered aircraft · 2,552

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.

N3042LMsl Holdings · Newbury Park, CABuilt 1965 · S/N 310J0042N3042TKls Enterprises Inc · Cave Creek, AZBuilt 1964 · S/N 320C0042N3043TJwt Aviation LLC · Yancey, TXBuilt 1964 · S/N 320C0043N3048LLuster Maurice A Jr · Miami Beach, FLS/N 310J0048N304MCValiair Lc Trustee · Casper, WYS/N 421B0130N3050LMadison Mitchell · Guthrie, OKBuilt 1965 · S/N 310J0050N3050TLand T Chat · Tulsa, OKBuilt 1964 · S/N 320C0050N3051TPacific Arts Collection LLC · Oakland, CAS/N 320C0051N3055TTechnical Education Services · Virginia Beach, VABuilt 1965 · S/N 320C0055N3056LFowler Larry K · Harrison, ARBuilt 1965 · S/N 310J0056N3061DJeppson Edward Mckay Trustee · South Jordan, UTBuilt 1956 · S/N 35261N3063DCase William M · Klamath Falls, ORBuilt 1956 · S/N 35263N3064DLebron R Luke · Gulfport, MSS/N 35264N3068LMirage Air Ltd · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 310J0068N3069DSmith Gregory E · White Lake, MIBuilt 1956 · S/N 35269N3070LClark Kenneth N · Tempe, AZBuilt 1965 · S/N 310J0070N3071LDishburger Samuel T · Westfield, INBuilt 1965 · S/N 310J0071N3073LSheakley John W DBA · Meadville, PABuilt 1965 · S/N 310J0073N3075LAlvis Michael E · Parkton, NCS/N 310J0075N3079LTff Inc · Parma, MIBuilt 1965 · S/N 310J0079N3083LPrice Randy L · Pahrump, NVS/N 310J0083N3088LRice James M · Austin, TXS/N 310J0088N308CFBaba Kenneth D · Sierra Vista, AZBuilt 1973 · S/N 310Q0804N3091DBella Farms Inc · Hayes Center, NEBuilt 1956 · S/N 35291N3091LAbbasi Babak · Murrieta, CABuilt 1965 · S/N 310J0091N3094DAberdeen Pilots LLC · Boerne, TXBuilt 1956 · S/N 35294N3095DIrvine William G · Rosamond, CABuilt 1956 · S/N 35295N30DTShelton Sharon Shay · Abilene, TXS/N 414-0910N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266N30HCKinetic Concepts LLC · Pensacola, FLS/N 310Q1079N30LPDialysis Clinic Inc · Nashville, TNBuilt 1977 · S/N 310R0995N30RWSaltzy Seas LLC · Loxahatchee, FLBuilt 1976 · S/N 310R0667N30SSN30ss LLC · Dover, DEBuilt 1973 · S/N 414-0451N30TAero Quest LLC · Olive Branch, MSBuilt 1962 · S/N 310G-0031N3101TMission Air LLC · Charlotte, NCS/N 310R1877N310ACJulie Dorst LLC · Kalispell, MTBuilt 1975 · S/N 310R0290N310ADChang Stephen · Santa Barbara, CABuilt 1976 · S/N 310R0538N310AFSelwa Michael A · Oconomowoc, WIBuilt 1974 · S/N 310Q1121N310AHGraydon Bilal R · Melbourne, FLBuilt 1979 · S/N 310R1660N310AJPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1980 · S/N 310R1606N310AMCwr Enterprises Inc · Henderson, NCBuilt 1979 · S/N 310R1672N310ARHales Gutter Guys LLC · Cottonwood, AZS/N 310R1387N310ATBelknap Scott M · Temecula, CABuilt 1965 · S/N 310J0097N310AWBetty Eric · Old Hickory, TNBuilt 1969 · S/N 310P0231N310BARampey Alvin H Jr · Atlanta, GABuilt 1975 · S/N 310R0065N310BBF & F Aviation LLC · Memphis, TNS/N 310R1858N310BDSale Reported · Fort Wayne, INSale reportedBuilt 1965 · S/N 310J0013N310BFGv Air Inc · Medford, ORBuilt 1978 · S/N 310R1390N310BGFlairships LLC · Durham, NCBuilt 1977 · S/N 310R0889N310BJJ A Flight Services LLC · Sugar Grove, ILBuilt 1973 · S/N 310Q0759
Back to AD 76-08-02 R2