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.

N1964ARex Air LLC · Madisonville, LABuilt 1993 · S/N E-2822N1965SN1965s LLC · Williamstown, NJBuilt 1964 · S/N D-7653N1965TWeld Kenneth Jr DBA · Port Orange, FLBuilt 1964 · S/N D-7543N1965ZBushwack Air Inc · Phoenix, AZBuilt 1965 · S/N D-7805N1966DKing Kevin L · Anaheim, CABuilt 1952 · S/N D-3249N1966WSale Reported · Southaven, MSSale reportedS/N MB-630N1967WNovotny Andrew T · Los Angeles, CABuilt 1974 · S/N MB-656N1968DBellamy Inc · Three Forks, MTBuilt 1968 · S/N TE-576N1970NDaniel Arthur D · Fishtail, MTBuilt 1969 · S/N E-186N1970SKeith Gregory A · Dade City, FLBuilt 1969 · S/N TC-1302N1973Registered aircraftBuilt 1972 · S/N TE-886N1974DN822js LLC · Norcross, GABuilt 1973 · S/N E-493N1974WObannon Michael Verlin · Apple Valley, CAS/N MB-633N1975ADayspring Aviation LLC · Bend, ORBuilt 1976 · S/N E-860N1975DAlsworth Cinimin Sea · Anchorage, AKBuilt 1952 · S/N D-3172N1975KFly By Night Management LLC · Downers Grove, ILBuilt 1974 · S/N D-9715N1976DRobertson William Jr · Powell, TNBuilt 1956 · S/N D-3190N1978DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1952 · S/N D-3177N1978SWatson Jeffry T · Colorado Springs, COBuilt 1976 · S/N CE-640N1979Whitley Jason · Southlake, TXBuilt 1979 · S/N E-1568N1979DRoberts Lawrence A Trustee · Fishersville, VABuilt 1952 · S/N D-3200N1979WLeedom David · Center Point, IAS/N MB-658N197BDill Jeffrey R · Pleasant View, TNBuilt 1956 · S/N D-4527N197CANighthawk Air Systems Inc · Miami, FLBuilt 1965 · S/N LD-246N197DHHintz Donald C · Punta Gorda, FLBuilt 1997 · S/N E-3084N197FMGainey Mark P · San Antonio, TXBuilt 1987 · S/N CE-1131N197LAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1947 · S/N A-361N197QUrban Andrew W · Sun Prairie, WIBuilt 1965 · S/N D-7930N197RDean Clay · Cleveland, TXBuilt 1974 · S/N E520N1983LWindsor Aero Holdings LLC · Columbia, SCBuilt 1976 · S/N M-1841N1983WTailwinds LLC · Houston, TXBuilt 1988 · S/N E-2423N1984DFoster Buell M · Yucca Valley, CABuilt 1952 · S/N D-3215N1985CCollins Bruce J · Caldwell, TXS/N D-7438N1986DWolfe Thomas V · Mountain Lakes, NJBuilt 1952 · S/N D-3220N1986LPhillips Alan K · Junction City, ORBuilt 1976 · S/N M-1843N1987LBig Bend Community College · Moses Lake, WABuilt 1976 · S/N MB-806N1987WWood Wilbur L · Alachua, FLBuilt 1974 · S/N MB-663N1988LPortal Planes LLC · Knoxville, TNS/N M-1842N1989LTriple D LLC · Scotland, PAS/N M-1847N198CAKatla Aviation LLC · Atlanta, GABuilt 1980 · S/N ME-262N198STaylor Quarter Circle T Ranch Llp · Taylor, NEBuilt 1978 · S/N E-1161N1990WObsidian Defense LLC · Tampa, FLBuilt 1974 · S/N MB-668N1991DCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1952 · S/N D-3250N1991LHarvatine Francis J · Sykesville, MDBuilt 1976 · S/N MC-431N1991WGmm Records Inc · Big Pine Key, FLBuilt 1974 · S/N MB-673N1992WMcdonald Gregory S · Mena, ARS/N MB-657N1993DSale Reported · Summer Shade, KYSale reportedBuilt 1952 · S/N D-3256N1995DAment Robert · Merritt Island, FLBuilt 1952 · S/N D-3265N1996WMelton Joshua D · Mitchell, INBuilt 1974 · S/N MB-677N1998DLundberg Cole M · Junction City, WIBuilt 1952 · S/N D-3263
Back to AD 99-05-13 R1 WD