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.

N3502RWisner Francis J · China, MIBuilt 1965 · S/N M-652N3503BWelsh Steven M · Oxford, NCBuilt 1954 · S/N D-3721N3507RLoose Keith · Saint Helens, ORS/N M-662N3509BBeauchamp William J · Rigby, IDBuilt 1954 · S/N D-3726N350BShaffer Benjamin C · Adair, OKBuilt 1957 · S/N D-4905N350HAims Community College · Greeley, COS/N D-8188N350NEMaresco International Corp · Alpha, NJBuilt 1980 · S/N D-10351N350NWBas Part Sales LLC · Greeley, COBuilt 1977 · S/N CE-753N350TBStephenson Richard J Trustee · Wheeling, ILBuilt 1973 · S/N E-413N350YRSilverman Kenneth · Pelham, NHBuilt 1982 · S/N D-10383N3511VCypress Creek Shooting Lodge LLC · Greenbrier, ARBuilt 1980 · S/N D-10353N3512BSkb Aviation LLC · Moreland Hills, OHBuilt 1954 · S/N D-3729N3514BHabenicht Duane E · Berrien Center, MIS/N D-3731N3514RElkinton Dustin L · Moundville, MOS/N M-666N3515RJameson John M · Enid, OKBuilt 1965 · S/N M-671N3517AMunoz Pedro L · Ontario, NYBuilt 1969 · S/N TC-1305N3518RSchlaudt William R Jr · Lufkin, TXBuilt 1965 · S/N M-670N3519RCaskey Kenneth P · Roanoke, TXFirst renewal noticeS/N M-673N351ATRegistered aircraftBuilt 1967 · S/N D-8507N351JPParker Robert · Oklahoma City, OKBuilt 1976 · S/N TJ-51N351PLifted Six Aviation LLC · Wilmington, DEBuilt 1962 · S/N D-6919N351PLBender Cliff · Plano, ILBuilt 1964 · S/N D-7302N351RRHolder Joiy R · Port Saint Lucie, FLBuilt 1964 · S/N TC-763N351RSSmith Herschel W III Md · Roswell, GABuilt 1966 · S/N D-8299N351VBWudtke Dale A Trustee · Palos Park, ILBuilt 1970 · S/N D-9207N3522RCypret Craig P · Kingston, NHBuilt 1965 · S/N M-681N3523BSmith Terry · Atoka, TNBuilt 1954 · S/N D-3740N3524RAnderson Oluf J · Rangely, COBuilt 1965 · S/N M-684N3526ARoeder Miles · Houston, TXBuilt 1969 · S/N D-9075N3526BFreeman Lyman M · Golden Hills, CABuilt 1954 · S/N D-3743N3526RHampton Allan H · Lawton, OKS/N M-688N3527RDivine Designs Home Inc · Manorville, NYS/N M-687N352RHHackler Russell W Jr · Livermore, CABuilt 1964 · S/N D-7562N3530RWhitney Stephen William · Fort Myers, FLS/N M-685N3531RLusher Gregory N · Prichard, WVBuilt 1965 · S/N M-693N3532BPlane Crazy Aviation LLC · Hollywood, SCBuilt 1954 · S/N A-999N3536AAirborne Resources Inc · Midlothian, TXBuilt 1970 · S/N TE-775N3539RSieradzki Richard Peter · Novi, MIS/N M-707N353BBlair Aircraft No 2 LLC · Herriman, UTBuilt 1957 · S/N D-4971N353LABas Part Sales LLC · Greeley, COBuilt 1970 · S/N TC-1339N353RSecond Time Around Lt LLC · Corona, CAS/N D-10209N353RGJeffrey Jacober Aviation Consultants LLC · Cherry Hill, NJBuilt 1953 · S/N D-3551N3544RClark Lahn F · Pasco, WAS/N M-712N3549RSchaer Christopher J · Gordon, NEBuilt 1965 · S/N M-722N354ALErlandsen Alan · Bremerton, WABuilt 1960 · S/N D-6570N354BCChamberlain Donald H · Ooltewah, TNBuilt 1989 · S/N E-2485N354BWCarpenter Richard A · Hermiston, ORBuilt 1979 · S/N EA-40N354DAir Repair Inc · Deadwood, SDBuilt 1964 · S/N D-7659N354DEHomesley Jonathan Edward · Mcgregor, TXBuilt 1949 · S/N D-2077N354DGGaines Lawrence C · Stockton, CABuilt 1958 · S/N D-5573
Back to AD 99-05-13 R1 WD