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.

N8421NFagan Dan III · Murfreesboro, TNBuilt 1968 · S/N D-8785N8422FTownsend David · Piedmont, SCS/N 402-0270N8423NFarnham Dale E · Ames, IABuilt 1968 · S/N D-8787N8424WExtra Equipment Inc · Stuart, FLBuilt 1979 · S/N 21063732N8425NWoods Aviation LLC · Fillmore, ILBuilt 1968 · S/N D-8790N8425QPerrycook Flight Services LLC · Gig Harbor, WABuilt 1978 · S/N 18503695N8426NNicor Inc · Columbus, NEBuilt 1968 · S/N CE-220N8428NAlexander Robert W · Knoxville, TNBuilt 1968 · S/N D-8788N842BESparrow Holdings LLC · Irvine, CABuilt 1984 · S/N EA-432N842DYAltimate Transportaton Services LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 421C0312N843CDLiberty Land Management LLC · Woodland, CABuilt 2002 · S/N 0160N843CMLamar Lending LLC · League City, TXBuilt 1975 · S/N E-754N843TClifford Brent N · Lubbock, TXBuilt 1973 · S/N D-9482N843YTTrue Drilling LLC · Casper, WYBuilt 1979 · S/N 21063334N8441NBeasley Marty J · Statesboro, GAS/N D-8789N8442QFerguson John W · Edwardsburg, MIBuilt 1976 · S/N U20603301N8446QHarms Harvey D · Chugiak, AKBuilt 1978 · S/N 18503704N84497N84497 LLC · Omaha, NEBuilt 1974 · S/N 18801989TN8449NNms Air LLC · Kalamazoo, MIBuilt 1968 · S/N D-8794N844CDAfterburner Dreams LLC · Tupelo, MSBuilt 2002 · S/N 0178N844CKTurpin Time LLC · Helena, MTBuilt 1979 · S/N 421C0706N844CSSchmidt Clifford W · Jackson, MIBuilt 1970 · S/N D-9247N844HSanker Frank Trustee · Keller, TXBuilt 1991 · S/N CE-1623N84508Goodwin Reginald J O · Clancy, MTBuilt 1973 · S/N 18261882N8451NCfp Corporate Finance Partners LLC · Newport Beach, CABuilt 1968 · S/N TE-571N8451QRunway Three Aviation LLC · Kalispell, MTBuilt 1976 · S/N U20603309N8452NGottsch Joe · Salem, ORBuilt 1968 · S/N D-8808N8456QHappy Wings LLC · Erie, COBuilt 1978 · S/N 18503707N8457NSharon Enterprises LLC · Peralta, NMBuilt 1968 · S/N D-8809N8459NContrail LLC · Deerfield Beach, FLBuilt 1968 · S/N D-8796N845CDJones Taylor L · Griffin, GABuilt 2002 · S/N 0194N845CMSkinner David A · Moline, ILBuilt 1996 · S/N LIV-033N845DBPierce Ryan · Longview, TXBuilt 1982 · S/N E-2044N845JMatthews Michael · Kingfisher, OKBuilt 2005 · S/N 1365N845JRDean Construction Corp · Medford, ORBuilt 2001 · S/N 0081N845LMarshall Timothy Trustee · Tucson, AZBuilt 1982 · S/N 340A1511N845LLLepp Curtis Wayne · New Braunfels, TXBuilt 2003 · S/N 42019N845LPSafetypro Air LLC · Marietta, GABuilt 2004 · S/N 1047N845PDelta Tango Aviation LLC · Wilmington, DEBuilt 2003 · S/N 0466N8462QPahrump Aviation LLC · Las Vegas, NVS/N U20603320N8463NDc Executive Aviation LLC · Spring, TXBuilt 1968 · S/N D-8798N8463QSmith James M · Star, IDBuilt 1976 · S/N U20603321N8466QAirtime LLC · Dayton, IDBuilt 1978 · S/N 18503710N846CDLrp Corp · Medford, ORBuilt 2002 · S/N 0188N8471QIgiugig Lodge LLC · Wasilla, AKBuilt 1976 · S/N U20603329N84735Christensen Rod C · Fairbanks, AKBuilt 1976 · S/N 18503152N8474UBirdwin LLC · Buras, LABuilt 1969 · S/N U2061294N8475MSpess Drilling Co Inc · Cleveland, OKBuilt 1977 · S/N 21062046N8476NMeyer Chad A · Whittemore, IABuilt 1968 · S/N CE-226N84777Flight Path Partners LLC · San Mateo, CABuilt 1972 · S/N 21059624
Back to AD 86-13-04 R3