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.

N570EK & D Air LLC · Morgan City, LABuilt 1975 · S/N 310R0175N5711MSwager Joel P · Ione, CAS/N 310P0011N5712MDay Star Aviation Inc · Locust Grove, GABuilt 1968 · S/N 310P0012N5714XKulon Andrew · Wyanet, ILS/N 3200014N5715MExpress Air LLC · Wilmington, DEBuilt 1968 · S/N 310P0015N5716XFlanegan Charles E Jr · Jonesboro, GABuilt 1961 · S/N 320-0016N5720MSongbird Aviation Inc · Lawrenceville, GABuilt 1968 · S/N 310P0020N5721MWood Michael D · Huntington Beach, CABuilt 1968 · S/N 310P0021N5721XRichardson John L · Anchorage, AKS/N 320-0021N5729MN5729m LLC · Coral Springs, FLBuilt 1972 · S/N 340-0038N5731MZortman Micky P · Mexico, MOS/N 310P0031N5731XLife Is Flying Inc · Deerfield Beach, FLBuilt 1961 · S/N 320-0031N5740MSiemens Jonathan · Seminole, TXBuilt 1968 · S/N 310P0040N5741MCoolidge Robert · Rio Vista, TXBuilt 1968 · S/N 310P0041N5742MAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1968 · S/N 310P0042N5746MFlyaware Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 310P0046N5746X300 Series Aviation LLC · Fort Worth, TXBuilt 1961 · S/N 320-0046N5752MColeman William J · Redondo Beach, CABuilt 1968 · S/N 310P0052N575HBHot Damn Flying Service LLC · Palm Coast, FLBuilt 1973 · S/N 310Q0788N5762MNewby Aviation LLC · Pingree Grove, ILBuilt 1968 · S/N 310P0062N5763MStan Hill Aviation LLC · Waterford, MIBuilt 1969 · S/N 310P0063N5765MBush Abe A · Eatonton, GABuilt 1968 · S/N 310P0065N5768MHeal Your Heart LLC · Redding, CABuilt 1968 · S/N 310P0068N5768S3c LLC · Waukee, IABuilt 1972 · S/N 3400037N5769XHagemeier Justin · Memphis, TNBuilt 1961 · S/N 320-0069N5770MBallard Aviation Inc · Newton, KSFirst renewal noticeBuilt 1968 · S/N 310P0070N5779XDirigo Aerospace Solutions LLC · Sumner, MES/N 320-0079N577SWAir Plains Services Corp · Wellington, KSS/N 421-0023N5780XWilton William H · Kailua Kona, HIBuilt 1961 · S/N 320-0080N5781MRudnik Andrew S · Ann Arbor, MIBuilt 1969 · S/N 310P0081N5782MGingell Robert A · Sunnyvale, CABuilt 1969 · S/N 310P0082N5783MBig Turbine Engines LLC · Wilmington, DEBuilt 1969 · S/N 310P0083N5788XMcmahan William K · Sandy Valley, NVBuilt 1962 · S/N 320-0088N5793MCoxbill Farms Inc · Torrington, WYBuilt 1969 · S/N 310P0093N5793XSchmick Kenneth Richard · Fond Du Lac, WIS/N 320-0093N5794MMatlach Matthew · Brandon, FLBuilt 1969 · S/N 310P0094N57BWNorthwoods Airlifeline Ltd · Kingsford, MIBuilt 1968 · S/N 310N-0154N5800MRidgewood Associates Inc · Nevada City, CAS/N 310P0100N5806XJohnson Joseph S · Juneau, AKBuilt 1961 · S/N 310-0106N5812XAll-Bid Inc · Opelousas, LABuilt 1961 · S/N 310-0112N5814XEberly Steven K · Euless, TXBuilt 1961 · S/N 310-0114N5816MHolloway Aero LLC · Chino Hills, CAS/N 310P0116N5817MHonan William · Rainbow City, ALBuilt 1969 · S/N 310P0117N5818MGlidepath Aviation LLC · West Jordan, UTBuilt 1969 · S/N 310P0118N5819MJones Kathleen W · Springfield, ORBuilt 1969 · S/N 310P0119N581CJDodson International Parts Inc · Rantoul, KSS/N 421B0343N5821MMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0121N5822XTas Aviation Of Defiance Inc · Defiance, OHBuilt 1961 · S/N 310-0122N5825MLee Brian P · Kent, WABuilt 1969 · S/N 310P0125N5827MHopland Steve · Johnson City, TNBuilt 1972 · S/N 340-0051
Back to AD 76-08-02 R2