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.

N8331NGlens Pilot Services LLC · Yulee, FLBuilt 1968 · S/N TC-1079N8332NMoon Kai LLC · Laguna Niguel, CABuilt 1968 · S/N D-8740N8333DRegistration Pending · Tibubon, CARegistration pendingBuilt 1958 · S/N D-5434N8334DDykes Robert W · Knoxville, TNBuilt 1958 · S/N D-5435N8336NDejong James D · Doon, IABuilt 1968 · S/N D-8737N8337NLivesay Gregory K · Mckinney, TXBuilt 1968 · S/N D-8739N8338HBayviewer LLC · Sarasota, FLS/N EA-399N8339NMekolik Aaron S · College Station, TXBuilt 1968 · S/N D-8746N833DMitchell Darrin · Tabor, IABuilt 1970 · S/N MC-12N833LBristell Aircraft LLC · The Villages, FLBuilt 1967 · S/N TD-710N833PBSoutheast Flyers LLC · Jackson, MOBuilt 1986 · S/N E2338N833PMLonely Luggage Delivery Inc · Arroyo Grande, CABuilt 1979 · S/N CE-857N833QShiloh Aviation LLC · Ramer, TNBuilt 1960 · S/N DH-290N833TDTdu Investments LLC · Lewiston, IDBuilt 1998 · S/N CE766N833TXN833tx LLC · Little Rock, ARBuilt 1978 · S/N TJ-153N834Hydro Flyers LLC · Woodside, CABuilt 1952 · S/N G-62N8342DTexas Logos LLC · Lometa, TXBuilt 1958 · S/N D-5487N8343NWavra Mark F · East Grand Forks, MNBuilt 1968 · S/N D-8741N8346DRegistered aircraftBuilt 1958 · S/N D-5447N8348DSanders Tyler A · Austin, TXBuilt 1958 · S/N D-5461N8349DSorenson Steve A · Cody, WYBuilt 1958 · S/N D-5441N834KTChambers Garland M · Roanoke, VABuilt 1974 · S/N M-1512N834TMStoelt William L · Lynden, WABuilt 1964 · S/N D-7433N8350DBas Part Sales LLC · Greeley, COBuilt 1958 · S/N D-5444N8351DDotson Eric E · Wagoner, OKBuilt 1958 · S/N D-5433N8353NLindahl Jonathan · Cary, ILBuilt 1968 · S/N D-8756N8356NNielson Frederick P · Mesquite, NVS/N D-8744N8357DQuinn Robert F · San Mateo, CABuilt 1958 · S/N D-5470N8358DAskelson Eldon L · Meridian, IDBuilt 1958 · S/N D-5524N8358NQuam Contracting LLC · Creston, IAS/N D-8751N8359NHendricks Flying Service LLC · Imperial, NEBuilt 1968 · S/N D-8753N835BBusigin Tikhon · Ocala, FLBuilt 1958 · S/N D-5508N8360DSanders Dean L Trustee · Nordland, WABuilt 1958 · S/N D-5481N8360NYost Rawson · Watertown, SDBuilt 1968 · S/N D-8755N8361DRiker Richard · East Falmouth, MABuilt 1958 · S/N D-5471N8364DElliott Areospace LLC · Kalispell, MTBuilt 1958 · S/N D-5475N8366DPage Howard G · Burlingame, CABuilt 1958 · S/N D-5485N8367DAg-Monkey Inc · Norris City, ILBuilt 1958 · S/N D-5474N8367NSearch Septic · Bailey, COBuilt 1968 · S/N D-8749N8369DPalmer Paul H · Marshall, TXBuilt 1958 · S/N D-5493N836EVoss Danielle · Dover, NHBuilt 1982 · S/N E-2059N836JBReis James C · Lake Ozark, MOBuilt 2000 · S/N E3312N836KTAirhawks Flying Club · Eastsound, WABuilt 1978 · S/N M-2047N836LGFly A36 LLC · Browntown, WIBuilt 2001 · S/N E-3405N836RCoates Stephen T · Roseville, CABuilt 1959 · S/N D-6252N836TPSale Reported · BristolSale reported, pending cancellationBuilt 1984 · S/N E-2124N8370DJones Richard P · Mukilteo, WABuilt 1958 · S/N D-5463N8371NDecision Air Corp · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N D-8758N8372DBuford Phillip N · Bethesda, DCBuilt 1958 · S/N D-5492N8372NRudolph Pam G Trustee · Lake Havasu City, AZBuilt 1968 · S/N D-8759
Back to AD 99-05-13 R1 WD