OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,498

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.

N1487CDuley Brian · Lago Vista, TXBuilt 2003 · S/N 0571N148PRJaspar Dorsey E · Bakersfield, CABuilt 1967 · S/N D-8580N148SWHess Daniel A · Cookeville, TNBuilt 2004 · S/N 0987N148TSLazy Dog Aviation LLC · North Myrtle Beach, SCBuilt 2005 · S/N 1451N148UUpmeyer Matthew D · Richland, WABuilt 1967 · S/N D-8437N14908Reiter Scott D · Leesburg, VABuilt 1974 · S/N 74-30662N14909Johnson Bruce M · Schertz, TXBuilt 1973 · S/N 74-30626N1490CCloudsurfers LLC · Goreville, ILBuilt 2003 · S/N 0507N1492CArrow Aviation Partners LLC · Crown Point, INBuilt 2003 · S/N 0567N1493MOverly Terrence L · Tok, AKS/N U20601493N1494CFour C'S Equipment Leasing LLC · Fresno, CABuilt 1978 · S/N 21063065N149ARB-Cat Aviation LLC · Tulsa, OKBuilt 1983 · S/N 414A1006N149BDLewellyn Jim · Bloomsburg, PABuilt 1976 · S/N D-9924N149GMetro Flyers Ltd · N Richland Hills, TXBuilt 1966 · S/N D-8100N149RBest Erectors Inc · Wilmington, DEBuilt 1978 · S/N D-10161N14ACLippert Bradley W · Crawford, COBuilt 1997 · S/N 29-0117N14ARRatliff Alvin · Northport, ALBuilt 1975 · S/N CE-561N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562N14CLValiair Ltd Co Trustee · Casper, WYBuilt 2003 · S/N L2K-203N14CMGallagher Michael S · Los Alamitos, CABuilt 1971 · S/N D-9298N14CXVortac LLC · Traverse City, MIBuilt 1988 · S/N 4608107N14EXSorpresa LLC · Salem, ORS/N 15N14FMDurbin Gregory M · Dallas, TXS/N D-7802N14JDC340-340 LLC · Pinckney, MIBuilt 1974 · S/N 340-0340N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792N14JHRegistered aircraftBuilt 1998 · S/N TH-1845N14JPDakota Aircraft Inc · Pierre, SDBuilt 1986 · S/N CJ-177N14LRGolly Laura · Deridder, LABuilt 1974 · S/N E-524N14LVSmetana Louis V III · Blair, NEBuilt 1970 · S/N 21059259N14MBJackson Craig D · Idaho Falls, IDBuilt 1977 · S/N E-1062N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N14PHHuman Lee · Mercer Island, WABuilt 1981 · S/N 18504323N14RFBerry Darrel · Camden, TNBuilt 1973 · S/N E-486N14XMMedical Diagnostic Imaging Inc · Sacramento, CABuilt 1976 · S/N TH-758N1500BElectrical Field Services Inc · Huffman, TXBuilt 1994 · S/N CE-1768N1500G5 Lg LLC · Rome, GABuilt 1975 · S/N 414-0814N1500VTessem Rolfe S · Great Barrington, MABuilt 1970 · S/N D-9160N1501CUnderwriting Wave LLC · Woodland Hills, UTBuilt 2003 · S/N 0528N1503UAmerican Jet Center Inc · Chino, CABuilt 1973 · S/N U20602228N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212N150CFDesutter S Bryan · Manito, ILBuilt 1980 · S/N 340A1215N150DRVan Den Heuvel Michael E · Middleton, WIBuilt 1990 · S/N CE-1473N150SCAnderson Thomas R · Seattle, WABuilt 1973 · S/N U20601958N150WRWhiskey Romeo LLC · Timnath, COBuilt 1969 · S/N D-8911N1510GGmr Leasing LLC · Lincoln, DEBuilt 1974 · S/N 421B0606N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217N1512WBryant John Mark · Knoxville, TNBuilt 1972 · S/N D-9332N1514BLilu LLC · Siloam Springs, ARBuilt 1988 · S/N CE-1276N1515MSurecraft LLC · Dover, DEBuilt 1988 · S/N CE-1304
Back to AD 86-13-04 R3