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.

N9870YDejong Arie H · Maricopa, AZFirst renewal noticeBuilt 1981 · S/N 21064621N98725First Flight Corp · San Diego, CABuilt 1976 · S/N 414-0824N9873FAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402-0303N98747American Skyways Inc · Corning, NYBuilt 1976 · S/N 340A0065N9875VSatanta Flying Service Inc · Satanta, KSBuilt 1966 · S/N 188-0125N9876TJr Aviation LLC · Benton, KSBuilt 1975 · S/N E-795N9876ZGv Air Inc · Medford, ORBuilt 1983 · S/N U20606721N9878HHatfield Derik · Mesa, AZBuilt 1978 · S/N 21062885N9878MA&J Airsales Inc · San Antonio, TXBuilt 1977 · S/N 21062084N987CDTrike Industries LLC · Draper, UTBuilt 2005 · S/N 1310N987JSAmerican Star Aviation LLC · Ithaca, NYBuilt 1999 · S/N TH-1923N987KCAsberry Gregg J · Sidney, ARBuilt 1990 · S/N E-2556N987PLColestine Holdings LLC · Ashland, ORBuilt 1985 · S/N 21064960N987TTEllison Thomas Andrew · Parker, TXBuilt 1993 · S/N E-2776N987WEstrada Alfonso · Santa Teresa, NMBuilt 2004 · S/N 1062N98834Guzman Franklin · Teaneck, NJBuilt 1976 · S/N 310R0603N98842Dan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1976 · S/N 310R0609N98869Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0625N98892Bright Aviation LLC · Salt Lake City, UTBuilt 1977 · S/N 310R1204N98899Air Z Flying Service Inc · Willoughby, OHBuilt 1976 · S/N 310R0642N9889YTharp Rodney W · Thomasville, NCBuilt 1981 · S/N 21064629N988CDKading Kevin · Tucson, AZBuilt 2004 · S/N 0889N988DMHart Paul E · El Macero, CABuilt 1981 · S/N 340A1244N988JGSaratoga Aviation LLC · Wilmington, DEBuilt 1999 · S/N EA-638N988MVMiller James A · Granada Hills, CABuilt 1967 · S/N T210-0284N988STTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N TH-2219N988YTMdf Ventures LLC · Los Angeles, CABuilt 2001 · S/N EA-685N9890MR & R Brown Inc · Sun Valley, IDBuilt 1977 · S/N 21062085N9890YValiair Lc Trustee · Casper, WYS/N 21064630N98911Roettger Electric Co Inc · Evansville, INBuilt 1976 · S/N 310R0646N9892084wc Inc · Lewes, DEBuilt 1976 · S/N 310R0647N98943Watts John J · Murchison, TXBuilt 1977 · S/N 310R1243N9894YRaymond Andy · Council Bluffs, IABuilt 1981 · S/N 21064632N98974Tolson Michael A · Waleska, GABuilt 1976 · S/N 310R0671N98980Hyder Plumbing Co Inc · Tryon, NCBuilt 1976 · S/N 310R0675N989AAMouat Brian · Trent Woods, NCS/N 401A-0042N989BMHornung Kirk F · Beavercreek, OHS/N E-964N989DFKearns Floyd M · Houston, TXBuilt 2003 · S/N 0554N98AFScales James O Trustee · Newburgh, INBuilt 1999 · S/N ES-047FBN98BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N TJ-193N98CEQueen Aviation LLC · Wilmington, DEBuilt 1978 · S/N 414A0066N98DCCayuga Copters Inc · Cynthiana, KYBuilt 1972 · S/N TE-865N98DMSonrise Aviation LLC · Portland, INBuilt 1976 · S/N 310R0819N98HMRegistered aircraftS/N 97-301025N98JBFlight1 Hsw LLC · Norwood, COBuilt 1965 · S/N 652N98JKIntagliata Joseph V · Hanna, INBuilt 1998 · S/N EA-609N98LKMb Duncan Inc · Bakersfield, CABuilt 1977 · S/N D-10027N98LRZ Corp Inc · Middletown, DEBuilt 1997 · S/N E-3126N98MMSrt Group Inc · Southaven, MSBuilt 1979 · S/N 340A0639N98MRAviato LLC · Heath, TXBuilt 1978 · S/N D-10119
Back to AD 86-13-04 R3