OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,498

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.

N1594LIntermill Alice R · Volga, SDBuilt 1976 · S/N E-833N1595LClemens Jerry W · Parsons, KSBuilt 1976 · S/N D-9869N1595UJoiner Aviation LLC · Vinemont, ALBuilt 1973 · S/N U20602269N1596GN1596g Inc · Peachtree City, GABuilt 1974 · S/N 340-0507N1596TPlane Crazy Inc · Page, NDBuilt 1973 · S/N 4140376N1597LTougas John D · Huntingtown, MDS/N CE-638N1597WSmith William J · Wichita Falls, TXBuilt 1972 · S/N D-9359N1598HCarey Philip J Trustee · Wasilla, AKBuilt 1977 · S/N 18503314N1598TRegistered aircraftBuilt 1981 · S/N EA-263N1598WCanvasback Investments LLC · Kerrville, TXBuilt 1972 · S/N D-9356N159AARegistered aircraftBuilt 1975 · S/N E-765N159GMArmy Air Corps LLC · Wilmington, DEBuilt 1978 · S/N CE-765N159HAHotel Alpha II LLC · Chattanooga, TNBuilt 2005 · S/N 1459N159ZIdaho State University · Pocatello, IDBuilt 1978 · S/N TJ-178N15ADoug Harris Aviation LLC · Pryor, OKBuilt 1966 · S/N TE-172N15AEWampler Jeffrey A · Valparaiso, INBuilt 2006 · S/N E3740N15CWN15cw LLC · Wilmington, DEBuilt 1983 · S/N P21000824N15CXKlausman Branin W · Mascoutah, ILBuilt 2003 · S/N 0451N15DNSnowflake Aircraft LLC · Fayetteville, NYBuilt 1989 · S/N E-2472N15DQPrivette Hugh T Trustee · Colorado Springs, COBuilt 1975 · S/N 75-30773N15DRTufco Flooring Delmarva Inc · N Chesterfield, VABuilt 2002 · S/N 0394N15DSAll Attitude Aviation Inc · Edgewater, FLBuilt 1965 · S/N 320D0079N15DTBernal Cresencio · Pittsburg, CABuilt 1968 · S/N D-8725N15GMBristol Aviation De LLC · Wilmington, DEBuilt 1995 · S/N E2977N15HCMvp60 Fly High LLC · Boca Raton, FLBuilt 2014 · S/N E-4032N15HSF S Enterprises LLC · Oakland Park, FLBuilt 2020 · S/N E-4143N15JAAdams Harry Jay · New Waverly, TXBuilt 1979 · S/N TK95N15JUC&D Aviation LLC · Appleton, WIBuilt 1982 · S/N TJ-434N15MLN15ml LLC · Cresskill, NJBuilt 1977 · S/N 21061780N15MWZeezee LLC · Phoenix, AZBuilt 1978 · S/N 21063023N15NCHerberg Hayley · Reno, NVBuilt 1966 · S/N CE-12N15PMDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N E-1016N15RDWood Richard W Trustee · Oroville, CABuilt 1978 · S/N E-1407N15RHRansdell Thomas R · Boerne, TXBuilt 2010 · S/N E-3942N15RJColston David T · Vero Beach, FLBuilt 1968 · S/N CE-199N15RPKnob Creek Aviation LLC · Oak Ridge, LABuilt 1974 · S/N E-539N15RRMcdonald Joseph T · Auburn, ALBuilt 1966 · S/N 332N15RXLingo Aviation LLC · Cincinnati, OHBuilt 2004 · S/N 1164N15SVGore Joshua · Sedro Woolley, WABuilt 1977 · S/N 340A-0226N15TTray Aircraft Leasing LLC · Port Richey, FLBuilt 1964 · S/N TC-626N15TBEast West Helicopter Inc · Batesville, INBuilt 1979 · S/N 21063331N15USFlypower Inc · Fort Lauderdale, FLBuilt 1975 · S/N 21060676N15VMGagne Jay A · Dyersburg, TNBuilt 1976 · S/N D-9936N15VVLiberty Flying Club Inc Trustee · Wilmington, DEBuilt 1990 · S/N 340A1520N15WMSidhu Teg Singh · Bakersfield, CAS/N 340A0523N15WRAcmc Operations LLC · Cedar Park, TXBuilt 1975 · S/N 310R0553N15XLrb Aviation LLC · Catawba, NCBuilt 1979 · S/N TJ-226N15XAMenigoz Michael Steven · Puyallup, WABuilt 1975 · S/N E-732N15ZPStefenelli Aviation N Tr Inc Trustee · AtterseeS/N 421B0919N1600XLd&B LLC · Show Low, AZS/N 21060636
Back to AD 86-13-04 R3