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.

N500DMFive Delta Mike Inc · Wilmington, DEBuilt 1987 · S/N CE-1122N500DRFox 2 Inc · West Chicago, ILBuilt 1954 · S/N G-31N500GEStevenson Anesthesia Associates Pc · Wolfforth, TXBuilt 1977 · S/N E-1130N500GGSawtooth Travel Solutions LLC · Twin Falls, IDBuilt 1990 · S/N E-2564N500GMSto Cazzo Aviation LLC · Danvers, MABuilt 1980 · S/N TC2350N500JLJet-H Inc · Oak Park, CABuilt 1991 · S/N CE-1603N500KTLincoln Land Airmotive LLC · Springfield, ILBuilt 1958 · S/N D-5662N500PFHumphries Stephen A · Kingwood, TXBuilt 1964 · S/N D-7484N500PSWing John E · Rowlett, TXBuilt 1966 · S/N TC-990N500SBKostelic Tanner · Alpena, MIBuilt 1973 · S/N E-482N500WMBim-Merle Robert W III · Piqua, OHBuilt 1961 · S/N D-6691N500WPWelker Franklin W · Agoura, CAS/N EA-582N500YEHill Clifford D · Warsaw, INBuilt 1971 · S/N TC-1399N5010CPhemister Ricky D · Breckenridge, TXS/N D-2382N5011CSimecek Keith A · Milan, MIBuilt 1950 · S/N D-2273N5012MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-882N5013BNorris Ken DBA · Sumner, TXBuilt 1955 · S/N D-4275N5014BMacpherson Sherman D · Colusa, CABuilt 1955 · S/N D-4276N5015CKrueger Hendrik Jacobus · Rockport, TXS/N D-2277N5017BBarnes Roger A · Rogers, ARBuilt 1955 · S/N D-4281N5017CFurman Tyler L · Alliance, NEBuilt 1950 · S/N D-2279N5017MNo Limits Aviation Inc · Lincoln, MTS/N ME-54N5018CDutcher Paul G · Hesperus, COBuilt 1950 · S/N D-2280N501AHOlah Gregory J · High Point, NCBuilt 1966 · S/N MB-80N501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21N501WTPeterson Floyd M · Lago Vista, TXBuilt 1979 · S/N TC-2194N50225Mayes John · Carson City, NVS/N BA-619N5024BRoduner Leroy R · Benton, KSBuilt 1955 · S/N D-4289N5025BHayes David A · Steward, ILS/N D-5003N5025WAdvanced Aircraft Engineering Inc · Amelia Island, FLBuilt 2001 · S/N EA-677N5027BWilliams Air Power Inc · Lowell, MIS/N D-4292N5028BAttorneys Flying Partnership L P · Knoxville, TNBuilt 1955 · S/N D-4294N5029BGorman Michael J · Shadow Hills, CABuilt 1955 · S/N D-4296N502BWRomero Leasing Inc · Stuttgart, ARBuilt 1992 · S/N E-2716N502DDWaller County Aviation Museum · Brookshire, TXBuilt 1960 · S/N BA-542N502MWWhite Mark S · Kilgore, TXBuilt 1958 · S/N D-5606N502TJBasden Richard A · Dallas, TXBuilt 1973 · S/N CE-468N5031BBurkle Roberto E · Bullard, TXBuilt 1955 · S/N D-4298N5032CGann Mark E · Springfield, MOBuilt 1950 · S/N D-2294N5032MLet There Be Flight LLC · Portage, MIBuilt 1978 · S/N MB-896N5034CCoen Rayce P · Wiley, COBuilt 1950 · S/N D-2296N5035BBohdan Lebid · Roscoe, ILS/N D-4312N5036BHassan Richard · Ogden Dunes, INBuilt 1955 · S/N D-4303N5036CPilot & Co Aviation LLC · Artesia, NMFirst renewal noticeBuilt 1950 · S/N D-2298N5036M66ee LLC · Santa Barbara, CABuilt 1978 · S/N E-1255N5037BBaum Benjamin · Magnolia, MNS/N D-4314N5038BWells Propane Inc · Wells, NVBuilt 1955 · S/N D-4321N5039BHaring Clay · Lincoln, KSBuilt 1955 · S/N D-4306N5039CGreedy Michael L · Carson City, NVBuilt 1950 · S/N D-2301N5040BFarley Steven D · Newalla, OKBuilt 1955 · S/N D-4307
Back to AD 99-05-13 R1 WD