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.

N1883FAnkeney Scott · Canyon, TXBuilt 1966 · S/N 21058783N1885WS35s LLC · Stevens Point, WIBuilt 1973 · S/N D-9485N1886W86 Whiskey Corporation · Vineland, NJBuilt 1973 · S/N E-441N1887FHeadings Kevin · Echo, ORS/N 21058787N1889FPiper Henry Burton Jr · Kingston, TNBuilt 1966 · S/N 21058789N1889WSabre 65 LLC · Helena, MTBuilt 1973 · S/N TH-341N188GWBrown Die Casting & Manufacturing Inc · Royse City, TXBuilt 1979 · S/N 421C0613N188MGMarkusair Leasing LLC · Wilmington, DEBuilt 2018 · S/N 32-0006N188RCHodgskies Holdings LLC · Choteau, MTBuilt 1984 · S/N E-2189N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67N1891DDale Richard C · La Vernia, TXS/N D-3163N1891WSchwartz Eric · Timnath, COBuilt 1973 · S/N E-440N1892FPanagotacos George · Corona, CABuilt 1966 · S/N 21058792N1892LMcnair Craig · Dayton, TXBuilt 1976 · S/N D-9897N1893FKleeman Mark · Kearney, MOFirst renewal noticeS/N 21058793N1893LHarlan Blake · Trinity Center, CABuilt 1976 · S/N E-863N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16N1897EThompson Loren Charles · Arlington, VABuilt 1966 · S/N D-8313N18998Duffer Management LLC · Carlsbad, CABuilt 1977 · S/N D-10073N189CRPelco Investments Inc · Wilmington, DEBuilt 1981 · S/N TE-1187N189FTeag Leasing LLC · Edmonds, WABuilt 2001 · S/N EA-680N189LESwt Aviation Inc · Newport Beach, CABuilt 2011 · S/N E-3957N189MKS2ar Aviations LLC · Lantana, FLBuilt 1978 · S/N 414A0100N18AWayman Ian A · Medford, ORS/N CE-629N18BEStarkey Thomas David · Nashville, TNBuilt 1977 · S/N CE-726N18BGTommervik Sean · Philadelphia, PAS/N 02GN18BKShandog Air LLC · Ashland, KYS/N 310R0981N18CNTab Flyers LLC · Champaign, ILBuilt 1968 · S/N CE-208N18DADye Paul C · Mcneal, AZBuilt 1977 · S/N 18503439N18DLBelov Mikhail · Greenwood Village, COBuilt 1977 · S/N 310R1251N18DNZba LLC · Hurricane, UTBuilt 2001 · S/N 0096N18DRBurns Donald N DBA · Watkinsville, GABuilt 1978 · S/N E1228N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394N18EJPelizzon David R Trustee · Naples, FLBuilt 2007 · S/N E-3803N18EWCahill Thomas · Queensbury, NYBuilt 1966 · S/N CE-22N18GGLogan Rob · Watervliet, NYBuilt 2002 · S/N 134N18GWMcbride Kenneth B · San Martin, CABuilt 1949 · S/N 35N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651N18KFNelco Inc · Blanchard, OKBuilt 1978 · S/N E-1251N18LLPiping Technology Consultants Inc · Monee, ILBuilt 1978 · S/N E-1332N18MDN18md Aviation LLC · Salem, ORBuilt 1967 · S/N TE-455N18MJFleeman Julie · Laguna Niguel, CABuilt 1978 · S/N E-1250N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557N18NFR D Aviation LLC · Phoenixville, PABuilt 1967 · S/N 21058903N18RBDuval Kenneth M · Richardson, TXBuilt 1973 · S/N CE-461N18SAWatkins Aviation LLC · Kenton, OHBuilt 2005 · S/N 1401N18SBTroy Motz Construction Inc · Lincolnton, NCBuilt 1978 · S/N 18266338
Back to AD 86-13-04 R3