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.

N4013KNurge Richard J · Gilroy, CAS/N 6885N4015AOvad David Mark · Reisterstown, MDBuilt 1970 · S/N CE-297N4015TBauries Brian W · Abilene, TXBuilt 1968 · S/N M-1122N4018TMalfaro William J · Boyertown, PABuilt 1968 · S/N M-1125N401AESmith Jay D · Shreveport, LABuilt 1976 · S/N E865N401BMorrison Richard L Trustee · Anchorage, AKBuilt 1978 · S/N TC-2164N4028EAmerican Airpower Museum · Farmingdale, NYBuilt 1956 · S/N BG-292N4028GUnited States Navy (Owner) · Millington, TNBuilt 1955 · S/N BG-9N402EASneed Leasing LLC · Nashville, TNBuilt 2001 · S/N E-3402N402JSShelco Investments LLC · Las Vegas, NVBuilt 1971 · S/N P175N402PWalker Mickey R · Sun City, AZBuilt 1992 · S/N CE-1671N403SACalk Mark C · Troy, ALBuilt 2001 · S/N E-3407N4042ARogden Aviation Inc · San Rafael, CABuilt 1970 · S/N D-9102N4043AByard Jeffrey G · Carson City, NVBuilt 1970 · S/N D-9103N4045AWdw Aviation Leasing Inc · Knoxville, TNBuilt 1970 · S/N D-9104N404HMid Atlantic Air Museum · Reading, PABuilt 1961 · S/N BA-590N404LFHicks Michael P Jr · Wallis, TXBuilt 1974 · S/N E-588N404MDDent Thomas E · Moses Lake, WABuilt 1964 · S/N D-7437N404PKlump Aviation LLC · Hutto, TXBuilt 1993 · S/N E-2792N404TGreatest Generation Naval Museum · Colorado Springs, COBuilt 1959 · S/N BA-432N404VDevine Timothy P · Roseville, CABuilt 1962 · S/N D-6981N4056SAvery Judy J Executor · Plainfield, ILBuilt 1974 · S/N E-617N4059SKramer Harvesting LLC · Johnson, KSBuilt 1974 · S/N D-9705N4061SHammerstrand John A · La Mesa, CAS/N E-619N4065SAlpha 3 LLC · Newcastle, OKBuilt 1975 · S/N TE-1025N406TLevel Wings LLC · Jefferson City, MOBuilt 1966 · S/N D-8240N406WCCebulski Wade E · Seeley Lake, MTBuilt 1964 · S/N D-7723N4071SDuke Boys LLC · North Sioux City, SDBuilt 1975 · S/N P-324N4074SOverbeck John T · Excelsior, MNFirst renewal noticeBuilt 1975 · S/N CE-554N4077AFarmer Gary E · Saint Augustine, FLBuilt 1970 · S/N D-9109N4077SRiedesel Lynn R · Brookings, SDBuilt 1975 · S/N E-638N4079ABrockhoff Jonathan Allen · Sanford, NCBuilt 1999 · S/N E-3279N407CBLanham Kelty R · Fresno, CABuilt 1974 · S/N E-511N407DMPhillips Consulting Group Inc · Wilmington, DEBuilt 1990 · S/N EA-507N407JCPlane Partners LLC · Newton, MABuilt 1982 · S/N E-2033N407PCOversquare LLC · Norman, OKBuilt 1996 · S/N E-3032N407TVolunteer Aerials LLC · Stanley, NCBuilt 1966 · S/N TE-231N4080SCosse John J Jr Trustee · Lenexa, KSBuilt 1975 · S/N D-9728N4083A4083a LLC · Wilmington, DES/N D-9110N4084Dailey Garrett C · Alamo, CABuilt 1960 · S/N BG-391N4084CKrech Gordon L · Rolla, NDBuilt 1979 · S/N D-10184N4084SDavenport Michael · Naperville, ILBuilt 1975 · S/N D-9729N40855Covey Stephen B · Manvel, TXBuilt 2000 · S/N E-3298N4086APippert James R · Dysart, IABuilt 1970 · S/N D-9112N4086S80'S Associates Inc · Pittstown, NJBuilt 1975 · S/N D-9731N4089SRaii3 LLC · Lewes, DEBuilt 1975 · S/N D-9732N408FAGregory Carrillo Inc · Glendale, AZBuilt 1977 · S/N P-434N408JCN408jc LLC · Scottsdale, AZBuilt 1977 · S/N E-1194N408THKestrel/Hyline · West Des Moines, IABuilt 1955 · S/N BA-110N4090SByerly Brooks · Plano, TXBuilt 1975 · S/N E-645
Back to AD 99-05-13 R1 WD