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.

N3VBHarrison Ted W · Grapevine, TXBuilt 1965 · S/N 320D0044N3VYSilverstein Adam R · Pittstown, NJBuilt 1957 · S/N BG-334N3WFFolk Wolfgang · Fairfield, CABuilt 1975 · S/N 414-0617N3XDHammer Steven L · Peachtree City, GABuilt 1996 · S/N 204N3XTHammock Jerry G · Waxahachie, TXBuilt 1970 · S/N D-9156N3YHMarsaudon David · Friday Harbor, WABuilt 2002 · S/N 0239N3YPAstmann Roger J · North Haven, CTBuilt 1966 · S/N CE-32N3ZEZephyr Enterprises Inc · Wilmington, DEBuilt 1968 · S/N NAV-4-2520N3ZGIsbell Tony A · Rainbow City, ALS/N 1572N4000LUrquhart Ken · Wedowee, ALBuilt 2013 · S/N E-4000N4000WN4000w LLC · Prescott, AZBuilt 1974 · S/N TE-1004N4003BHenderson James A · Flomaton, ALBuilt 1974 · S/N 75-30730N4004APrice Jason R · Lillington, NCBuilt 1970 · S/N D-9098N400APZoie Air LLC · Fort Lauderdale, FLBuilt 1974 · S/N 340-0345N400ATAlpha Tango Aviation Inc · Middletown, DEBuilt 1981 · S/N 402C0510N400BJAirrich LLC · Largo, FLBuilt 1974 · S/N 421B0819N400DMAlborn Mary L · Eagle River, AKS/N E-748N400DPLindsey Russell R · Abilene, TXS/N 310R0268N400GMN400gm LLC · Salisbury, MDBuilt 1974 · S/N 310Q1000N400GTDelaney Holdings LLC · De Witt, IABuilt 1971 · S/N 21059544N400HXTevis David James · Colorado Springs, COBuilt 1964 · S/N 21058352N400KClydesdale Asset Management LLC · Park City, UTBuilt 1979 · S/N 18503889N400LFBoboltz Randy · Hector, MNBuilt 1975 · S/N D-9825N400LLMentor Flyers Inc · Paragon, INBuilt 1957 · S/N BG-400N400MERegistered aircraftBuilt 1999 · S/N 30-0040N400MTSpevco Inc · Pfafftown, NCBuilt 1955 · S/N G-145N400PBonanza V35 LLC · Bakersfield, CABuilt 1976 · S/N D-9933N400RCSpiwak Andrew J · Canyon Lake, TXBuilt 1972 · S/N D-9312N400TVA & A Farms Inc · Arbuckle, CABuilt 2004 · S/N 42041N400VHalford John · Ballinger, TXBuilt 1973 · S/N D-9535N400WEOberti Gary A · Hillsborough, CABuilt 1975 · S/N D-9814N400WTArtspret Aviation LLC · Sugar Grove, ILBuilt 2001 · S/N EA-690N4010ARegistered aircraftBuilt 1970 · S/N D-9099N4013AGeoghagan Dewayne · Indianapolis, INBuilt 1970 · S/N D-9115N4015AOvad David Mark · Reisterstown, MDBuilt 1970 · S/N CE-297N401AESmith Jay D · Shreveport, LABuilt 1976 · S/N E865N401ATBlum John J · Montgomery, TXBuilt 1966 · S/N 401-0010N401AZTre Aviation Corp · Wilmington, DEBuilt 1969 · S/N 401B-0018N401BTKlena Bradley D · Maryville, TNS/N 401A0002N401CAGlenn Roger H · Pacifica, CABuilt 1969 · S/N 401A-0025N401CFStuewe Charles D · Chino Hills, CABuilt 1967 · S/N 401-0115N401DSalsola Logistics LLC · Douglas, WYBuilt 1977 · S/N 18503517N401DRApex Aeronautical Group LLC · Jenks, OKBuilt 1980 · S/N TH-1138N401KN401k LLC · Lonoke, ARBuilt 1967 · S/N 401-0038N401MPFriend Ships · Lake Charles, LABuilt 1979 · S/N P21000280N401MROk Av8r LLC · Iowa Park, TXBuilt 1967 · S/N 401-0159N401PSLesmeister Dean · Kindred, NDBuilt 2005 · S/N 29-0401N401RSTraining Services Inc DBA · Virginia Beach, VABuilt 1967 · S/N 401-0073N401SBGoertzen Joshua K · Wasilla, AKBuilt 1975 · S/N TH-641N401SUWright Air Service Inc · Fairbanks, AKBuilt 1975 · S/N U20602932
Back to AD 86-13-04 R3