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.

N30PHStoneman Thomas K · Friendswood, TXS/N TJ-5N30RECalifornia Aviation LLC · Fresno, CABuilt 1979 · S/N 79-30935N30RFBonsal John R · Flower Mound, TXBuilt 1978 · S/N CJ-142N30RMDaniel Warren · Naples, FLBuilt 1971 · S/N TE-828N30RPCommunications Laboratories Inc · Melbourne, FLBuilt 1982 · S/N E-2050N30RWSaltzy Seas LLC · Loxahatchee, FLBuilt 1976 · S/N 310R0667N30SLAppel Neal C · Prescott, AZBuilt 1972 · S/N E-338N30SSN30ss LLC · Dover, DEBuilt 1973 · S/N 414-0451N30TBAlbert Lea Airport Inc · Albert Lea, MNBuilt 1970 · S/N TH-74N30VGGeoterra Inc · Eugene, ORBuilt 1980 · S/N 21063856N30VMKnott Richard C · Stony Brook, NYBuilt 1973 · S/N CE-453N30VTPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1973 · S/N D-9439N30WEWest Elk Air LLC · Gunnison, COBuilt 1985 · S/N 18504432N30WGMather Christopher D · Hayward, CABuilt 1974 · S/N TE-997N30WLSkydive Coolidge Inc · Tempe, AZBuilt 1966 · S/N P206-0275N3100BLeone James Frank · Cotulla, TXBuilt 1994 · S/N CE-1789N3101TMission Air LLC · Charlotte, NCS/N 310R1877N3101WGeorge Jon A · Durango, COS/N TE-953N3102CD & D Motors LLC · Georgetown, TXBuilt 1987 · S/N CE-1179N3102WBonanza Leasing LLC · Versailles, KYBuilt 1973 · S/N D-9558N3105WDavis Kenneth D · Ft Wayne, INBuilt 1973 · S/N E-494N3106DSouth Delta Aviation Inc · West Helena, ARBuilt 1988 · S/N CE-1215N31074Hale Aviation Inc · Saint Augustine, FLBuilt 1988 · S/N CE-1210N31075Camden Group Inc · Boston, MABuilt 1988 · S/N E-2415N31084Hannah Bruce A · Anchorage, AKBuilt 1969 · S/N U2061386N3108LWickersham Brian L · Council Bluffs, IABuilt 1988 · S/N CE-1248N3108NBartlett Paul H · Nebo, NCBuilt 1988 · S/N CE-1218N3109CVicjen LLC · Bloomington, ILBuilt 1987 · S/N E-2400N3109WIII Per LLC · Lewes, DEBuilt 1973 · S/N TE-955N310ACJulie Dorst LLC · Kalispell, MTBuilt 1975 · S/N 310R0290N310ADChang Stephen · Santa Barbara, CABuilt 1976 · S/N 310R0538N310AHGraydon Bilal R · Melbourne, FLBuilt 1979 · S/N 310R1660N310AJPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1980 · S/N 310R1606N310AMCwr Enterprises Inc · Henderson, NCBuilt 1979 · S/N 310R1672N310ARHales Gutter Guys LLC · Cottonwood, AZS/N 310R1387N310BARampey Alvin H Jr · Atlanta, GABuilt 1975 · S/N 310R0065N310BFGv Air Inc · Medford, ORBuilt 1978 · S/N 310R1390N310BGFlairships LLC · Durham, NCBuilt 1977 · S/N 310R0889N310BLAlsager Joshua D · Kindred, NDS/N 310Q0069N310BUTar Heel Aviation Inc · Bonita Springs, FLBuilt 1986 · S/N 4608004N310BVExec Air Inc Of Naples · Naples, FLBuilt 1974 · S/N 310R0099N310CBN310cb LLC · Buford, GABuilt 1975 · S/N 310R0600N310CESwainston Ian · Las Vegas, NVBuilt 1974 · S/N 310Q1063N310CFSouthern Illinois University DBA · Murphysboro, ILBuilt 1975 · S/N 310R0565N310CGHoffert Stephen · Alexander, NCBuilt 1978 · S/N 310R-1304N310CJCj Marketing Inc · Saint John, INS/N 310R0223N310CKSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1980 · S/N 310R-1889N310CLSinclair Bradley W · Melbourne, FLBuilt 1981 · S/N 310R2138N310CTIcp Aviation LLC · Melbourne, ARBuilt 1975 · S/N 310R0570N310DChispa Air LLC · Cedar Park, TXBuilt 1969 · S/N 310Q0002
Back to AD 86-13-04 R3