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.

N6110FKilmer Scott D · Fort Pierce, FLBuilt 1968 · S/N 21059010N61119Small Aviation No 3 LLC · Villa Rica, GABuilt 1980 · S/N 18504110N6111MBeech Club LLC · Lacrosse, INBuilt 1965 · S/N D-8033N6112ABarreto Manufacturing Inc · La Grande, ORS/N 21063498N6112FPcb Inc · Paradise, CAS/N 21059012N6112VSlifkin Richard · Forest Hills, NYBuilt 1965 · S/N D-7778N6113ADelianides Aris Philip · Virginia Beach, VABuilt 1981 · S/N E-1941N6114RJstream Lc · Sheridan, WYS/N T210-0014N6114VMarc Inc · Bolton, MSBuilt 1965 · S/N D-7780N61155Smith Jacques F · Anchorage, AKS/N 18504114N61158Robert N Shadduck Inc · Annandale, MNBuilt 1980 · S/N 18504115N6115VLloyd Timothy S · Yorba Linda, CABuilt 1965 · S/N D-7781N61164Brydon Robert J · Lago Vista, TXBuilt 1980 · S/N 18504117N6116CWaukegan Flyers LLC · Waukegan, ILBuilt 1978 · S/N 310R1283N6116RAirxn LLC · Williams, AZBuilt 1965 · S/N T210-0016N6116VDoyle George H III · Anthony, NMBuilt 1965 · S/N D-7782N61170Rusty Pilot Holdings LLC · Citrus Heights, CABuilt 1974 · S/N 21060602N6117FBahl Lawrence S · Lottsburg, VABuilt 1968 · S/N 21059017N6119ABrender Ronald F Trustee · West Lafayette, INBuilt 1979 · S/N 21063502N6119UQureshi Arif · Dansville, NYBuilt 1981 · S/N E-1948N611AGN135pm LLC · Jensen Beach, FLBuilt 1968 · S/N E-90N611CCTjc Productions LLC · Ogden, UTBuilt 1979 · S/N 21063600N611CDPj Aviation LLC · Lake Worth, FLBuilt 2005 · S/N 1599N611DCWhite John D · Rockwall, TXS/N 79-30942N611KGProckter Aviation LLC · Lagrangeville, NYBuilt 2005 · S/N 1551N611PGWrightson Properties LLC · Ft Lauderdale, FLBuilt 1985 · S/N 21064911N611RMRm Management Corp · Johnson City, TNBuilt 2004 · S/N 1133N611RSWickman William S · Mckinleyville, CABuilt 1976 · S/N E-982N611VRRex Vinod · Sunnyvale, CABuilt 2004 · S/N 0924N611VSSargent Randall Lee Trustee · Raleigh, NCBuilt 1968 · S/N CE-205N611WFly Whiskey LLC · Fitzgerald, GABuilt 1968 · S/N TE-509N611WSFreedom Flight Service LLC · Glendale, AZBuilt 1975 · S/N 21061134N6120VDraw Holdings LLC · Meridian, TXBuilt 1965 · S/N D-7783N6121FT & B Aero Enterprises Inc · Jacksonville, FLS/N 21059021N6123XBuffalo Aviators LLC · Denver, COBuilt 1981 · S/N D-10385N6124ZMulchatna Air Taxi LLC · Dillingham, AKS/N U20606150N6125FParker Richard A · West Chicago, ILBuilt 1968 · S/N 21059025N6125JBo LLC · Birmingham, ALBuilt 1982 · S/N E-1949N6126CM20k LLC · Minot, NDBuilt 1978 · S/N 310R1293N6126FCarson John D · Garber, OKBuilt 1968 · S/N 21059026N6126RKelley Kal · Colville, WAS/N T210-0026N6126YCruise Flight Aviation Inc · Denver, COBuilt 1981 · S/N 21064260N61273Wrangell Mountain Air Inc · Palmer, AKBuilt 1973 · S/N U20602067N61275K & K Adventures Inc · Wilmington, DEBuilt 1974 · S/N 21060604N61276Sonnys Aviation Inc · Miami, FLFirst renewal noticeBuilt 1973 · S/N U20602069N6127FSmith Phillip · Osprey, FLBuilt 1968 · S/N 21059027N6127RPhillips Bill · Galt, CABuilt 1965 · S/N T210-0027N6128ROhop Robert D · Jones, OKBuilt 1965 · S/N T210-0028N61298Arizona Game And Fish Department · Phoenix, AZBuilt 1980 · S/N 18504142N6129RIncline Engineering And Consulting LLC · Ovalo, TXBuilt 1965 · S/N T210-0029
Back to AD 86-13-04 R3