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.

N62PLTjwg Inc · Grandville, MIBuilt 1980 · S/N TJ-282N62RJB E Hassett Millwrights Inc · Harrods Creek, KYBuilt 1987 · S/N CE-1203N62SK55x LLC · Kalispell, MTS/N P21000096N62TCRegistered aircraftBuilt 1998 · S/N EA624N62TFLinares Rafael · Palatine, ILS/N 29-0188N62VMAerolife Aviation LLC · Knox, INBuilt 1986 · S/N 46-8608008N6300PSchrempp Aviation LLC · Winnemucca, NVBuilt 1978 · S/N P21000166N6301XRonald A Peterson Inc DBA · Orlando, FLBuilt 1978 · S/N 340A0472N63026Hacker Jr Delbert M · Granbury, TXBuilt 1984 · S/N 84-30989N6303BUpper Valley Aero LLC · Hanover, NHBuilt 1978 · S/N 21062741N6303XNelson Stephen C · Niwot, COS/N 340A0474N6304UHutt Aviation Inc · Minden, NVBuilt 1985 · S/N 21064932N6304XAndriopulos Salguero Inc · Hialeah, FLBuilt 1978 · S/N 340A0475N6305XMurray Co · Compton, CABuilt 1978 · S/N 340A0476N6306CLongs Air Conditioning Inc · Avon Park, FLBuilt 1980 · S/N 21063860N6307BCarpenter Alan B · Wasilla, AKBuilt 1979 · S/N 18503742N63083Kearney Charles B III · Argyle, TXBuilt 1984 · S/N 84-30992N6308HAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 20700476N6309XWillis Darren · Colorado Springs, COBuilt 1982 · S/N E-2015N6309YChristensen Derek Jay · Rancho Cucamonga, CABuilt 1982 · S/N CE-996N630ADT Machine LLC · Livingston, MTBuilt 1977 · S/N 421C0406N630CDDanoair LLC · Easton, MDS/N 0962N630JLGilday Aviation LLC · Hamilton, OHBuilt 1976 · S/N E-821N630MDDeh Inc · Topeka, KSBuilt 2005 · S/N 1269N630PLSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1981 · S/N 340A1224N630RWMansfield Heliflight Inc · Milton, VTS/N TE-824N630SUWinchester Jerry L · Nichols Hills, OKS/N D-9022N6310CLosasso Allen S · Scottsdale, AZBuilt 1982 · S/N E2020N6310VEagle Air US Inc · Eau Claire, WIBuilt 1982 · S/N E-2021N6311XMatts Cats LLC · Osceola, WIBuilt 1978 · S/N 340A0482N6311ZBullington Jack S · Aiken, SCBuilt 1982 · S/N CE-997N6314CC4p LLC · Jackson, TNFirst renewal noticeBuilt 1980 · S/N 21063861N6314DSaghafi Jamsheed Trustee · Parma, OHBuilt 1978 · S/N 21062938N6314ZWilliam T Murphy Investigations Inc · Stillwater, MNBuilt 1985 · S/N 85-30996N6315XEagle Aviation LLC · Morristown, TNBuilt 1981 · S/N 421C1003N6316VGardoski Mark · Dayton, NVS/N 87-30998N6316XLear Traase Kj · Roundup, MTS/N 340A0487N6318BCenturion Associates 2 LLC · Elgin, SCBuilt 1978 · S/N 21062745N6318STilbury Mitchell Allen · Blaine, MNBuilt 1975 · S/N D-9829N6319UCurtis Robert Caston · Napa, CABuilt 1982 · S/N E-2024N6319XWilliver Troy Lyn · Sherwood, ORBuilt 1978 · S/N 340A0490N631SAN631sa LLC · Wellington, FLBuilt 1999 · S/N E-3231N631TADiamond R Aviation LLC · Canyon, TXBuilt 1999 · S/N E-3267N6320PSims Jacob Trustee · Montrose, COBuilt 1978 · S/N P21000168N6321CBdp Solutions LLC · Monroe, GABuilt 1982 · S/N E-2025N6321XLee Aero LLC · Wichita, KSBuilt 1982 · S/N E-2026N6322ACustis James G · Denver, COBuilt 1982 · S/N CE-998N6325X4r Ventures Lc · Clive, IABuilt 1982 · S/N E-2027N6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDBuilt 1980 · S/N 21063865N6328EFlies & Floats LLC · Baton Rouge, LABuilt 1980 · S/N 18504025
Back to AD 86-13-04 R3