OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N1762WWillis Frederick A · Scottsdale, AZS/N D-9410N17632Hunt Elizabeth H · Clifton, TXBuilt 1977 · S/N CE-697N17636Rocha Heriberto · Houston, TXBuilt 1977 · S/N CE-698N17639Peterson Eric S · San Jose, CABuilt 1977 · S/N E-997N1763W63 Whiskey LLC · Seattle, WABuilt 1973 · S/N E-406N17643Smith James E Trustee · Kalispell, MTBuilt 1943 · S/N 4827N17650Pynes Anthony P · Round Rock, TXBuilt 1977 · S/N D-9993N17653Coggin Randall · Longview, TXBuilt 1977 · S/N E-998N17656Liddell Patrick A · Columbia Falls, MTBuilt 1977 · S/N D-9995N1765GGivens Thomas A · Southern Pines, NCBuilt 1962 · S/N D-6964N17668Broadway Travis A · Alexandria, LABuilt 1977 · S/N E-1001N17669Srg Enterprises LLC · Montgomery, ALBuilt 1977 · S/N E-1002N17679Walton Paul L · Indianapolis, INBuilt 1944 · S/N 6911N1767WN1767w LLC · Dover, DEBuilt 1972 · S/N TC-1500N17692Starnes Robert D · Suwanee, GAS/N CE-700N17698Spindel Stuart H · Hawesville, KYBuilt 1977 · S/N E-1005N176BRegier Tom · Dinuba, CAS/N D-4509N176BCCousins Mark T · Portland, ORS/N ME-269N176DRKelly Daniel · Alpharetta, GAS/N E-3592N176LFFour Basics LLC · Olathe, KSBuilt 1977 · S/N E-1052N176STCp A36 Inc · Knoxville, TNBuilt 1976 · S/N E-884N176VBGraystoke Aviation LLC · Shepherd, MTBuilt 1976 · S/N D-9926N176WHarwell Evin Dtrustee · Howell, MIBuilt 1978 · S/N E-1335N176XClub Turbo 176 LLC · Santa Clara, CABuilt 1976 · S/N E868N17702Bosley Blake R · Richmond, TXBuilt 1977 · S/N CE-701N17703Dakota Aviation LLC · Sioux Falls, SDBuilt 1977 · S/N E-1007N17704Hall Thomas N · Dothan, ALBuilt 1977 · S/N E-1008N1770GJansen David C · Warm Springs, GABuilt 1962 · S/N TC-294N17718Katzakian Philip O · Lodi, CABuilt 1977 · S/N D-9998N17722International Jets Inc · Gig Harbor, WABuilt 1977 · S/N TC-2045N17726Air Commander LLC · Woodbury, MNBuilt 1977 · S/N TC-2046N1772WRichland Flight Academy LLC · Sidney, MTBuilt 1972 · S/N E-377N17732Wright Brian L · Franklin, TNBuilt 1977 · S/N TE-1102N17735Stoppelbein Colby · Kenansville, NCBuilt 1977 · S/N CE-703N17738Lambert Michael C · San Jose, CABuilt 1977 · S/N CE-702N1773WWade William C Trustee · Cottonwood, AZBuilt 1972 · S/N D-9413N17746Hansen Christopher Smith Sr · Surf City, NCBuilt 1977 · S/N D-10003N17747Davis 180 LLC · Baton Rouge, LABuilt 1977 · S/N CE-704N17748Montineri Joseph A · Port Orange, FLBuilt 1977 · S/N E-1017N17751Brewer Bret D · Woodward, OKBuilt 1977 · S/N D-10004N1775MN1775m LLC · Taos, NMBuilt 1950 · S/N D-2283N17764N17764 LLC · Quincy, WABuilt 1977 · S/N E-1021N17766Elworthy Steven M · Huntington Beach, CABuilt 1977 · S/N E-1023N17769Jmk Engineering Inc · Bloomfield Hills, MIBuilt 1977 · S/N E-1027N17785Registered aircraftBuilt 1977 · S/N E-1025N17790Tds Property Holdings LLC · Gilmer, TXBuilt 1977 · S/N TC-2055N17791Spuza Dan D · Sanger, TXBuilt 1977 · S/N CE-708N17794Getting Dean W · Fort Dodge, IABuilt 1977 · S/N E-1029N17797Nieman James Lewis Jr · Alhambra, CABuilt 1977 · S/N D-10010N177ABKostroski Larry J · Tucson, AZBuilt 1972 · S/N TE-873
Back to AD 99-05-13 R1 WD