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.

N7024KMcneill Steven H · Santa Fe, NMS/N 6870N70283J And D Petroleum Co · Tallahassee, FLBuilt 1965 · S/N TF45N702DDJoyce Consulting LLC · Black Hawk, SDBuilt 1999 · S/N EA-644N702DLBohlke LLC · Kingshill, VIBuilt 1966 · S/N TE-136N7034ERange View Investments LLC · Austin, TXBuilt 1962 · S/N LF-49N703BNassour Aviation Inc · Ellisville, MSBuilt 1948 · S/N D-1708N703JMToller Kevin K · Broken Arrow, OKBuilt 1971 · S/N E-278N703THall Charles M · Lubbock, TXBuilt 1975 · S/N D-9816N7044NExplore Lake Lure LLC · Miami, FLBuilt 1967 · S/N TE-472N7045NIndy Air Sales LLC · Anderson, INBuilt 1967 · S/N D-8633N7046NMoore John Robert III · Lusby, MDBuilt 1967 · S/N D-8634N7048NBonanza Enterprises LLC · Mill Valley, CABuilt 1967 · S/N D-8636N7049NJ M Williams LLC · Stockton, CAFirst renewal noticeBuilt 1967 · S/N D-8638N704BAiron2 LLC · Austin, TXBuilt 2001 · S/N E-3372N704CCMorris Kevin J · Ross, CABuilt 1964 · S/N TC-678N704QSinor Delbert · Ozark, MOBuilt 1956 · S/N D-4883N704YBMelon Eric H · Chalfont, PABuilt 1968 · S/N TC-1156N7050NGuy Darrell G · Marietta, GABuilt 1967 · S/N D-8645N7053NNames Loch K · Eugene, ORBuilt 1967 · S/N D-8646N7055MPaul John · Hamilton, MTS/N LH174N7058NAeroplanes2 LLC · Indianola, IABuilt 1967 · S/N D-8640N705BBox William C · Goldsby, OKS/N D-1710N705FSHvl Construction Inc · Fresno, CABuilt 1994 · S/N E-2836N7068NWashburn Donald Kevin · Reidsville, NCS/N TE-480N7069NLindley Robert F · Williamson, GABuilt 1967 · S/N D-8658N706BCazares Tyler A · Weldon, CAS/N D-1711N706CMSquibb Jeffrey T · Elizabeth, PABuilt 1959 · S/N D-6173N7071XBlackwell Aviation Inc · Belle Vernon, PABuilt 1955 · S/N BG-36N7072NDesrosiers Stefan · Scotch Plains, NJBuilt 1967 · S/N D-8648N7073NOlson Steven E · Lakeville, MNBuilt 1967 · S/N D-8650N7075NSign Zeppelin LLC · Orlando, FLBuilt 1968 · S/N D-8733N707AJRandy Goering Inc · Bend, ORBuilt 1979 · S/N E-1499N707BRCawood William Richard · Mountain Rest, SCBuilt 1966 · S/N D-8312N707CHCharlie Hotel LLC · Madisonville, TNBuilt 1957 · S/N D5294N707CPBaron Aviation LLC · Jesup, IABuilt 1965 · S/N TC-864N707DJSun City Aviation LLC · Davie, FLBuilt 1980 · S/N ME-367N707GDw Forensics LLC · Dallas, TXS/N M-2248N707LHoon David M · Wolf Creek, MTBuilt 1968 · S/N D-8731N707LJFront Row LLC · Los Alamos, NMBuilt 1979 · S/N EA-4N707MPEmmet Street Holdings LLC · Saint Petersburg, FLBuilt 1978 · S/N TJ-166N707RCFitzpatrick Sturgill Heather L · Edmonds, WAS/N D-5730N707RDJones Alonzo · Los Angeles, CABuilt 1974 · S/N D-9708N707TToth Michael · Wadsworth, OHBuilt 1976 · S/N E-861N707TSShortt Aircraft Leasing LLC · South Lyon, MIBuilt 1981 · S/N P-564N707WSIsland Air Leasing LLC · Columbus, OHBuilt 1974 · S/N TC-1803N707ZHawley Elizabeth B · Wichita Falls, TXBuilt 1981 · S/N E-1978N7082NJasmin Grant Frederick Jr · East Palo Alto, CABuilt 1967 · S/N D-8661N7083NCollins John D · Charlotte, NCBuilt 1967 · S/N D-8663N7085NMustain Robert G · Graham, WAS/N TE-504N708DForsyth Technical Community College · Winston Salem, NCS/N D-2980
Back to AD 99-05-13 R1 WD