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.

N417WCMpi Warehouse Specialty Company Inc · Casper, WYBuilt 1985 · S/N EA 451N418Vpropnw Inc · Walla Walla, WABuilt 1966 · S/N 359N4180SPalomino Princess Express LLC · Helena, MTS/N D-9755N4181SArizona Type Ratings LLC · Sedona, AZBuilt 1975 · S/N E-672N4181TKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320D0081N4182SSassine Alain · Estero, FLS/N E-668N4184BWitt Aaron K · Hooker, OKBuilt 1974 · S/N 75-30742N4185MRoom Nine LLC · Casper, WYBuilt 1974 · S/N 18502416N4185PFlying Woody LLC · Helena, MTBuilt 1970 · S/N 185-01651N4185SJetset Aviation LLC · Helena, ALBuilt 1975 · S/N CE-575N4186TRegistered aircraftBuilt 1966 · S/N 320D0086N4187SJ&S Aviation Services LLC · Hastings, NES/N D-9765N4188SMajor Air LLC · Charleston, SCBuilt 1975 · S/N TH-620N4189SHigh Planes Holdings LLC · Lexington, NEBuilt 1975 · S/N E-676N418BMOrion Aircraft Holding LLC · Rocky Mount, VABuilt 1982 · S/N 421C1227N418DKKnies Aviation Inc · Huntsville, ALBuilt 1964 · S/N 21058435N418JCWalker Richard A · Omaha, NEBuilt 2004 · S/N 1132N418PCHajdu Paul R · Valley Center, KSBuilt 1971 · S/N 185-01843N418RMWind Sock Aviation LLC · Lancaster, KYBuilt 2005 · S/N 1719N418RWPower Aero Inc · Scituate, RIBuilt 1978 · S/N TH-917N418TRAir Sunrise LLC · Mountain View, CABuilt 1982 · S/N 340A1525N4192ARocky Mountain Aviation Inc · Wilmington, DEBuilt 1970 · S/N D-9128N4192SStecklein Aviation LLC · Colleyville, TXBuilt 1975 · S/N D-9766N4194QJacques Jerry J · Iliamna, AKS/N U2061359N4194SKilpatrick Bryan J · Poway, CABuilt 1975 · S/N E-677N4194WNicholson Jon S · Bethel, AKBuilt 1967 · S/N 1851203N4197CAll In Aviation LLC · Townville, SCS/N 414-0513N4197SIndependence Aviation Inc · Scottsdale, AZBuilt 1975 · S/N D-9762N419CDRsk Aviation LLC · Midland, MIBuilt 2005 · S/N 1377N419STMyers Steven L · Goodyear, AZBuilt 2005 · S/N 1656N419TFLee General Management LLC · Olive Hill, KYBuilt 2006 · S/N E-3742N41ARobertson Roy E · Marion, IABuilt 1978 · S/N 21062798N41ANCampbell Ian · Miami, FLBuilt 2023 · S/N E-4153N41AYHunterdon Aviation Inc · Ringoes, NJBuilt 1978 · S/N 310R1416N41AZAlexander Peter · Palo Alto, CABuilt 1991 · S/N E-2628N41CEWhats Up Doc Aviation LLC · Alexander, ARBuilt 1978 · S/N 21062872N41DNNevels Donald L · Everton, MOBuilt 1984 · S/N DLN01N41ECTreeline Helicopters Inc · Bristol, TNS/N TH-471N41EGSal Aviation Inc · Wilmington, DEBuilt 1978 · S/N TK-75N41FROplnet LLC · Arlington, VABuilt 1972 · S/N E-371N41GDValiair Lc Trustee · Casper, WYS/N 401B-0218N41HCDkh Air LLC · Shady Shores, TXBuilt 1974 · S/N E-592N41HRTw Aviation LLC · Missoula, MTBuilt 2011 · S/N E-3946N41HTJacobs Gregory R · Pinole, CABuilt 1998 · S/N 29-0149N41LJPic Aviation Group LLC · Cornelia, GABuilt 1982 · S/N 421C1252N41LLNotjets LLC · Paradise Valley, AZBuilt 1980 · S/N E-1644N41NHHartz Norman E · Gardnerville, NVBuilt 1997 · S/N E-3139N41NRSholy Fred · Granada Hills, CAS/N 340A0488N41QCMark J Heistad · Covington, LAS/N TE-150N41SAIntegrated Design And Supply Inc · Crystal Lake, ILBuilt 2005 · S/N 1507
Back to AD 86-13-04 R3