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.

N8420NHardy Robert C · Austin, TXS/N D-8773N8421NFagan Dan III · Murfreesboro, TNBuilt 1968 · S/N D-8785N8423NFarnham Dale E · Ames, IABuilt 1968 · S/N D-8787N8425AKeshishian Gregory · New York, NYFirst renewal noticeBuilt 1948 · S/N D1862N8425NWoods Aviation LLC · Fillmore, ILBuilt 1968 · S/N D-8790N8428NAlexander Robert W · Knoxville, TNBuilt 1968 · S/N D-8788N842BESparrow Holdings LLC · Irvine, CABuilt 1984 · S/N EA-432N842KZPowell Michael Brandon · Murfreesboro, TNBuilt 1983 · S/N M-2367N842RMutsch Craig A · Faulkton, SDBuilt 1959 · S/N D-6209N842TAkin Air LLC · Monticello, ARBuilt 1960 · S/N TD-355N8430AMontgomery Patrick E · Auburn, NYBuilt 1948 · S/N D-1844N8431ABas Part Sales LLC · Greeley, COBuilt 1948 · S/N D-1845N8434AShepard Roger C · Aberdeen, WABuilt 1948 · S/N D-1850N843AHDynamics Flight LLC · Milwaukee, WIBuilt 1984 · S/N E2190N843CMLamar Lending LLC · League City, TXBuilt 1975 · S/N E-754N843TClifford Brent N · Lubbock, TXBuilt 1973 · S/N D-9482N843TBFarwell Jesse R · Albion, NYS/N A217N8440AWeller Donald R · Kathleen, GABuilt 1948 · S/N D-1846N8441NBeasley Marty J · Statesboro, GAS/N D-8789N8449NNms Air LLC · Kalamazoo, MIBuilt 1968 · S/N D-8794N844BEJoe Koch Construction Inc · Youngstown, OHBuilt 1984 · S/N E2199N844CSSchmidt Clifford W · Jackson, MIBuilt 1970 · S/N D-9247N844HSanker Frank Trustee · Keller, TXBuilt 1991 · S/N CE-1623N844NBemidji Aviation Services Inc · Bemidji, MNS/N LF-42N844RSteele Aviation Inc · Walnut Cove, NCFirst renewal noticeBuilt 1959 · S/N D-6162N8451NCfp Corporate Finance Partners LLC · Newport Beach, CABuilt 1968 · S/N TE-571N8452AHoward Jordan Stevens · Tioga, NDS/N D-1870N8452NGottsch Joe · Salem, ORBuilt 1968 · S/N D-8808N8456ACrawford Larry G · California, MOS/N D-1874N8456NBowling Green Aviation LLC · Germantown, TNBuilt 1968 · S/N TC-1103N8457NSharon Enterprises LLC · Peralta, NMBuilt 1968 · S/N D-8809N8459NContrail LLC · Deerfield Beach, FLBuilt 1968 · S/N D-8796N845DBPierce Ryan · Longview, TXBuilt 1982 · S/N E-2044N845DKJones Curtis R · Burnsville, MNBuilt 1956 · S/N BG-179N845JBAnna Aviation LLC · Gravois Mills, MOS/N CE-719N8461ALove Larry E · Greenbrier, ARBuilt 1949 · S/N D-2012N8462NBoskind Richard · Indialantic, FLBuilt 1968 · S/N MA-321N84639American Flight Museum · Topeka, KSBuilt 1956 · S/N BG-241N8463NDc Executive Aviation LLC · Spring, TXBuilt 1968 · S/N D-8798N8465AKeys James B · Oakwood, GABuilt 1948 · S/N D-1883N8466NFrancois Paul · Aurora, COBuilt 1968 · S/N D-8800N8467ARegistration Pending · Tucson, AZRegistration pendingBuilt 1948 · S/N D-1885N846EDGoodrich Joe Chris · Crosby, TXBuilt 1953 · S/N D-3609N8476HMccole Joanne · Brookline, NHS/N BA-749N8478ABrice Staeheli · Saint Paul, MNS/N D-1898N8478NMclenaghan Alvin N · Phoenix, AZBuilt 1968 · S/N D-8805N847DDF33a Holdings LLC · Woodbridge, VABuilt 1989 · S/N E-2498N8482AEngelhart Mitchell S · Roswell, GABuilt 1948 · S/N D-1902N8483AHeller Louis T · Reno, NVBuilt 1948 · S/N D-1903N8483NFletcher Greg S Trustee · Grove, OKBuilt 1968 · S/N D-8807
Back to AD 99-05-13 R1 WD