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.

N66LAAviary LLC · Greer, SCBuilt 1987 · S/N E-2394N66LCBusiness Jet Consultants LLC · Derby, KSBuilt 1977 · S/N E-1050N66LHLane Law Firm Pc · Greenwood Village, COBuilt 1981 · S/N EA-261N66LJ66lj Flying LLC · Wilmington, DEBuilt 2003 · S/N 0727N66MLBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 21062598N66PCHeinzle Hamblin LLC · Eagar, AZBuilt 2001 · S/N LIV 454N66PE811wm LLC · Watertown, CTBuilt 2004 · S/N 1220N66RAGasu LLC · Henderson, NVBuilt 1981 · S/N 340A1231N66SFRed Rock Flying School LLC · Mesa, AZBuilt 1986 · S/N 46-8608042N66TCJohnson Dennis A · Bowman, GAS/N D-8061N66TEFly4fun LLC · El Segundo, CABuilt 1978 · S/N P21000154N66UTFlight Level Engineering LLC · Vineyard, UTBuilt 1950 · S/N NAV-4-2013N66VBButschky Jeffrey · Baldwin, MDBuilt 1978 · S/N CE-830N66VMPg Air LLC · Bellbrook, OHBuilt 2005 · S/N 1556N66VSEurovation Inc Trustee · KematenBuilt 1979 · S/N P21000421N66VVFarrell William J · Fort Myers, FLBuilt 1966 · S/N D-8271N66WCWeiner Ronald I · Jackson, TNBuilt 1978 · S/N D-10199N66WSDighans Murray · Peerless, MTBuilt 1979 · S/N P210-00363N66WZBowing Vending Co Inc · Louisville, TNBuilt 1980 · S/N TJ-321N6700PAbraham Curtis · Byron, WYBuilt 1978 · S/N P21000200N6703RSteinle Lee M · Jourdanton, TXBuilt 1966 · S/N T210-0103N6703VVanias Polychronis · Leroy, MIBuilt 1970 · S/N 30282N6705HKobuk Valley Outfitters Co · Kiana, AKBuilt 1977 · S/N 18503337N6706RSzopa Ireneusz W · East Troy, WIBuilt 1965 · S/N T210-0106N6707RParker David Scott Trustee · Albuquerque, NMBuilt 1965 · S/N T210-0107N6709QClear Blue Marketing Inc · Reno, NVBuilt 1983 · S/N EA-368N6709VBlanton Keith O · Collinsville, OKBuilt 1970 · S/N 30310N670GCFrauenhoff Frank · Manhattan, NVBuilt 1973 · S/N TH-359N670JHNatural Resources Engineering Co Pa · Superior, WIFirst renewal noticeBuilt 1978 · S/N U20604489N670PCw Veach Logistics LLC · Allerton, IAS/N 1166N670TWThunderbolt Ltd · Salem, NEBuilt 1967 · S/N D-8434N6710QWinemiller Steve DBA · Swifton, ARBuilt 1977 · S/N 226BN6712RAero Applications Inc · Burley, IDBuilt 1966 · S/N T210-0112N6712VBainer Kyle W · Cottage Grove, WIBuilt 1970 · S/N 30307N6715RRose Mary R · Portland, ORBuilt 1966 · S/N T210-0115N671BBe-A36 Inc Owner Trustee · Wilmington, DEBuilt 2001 · S/N E-3409N671SHEnochian Gary F · Santa Rosa, CABuilt 1966 · S/N D-8034N671TSpartin Investments LLC · Gallup, NMS/N 990010-MN671TCBraunstein Robert S · Seattle, WABuilt 2001 · S/N EA-671N6720RJacobsen Ian M · Lincoln City, ORBuilt 1966 · S/N T210-0120N67224Vx Inc · Burbank, CABuilt 1983 · S/N EA-370N6722BJca Aviation LLC · Safford, AZS/N 21062826N67230Boomerang Air LLC · Cedar Park, TXBuilt 1983 · S/N E-2093N67249Derasmo Dominick · Manteo, NCBuilt 1983 · S/N CE-1022N6724RDavis Lease LLC · Fort Collins, COBuilt 1966 · S/N T210-0124N6724VFlying Bevo LLC · Newark, DEBuilt 1983 · S/N E-2095N6725VAdvanced Thermal Systems Inc · West Memphis, ARBuilt 1983 · S/N E-2098N6726SSchaney Michael W · Brookville, OHBuilt 1983 · S/N TH-1390N6727RChase Holden · Boulder, COS/N T210-0127N6728FPeters Bruce L · Wichita, KSBuilt 1983 · S/N EA-379
Back to AD 86-13-04 R3