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.

N1234ASbm Aviation LLC · Afton, WYBuilt 1980 · S/N P-535N1234BSmith Bradley T · Elizabethtown, KYBuilt 1952 · S/N D-3179N1234LRld Leasing Inc · Downers Grove, ILBuilt 1974 · S/N P-320N1234VFrailey Randy J · Chouteau, OKBuilt 1979 · S/N D-10221N1234ZPage Donald Lee Co Trustee · Mission, TXBuilt 1961 · S/N D-6695N1235CWerner Christopher Wayne · Fayetteville, GABuilt 1988 · S/N CE-1235N1235MRoan Christopher J · Jefferson, SDS/N DH-142N1236ZStackhouse Don E · Saratoga, WYBuilt 1961 · S/N D-6697N123AKOptima Aviation LLC DBA · Lewisville, TXBuilt 1973 · S/N TC-1543N123AVGc 43 LLC · Annandale, VAS/N E-319N123AZN123az LLC · Las Vegas, NVS/N EA-498N123BNickravesh Niknam · Saratoga, CABuilt 1955 · S/N D-4098N123BCBlue River Baron 58 LLC · Malcolm, NEBuilt 1977 · S/N TK-41N123CTPastor Jordan D · Riverside, CABuilt 1967 · S/N D-8590N123DGoodfrey Ronnie · Longview, TXBuilt 1961 · S/N D-6637N123ECJohnson Howard A · Lake Forest Park, WABuilt 1972 · S/N D-9412N123GBRegistered aircraftBuilt 1979 · S/N TE-1165N123GSLou Ann Inc · Los Altos, CABuilt 1979 · S/N E-1464N123JFAlto Aero LLC · Dover, DEBuilt 1974 · S/N P-284N123JJRotorwings Aviation LLC · Hebron, NEBuilt 1972 · S/N TC-1421N123JVDowning Danny L · Kilgore, TXBuilt 1955 · S/N D-4024N123MMMuller Miles O · Staples, TXBuilt 1986 · S/N E-2332N123NKLarson Ken · Escondido, CABuilt 1970 · S/N P-153N123RGChurch Brett L · Whitefish, MTBuilt 1968 · S/N D-8816N123RKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N CE909N123TCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1962 · S/N DH-339N123TWGrandy Boyd · Smoot, WYBuilt 1974 · S/N E-518N1240AAlfa Monkey LLC · Wolfforth, TXBuilt 1969 · S/N D-9028N1241ZFeatherston Jacob Eric · Ferris, TXBuilt 1961 · S/N D-6701N1244YBurbank Dennis · Arcadia, OKBuilt 1966 · S/N TE-253N124AWCyalco Aviation LLC · Spencer, IABuilt 1965 · S/N TC-942N124BZFerguson Steven L · Rawlins, WYBuilt 1961 · S/N TC-78N124DRendezvous Island Air LLC · Fort Collins, COS/N 10002N124LCBucks Air Charters Inc · Wilmington, DEBuilt 1980 · S/N E-1684N124MDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1981 · S/N TJ374N124MNMartin Bobby R · Cleburne, TXS/N D-5287N124VLeach Manuel R · Natchitoches, LABuilt 1964 · S/N TC-747N1255ZKeepem Flying LLC · Oak Point, TXBuilt 1961 · S/N D-6717N12589Eastman Gregory L · Pueblo, COBuilt 1934 · S/N 7N12590Mctaggart Briar C · Oroville, CAS/N 8N12592Shumaker Dana E · Livermore, CABuilt 1934 · S/N 12N125ARJuliet Kilo Air 1 LLC · Paradise Valley, AZBuilt 1980 · S/N EA-169N125BCrow Jerry W · Louisville, TNBuilt 1955 · S/N D-4405N125EMoir Jeffery K · Newhall, CABuilt 1960 · S/N TD-357N125LLDykstra Darren · Pacific Grove, CABuilt 1982 · S/N TJ-417N125PCRegistered aircraftBuilt 1978 · S/N D-10148N125TR Darrell Weaver Enterprises LLC · Moore, OKBuilt 1973 · S/N D-9560N125TCYoung Jeremy · Portland, ORBuilt 1975 · S/N TJ-3N1260ZFaris Isaac · Swartz Creek, MIBuilt 1961 · S/N D-6704N1264ZStellaire Alliance LLC · Fort Worth, TXBuilt 1961 · S/N D-6728
Back to AD 99-05-13 R1 WD