OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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.

N782CDArbuckle Roger · Greenville, KYBuilt 2005 · S/N 1691N782KJSrl Investments LLC · Boone, IABuilt 2005 · S/N 42083N7832RSmith Brian S · Johnson City, TNBuilt 1969 · S/N D-8916N7835VRoney John P · Charlotte, NCBuilt 1978 · S/N D-10155N7837REob Aviation LLC · Grand Haven, MIBuilt 1969 · S/N TE-675N7839RMuddy Wolf Holdings LLC · Wilmington, DEBuilt 1969 · S/N TE-672N783JR13 Aviation LLC · Chelan, WABuilt 1979 · S/N TJ-231N783TMElliott Frank A · Oxford, MSBuilt 1973 · S/N D-9489N78417Mcelwain Russell D · Lancaster, KSBuilt 1974 · S/N 18801952TN7841MDocmax LLC · Tucson, AZBuilt 1964 · S/N D-7398N7841QExigo Capital LLC · Miami Beach, FLBuilt 1973 · S/N 340-0222N7843LLampe Robert T · Kendall, KSS/N D-8817N7843RTrupkin Steven J · Wantagh, NYBuilt 1969 · S/N D-8918N7845QReading Jared · Uvalde, TXBuilt 1973 · S/N 340-0225N7845RCurley Quinn T · Copperopolis, CABuilt 1968 · S/N D-8908N7848REntrekin Gary W · Ventura, CABuilt 1968 · S/N D-8904N784AWSea Rogue Enterprises Inc · Greenville, MEFirst renewal noticeBuilt 1973 · S/N 18502251N784CDRay Matthew C · Powell, OHS/N 1700N784DJAlta Volare LLC · Wilmington, DEBuilt 1968 · S/N 21059104N7853RHarrell Erick C · Sedona, AZS/N CJ-17N7854RHulsey Mark T Sr · Prescott, AZBuilt 1968 · S/N E-133N7855ZRoskowski David · Charlestown, INBuilt 2005 · S/N 1629N7856LGall Peter D · Morgantown, WVBuilt 1966 · S/N D-8289N7858PRegistered aircraftBuilt 1978 · S/N TJ-183N785CDPresidio LLC · Manhattan, KSBuilt 2005 · S/N 1718N785JBFuller Aire Inc · Wilmington, DEBuilt 1969 · S/N D-8915N785RWWiseman Russell · Keller, TXBuilt 1968 · S/N E-19N7864FKeller Russell L · Runaway Bay, TXBuilt 1968 · S/N 4010207N7865RSpangler Bryan G · Manteno, ILBuilt 1969 · S/N D-8932N7866RN7866r Leasing LLC · Linden, MIBuilt 1969 · S/N D-8926N7867RBlue House Veterinary LLC · Buffalo Lake, MNBuilt 1969 · S/N E-136N7868LJacob William G · Glendora, CABuilt 1966 · S/N D-8292N7869LCrawford Scott · Newalla, OKBuilt 1966 · S/N D-8293N786TSTurnquist Paul Sr · Lincoln, MEBuilt 1976 · S/N E-901N7870LCnf LLC · Ada, OKBuilt 1967 · S/N TE-336N7870REtchell Russell Allan Trustee · Santa Rosa, CABuilt 1969 · S/N D-8928N7874J2f Trade LLC · Collinsville, TXS/N 21060597N7875EUniversity Research Foundation · Greenbelt, MDBuilt 1973 · S/N 402B0432N7875LRegistered aircraftBuilt 1966 · S/N D-8295N7875RJohnson Joel Andrew · Winterset, IABuilt 1969 · S/N D-8934N7878RWeishaar Traig Tl · Worley, IDS/N TE-682N7878YKujanski Jon G Trustee · Saint Charles, ILBuilt 1991 · S/N CE-1563N7879LCjp Air LLC · Mustang, OKBuilt 1966 · S/N D-8318N7879RMorgan Mark T · Corryton, TNS/N D-8936N787AECoordinate Productions LLC · Waterloo, IABuilt 1972 · S/N 21059799N787AQHiflynal LLC · Harrisburg, ORS/N P21000844N787BCWomack Kevin · Lancaster, KYBuilt 2004 · S/N 1224N787CBFly Boyz LLC · Hurricane, UTBuilt 2003 · S/N 0787N787CCMegaship Ventures LLC · Baytown, TXBuilt 1985 · S/N TH-1490N787CDHarrelson Steve · Little Rock, ARBuilt 2004 · S/N 0918
Back to AD 86-13-04 R3