OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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.

N2763TOrmsby Stephen J · Somerville, OHBuilt 1967 · S/N D-8469N2764JMcgregor Daniel A · Denali Park, AKBuilt 1969 · S/N 185-1514N2767TCarr Jeffrey L · Hot Springs, ARBuilt 1967 · S/N D-8476N2768JRussell Mark Alex · Fairbanks, AKBuilt 1969 · S/N 185-1518N2769TRakhmatulin Evgeny A · Carlsbad, CABuilt 1967 · S/N D-8477N276BXSmith William P · Chandler, OKBuilt 1966 · S/N D-8257N276CDGandia Justin Kidd · Chicago, ILBuilt 2005 · S/N 1385N276CMTwo Fly Guys LLC · Orlando, FLBuilt 2006 · S/N 29-0445N2771TKleine James S · New Buffalo, MIS/N D-8487N2772JMagoffin David S · Fairbanks, AKBuilt 1969 · S/N 185-1522N2773TPovilaitis Carl A · Glendale, CABuilt 1967 · S/N TE-376N2773WStokes Robert A · Golden, COBuilt 1975 · S/N D-9720N2774TOlson Electrical Services · Reno, NVS/N D-8481N2775TWarner Jason David · Roseville, CAS/N D-8466N2776AMccarthy Brian P · Yonkers, NYBuilt 1969 · S/N D-9054N2776TGeorge John S · Abiquiu, NMS/N D-8480N2777BHollister Jet Center Inc · Hollister, CABuilt 1969 · S/N CE-281N2777JFirst Flight LLC · Craig, AKBuilt 1969 · S/N 185-1527N2777PChilds Patrick S · Jasper, TNBuilt 1967 · S/N D-8535N2778JWilfer Dennis M · Fairbanks, AKBuilt 1969 · S/N 185-1528N2778THavrick Jason T · Bridgeport, TXBuilt 1967 · S/N TE-378N277CTRoss Peter W Trustee · Lufkin, TXBuilt 1998 · S/N EA-617N277FRowland Maxwell J · League City, TXBuilt 1969 · S/N CJ-16N277JMN541mg Inc · Big Pine Key, FLBuilt 1966 · S/N TE-215N277LMRegistration Pending · Bend, ORRegistration pending, pending cancellationBuilt 2003 · S/N ES122N277MDRegistered aircraftBuilt 1966 · S/N TE-223N277RBWaldo Pepper Flying Co · Wilmington, DEBuilt 1964 · S/N D-7473N277WLLozier Wesley · Farmington, ILBuilt 1977 · S/N D-10029N277XSalopek Rett · Las Cruces, NMBuilt 1977 · S/N 414-0925N2781DFejes Guide Service Ltd · Anchorage, AKBuilt 1979 · S/N 185-03892N2781JRussell Scott M · Sanger, TXBuilt 1969 · S/N 18501531N2783TCloud 9 Aviators LLC · Anchorage, AKBuilt 1981 · S/N 18504350N2784TVerastegui Emilio F III · Albuquerque, NMBuilt 1967 · S/N D-8489N2785JDurtschi Steven R · Centerville, UTBuilt 1969 · S/N 185-1535N2785TPatin Carey · New Roads, LABuilt 1967 · S/N D-8501N2787AKnudson Erik · Chandler, AZBuilt 1969 · S/N E-178N2787JLarson Jared E · Wasilla, AKBuilt 1969 · S/N 185-1537N2787TBombero Aviation LLC · Childress, TXBuilt 1967 · S/N TE-388N2788THarnden Craig A · Lake City, FLBuilt 1967 · S/N CE-154N2789TLaycock Sean P · Plymouth, MIBuilt 1967 · S/N D-8483N278CDCirrus Aviators LLC · Elm Grove, WIBuilt 2002 · S/N 0337N278CFInfinity Aviation LLC · Mandan, NDBuilt 1981 · S/N 18504228N278CRRittgers Timothy · Lapeer, MIBuilt 1986 · S/N CE-1089N278DBCt42 LLC · New York, NYS/N 29-0301N278GTankersley Aviation LLC · Sylacauga, ALBuilt 1979 · S/N E-1547N278HJJohnson Joel P · Duluth, MNBuilt 1967 · S/N 185-1268N278MReid Stephen M · Gardner, KSBuilt 1980 · S/N TH-1105N278PBP21000318 Inc Trustee · Wilmington, DEBuilt 1979 · S/N P21000318N278RHolliday Henry S · Poplarville, MSS/N E-1181N2791TJoyce George E · Franklinville, NCS/N TE-384
Back to AD 86-13-04 R3