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.

N761ZBIts Academic Inc · Elyria, OHBuilt 1978 · S/N 21062639N761ZEBrandvik Pipe & Equipment Inc · Borger, TXS/N 21062642N7624NUhuru II LLC · Phoenix, AZBuilt 1968 · S/N D-8854N7624QFhs Aero Co · Olathe, KSBuilt 1973 · S/N 421B0363N762CACullum Transportation LLC · North Charleston, SCBuilt 1981 · S/N 421C1214N762TFair Skies LLC · East Meadow, NYBuilt 1973 · S/N D-9434N762TCCirrus Holdings LLC · Jordan, MNBuilt 2004 · S/N 1035N763United States Department Of Interior · Boise, IDBuilt 1986 · S/N U20606943N7632QPremier Helicopters LLC · Carson City, NVBuilt 1973 · S/N 340-0236N7639NLarson Gregory W · Waxahachie, TXBuilt 1968 · S/N E-60N763CPlane Partners LLC · Greensboro, NCBuilt 2002 · S/N 0431N763CDFlyingmalbec LLC · Lakeway, TXBuilt 2005 · S/N 1689N763EAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0497N763JCPilot Services Of Ohio LLC · Loveland, OHBuilt 1976 · S/N 421C0211N763TCN42 Hy LLC · Kalispell, MTBuilt 1966 · S/N T210-0113N764Usda Forest Servic Fepp · Columbia, SCBuilt 1975 · S/N U20602672N7642NGomez Eliud · Orlando, FLS/N TE-620N7645NFour Five November LLC · Helena, MTBuilt 1968 · S/N E-65N7646NBown George M · Shady Shores, TXBuilt 1968 · S/N E-69N76498Doucey Mark R · The Villages, FLS/N E2607N764DHHess David G Trustee · Chandler, AZS/N CE-1072N764EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0237N764PBBisono Pablo R · Guaynabo, PRS/N 402C0338N764RBReo & Bpo LLC · Lewes, DEBuilt 1982 · S/N 21064674N764SAerotrans Management LLC · Mercer Island, WABuilt 1979 · S/N U20604957N764TSullivan Jerald S · Gilbert, AZBuilt 1973 · S/N E-392N7650NHamilton Marcus · Grosse Pointe Park, MIBuilt 1968 · S/N E-77N7653NPieri James A · Gallatin, TNS/N D-8858N7654NE W Merritt Farms · Porterville, CABuilt 1968 · S/N E-116N7659NPintail Investment Properties LLC · New Bern, NCBuilt 1968 · S/N E-78N765BDukerson Air LLC · Broken Arrow, OKBuilt 2003 · S/N E-3494N765CFCs Air LLC · Osage Beach, MOBuilt 1987 · S/N TH-1528N765FLAviation Angel Tours LLC · Beverly Hills, CABuilt 1975 · S/N 414-0644N765JBN765jb LLC · Colorado Springs, COS/N 340A0647N765LTDrj Aviation LLC · Dover, DES/N 340-0181N765PMorphew Ben · Mckinney, TXBuilt 1964 · S/N 287N765TJohnson Adam D · Denton, TXS/N E-404N765WFKofel Aviation LLC · Clayton, GABuilt 1974 · S/N TH-523N766DBWhelan And Associates Pllc · Eagle, COBuilt 1980 · S/N EA-98N766MHoddenbach Jim · Woods Cross, UTS/N 18501795N766SQualls Shannon D · Mexico, MOBuilt 1965 · S/N D-7818N766TDecesare George D · Danville, CABuilt 1973 · S/N D-9445N7671GPremier Aviation LLC · Philadelphia, MSBuilt 1980 · S/N E-1671N7672NKruco Inc · Spring Valley, MNBuilt 1968 · S/N E-87N76747Walter Timothy Andrew · San Rafael, CABuilt 1979 · S/N EA-41N767BHughes Coby D · Collinsville, OKBuilt 1948 · S/N D-1775N767BKF&E G A Inc · Miami Springs, FLBuilt 2005 · S/N 29-0377N767CMValiair Lc Trustee · Casper, WYBuilt 1992 · S/N E2723N767DFMaurin Edward E III · Grand Junction, COBuilt 1988 · S/N E-2403N767FAQualitair LLC Trustee · MichelstadtBuilt 1981 · S/N TE1188
Back to AD 86-13-04 R3