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.

N233LHLetts Jackson W · Kansas City, KSS/N CE-550N233RPlane Jane Aviation LLC · Sylvania, GABuilt 1975 · S/N D9811N233SCMattoso Ricardo Q · Spicewood, TXBuilt 1974 · S/N D-9599N2340APommersheim John Mark · Dulles, VAS/N E-3182N2340BHenefeld Mark J · Milton, GABuilt 1964 · S/N D-7451N2340LRegistration Pending · San Antonio, TXRegistration pendingBuilt 1962 · S/N M-171N2340QRegistration Pending · Lewisville, TXRegistration pendingBuilt 1963 · S/N M-411N2341WSteele Benjamin A · Eugene, ORS/N M-940N2342HLakes Treatment Center Inc · Angels Camp, CABuilt 1998 · S/N EA-621N2342LWilliams James W · Brush Prairie, WABuilt 1963 · S/N M-173N2343LBailey Paul W II · Hilton Head, SCBuilt 1963 · S/N M-174N2343VWischmeyer Jason B Md · Lubbock, TXBuilt 1998 · S/N EA-616N2343WRogers Allen F · Gilbert, WVBuilt 1965 · S/N M-942N2344LSpargo Lyle R · Tonopah, AZBuilt 1963 · S/N M-175N2345LD&S Development LLC · Spring, TXS/N M-177N2345QPrunier Phillip M · Kokomo, INBuilt 1963 · S/N M-416N2345WHanisch Paul J · Crosby, NDBuilt 1998 · S/N E-3188N2346QBurt Marcus D · Pendleton, ORS/N M-425N2346WRaynor Jason M · Elizabeth City, NCS/N M-944N2346ZSoutheast Equipment LLC · Sheridan, WYS/N M-65N2347QBefumo Joesph M · Manchester, CTS/N M-451N2347VSomes Jason S · Santa Rosa Valley, CABuilt 1998 · S/N E-3147N2347ZZaitsev Saba A · Brooklyn, NYBuilt 1962 · S/N M-59N2348JArensmeyer Daniel D · Weybridge, VTBuilt 1963 · S/N M-303N2348ZHerrick Herbert D · Flint, MIBuilt 1962 · S/N M-60N2349QLedford Russell R III · Swansea, SCBuilt 1963 · S/N M-417N2349WPax Theodore Llewellyn · Fall Creek, WIBuilt 1966 · S/N M-947N2349ZUnderwood Richard R · Armuchee, GABuilt 1962 · S/N M-61N234ATr Aero LLC · Poway, CABuilt 1972 · S/N TC-1437N234ABBachteal Paul Shear · Sebastopol, CABuilt 1991 · S/N CE-1562N234ALDale James H · La Vernia, TXS/N D-4457N234APOrr Lynn E · Fredericksburg, OHBuilt 1988 · S/N CE-1232N234DHCarrell Evan Paul · Queen City, TXBuilt 1969 · S/N D-8966N234EBArbuckle James H · Bellevue, NEBuilt 1966 · S/N D-8157N234FS234fs LLC · Ponte Vedra Beach, FLBuilt 1955 · S/N 53-4132N234HWestphal Ronald R · Aurora, ILBuilt 1954 · S/N CH-133N234JEAimrich Enterprises · Wilmington, DEBuilt 1987 · S/N CE-1193N234MMalone Miles M · Camarillo, CABuilt 1963 · S/N TD-560N234MBSonday Terrance P · Red Lodge, MTBuilt 1956 · S/N BG-199N234MCStauffer Charles I · Battle Creek, MIS/N BG-411N234MGDubin Wayne M Trustee · Fort Myers, FLBuilt 1977 · S/N TE-1104N234PTJaguar Management Group LLC · Wilmington, DEBuilt 2000 · S/N EA-662N234RBMoyer Thomas L · Fayetteville, GABuilt 1976 · S/N TC-1950N234RRMaselli John F · Bay City, ORBuilt 1948 · S/N D-1727N234SDHerndon Aviation LLC · Kokomo, INBuilt 1981 · S/N EA-200N234TPBoyes Robert L · Benton City, MOS/N TG-71N234TUMid Continent Aircraft Corp · Hayti, MOBuilt 1953 · S/N G-138N234USLong Camille D · Atlanta, GABuilt 1953 · S/N D-3678N234WBDrake Colin · Mendocino, CABuilt 1969 · S/N D-8952N234WWMcadams James P · Valley View, TXBuilt 1979 · S/N CE-878
Back to AD 99-05-13 R1 WD