OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N7745RCummings Thomas · Ventura, CABuilt 1968 · S/N E-107N7747RD2 Aviation Services LLC · Wilmington, DEBuilt 1968 · S/N E-109N774BDDavis III Robert F · Longview, TXBuilt 1981 · S/N E-1868N774CDValiair Limited Co Trustee · Casper, WYBuilt 2003 · S/N 0786N774CSWyo Ventures LLC · Buffalo, WYBuilt 1976 · S/N 21061359N774DCBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 340A0206N774DFEclipse Aviation LLC · Las Vegas, NVBuilt 1964 · S/N D-7395N774RDDemuth Roger C Trustee · Valley View, TXBuilt 1974 · S/N 21060229N774SDr Leasing Ltd · Wilmington, DEBuilt 1966 · S/N D-8088N7750QJohnson Gregory L · Orange, CABuilt 1973 · S/N 340-0200N77554U S Department Of The Interior · Boise, IDBuilt 1976 · S/N U20603408N7758BMiller Jeffrey A Trustee · Tucson, AZBuilt 1982 · S/N TJ-394N7758RT & C Aviation LLC · Ardmore, OKBuilt 1968 · S/N E-112N775CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0228N775EWThree Three Foxtrot Inc · Cedar Falls, IABuilt 2003 · S/N 0526N775JWCunningham William R · Broken Arrow, OKBuilt 1968 · S/N CJ-2N775PSkydive Seneca Lake LLC · Ovid, NYBuilt 1966 · S/N U206-0769N775RCAirswiss Inc · Wilmington, DEBuilt 1980 · S/N 402C0311N775SLDue Aviatori LLC · Scottsdale, AZBuilt 2007 · S/N E-3805N775TSorensen Craig A · Fallon, NVBuilt 1974 · S/N D-9664N775VCAmaria Marzban Keki · Riverside, CABuilt 1992 · S/N CE-1704N775ZHundal Medical Corp · Malibu, CABuilt 1980 · S/N TJ283N7760RJenkins Seth · Charlotte, NCBuilt 1968 · S/N E-114N7761RMarrow Henry Gregory · Southern Pines, NCBuilt 1968 · S/N D-8879N7762RPossumtown Alleycats LLC · Midland, TXBuilt 1968 · S/N TE-650N7765RDumbo Aviation LLC · Omaha, NEBuilt 1968 · S/N D-8882N7767BKline Paul · El Mirage, AZBuilt 1971 · S/N 18501945N7768RIvey Martin J · Dennis, TXBuilt 1968 · S/N D-8897N7769RPelican Air Inc · Kersey, PABuilt 1968 · S/N D-8906N776CDTriple Crown Aviation LLC · Las Vegas, NVBuilt 2004 · S/N 1039N776CMNewman Air LLC · Sherborn, MABuilt 1998 · S/N 1N776DSullivan Dennis · Santa Ana, CABuilt 1969 · S/N D-9063TN776DADavisair Inc · Raleigh, NCBuilt 1993 · S/N TH-1697N776TMAero Performance LLC · Scooba, MSBuilt 1976 · S/N 21061480N776TPIron Horse Investment LLC · Helena, MTBuilt 2014 · S/N E-4027N776WCWingtip Corporation · Valparaiso, INS/N TH-570N776YDRapp Larry · Elbow Lake, MNBuilt 1988 · S/N E-2463N7772LJerez John J · Bonita, CABuilt 1996 · S/N 29-0093N7772RBpk Ventures LLC · Jupiter, FLBuilt 1968 · S/N D-8896N7773HCirrus 7773h LLC · Wilmington, DEBuilt 2003 · S/N 0723N7774BAdair Aviation LLC · Broken Arrow, OKBuilt 1981 · S/N U20606224N7774PBlack Scorpion LLC · Helena, MTBuilt 1997 · S/N LIV-072N7774ZLaw Office Of Yossi Noudel · Encino, CABuilt 2005 · S/N 1345N7776HAcevedo Adriel · San Antonio, TXBuilt 1976 · S/N 21061194N77770Bredder Brett A · Brighton, COS/N 320D0058N7777ALibby Stephen R Trustee · Anchorage, AKBuilt 1978 · S/N U20604391N7777SHood Company LLC · Nashville, TNBuilt 1972 · S/N 21059611N777AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N E-899N777BAGado Theodore A · Cortlandt Manor, NYBuilt 1972 · S/N D-9408N777BCBas Part Sales LLC · Greeley, COBuilt 1966 · S/N D-8230
Back to AD 86-13-04 R3