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.

N3366CPorter Timothy D · Saint Cloud, MNS/N D-4033N3367Klaasmeyer Construction Co · Conway, ARBuilt 1966 · S/N TE-146N336CABergeron Machine Shop Inc · Abbeville, LABuilt 1998 · S/N EA613N336CBBeechair LLC · Helena, MTBuilt 2002 · S/N E-3431N336HPChs Acquisitions Inc · Dallas, TXBuilt 1989 · S/N CE1312N336LMKlm Unlimited Inc · Staples, MNS/N E-1587N336MLobo Air LLC · Carefree, AZS/N E-3528N336MTNorth Peak Aviation LLC · Waunakee, WIBuilt 1999 · S/N E-3265N336NANickravesh Niknam J · Saratoga, CABuilt 1980 · S/N E-480N336PWCajan LLC · Kings Mountain, NCBuilt 1982 · S/N EA-297N336RDByone Steve · Natchitoches, LABuilt 1996 · S/N E-3008N336TTophatter85 LLC · Kirksville, MOBuilt 1978 · S/N E-1219N336ZGoodman Michael R · New Brighton, PABuilt 1960 · S/N D-6489N3372CJohnson Scott L · Warrenton, GABuilt 1955 · S/N D-4039N3374VPalotas Anne M · Napa, CABuilt 1955 · S/N D-4042N3376CGrieshaber Paul M · Catawba, NCBuilt 1955 · S/N D-4043N3381CCarol Corp · Lincoln, NES/N D-4048N3389MRoberts Roger W Trustee · Wichita, KSBuilt 1989 · S/N CE-1412N338ACTruesdell Ronald W · Edgewater, FLBuilt 1954 · S/N D-3832N338D38 Delta Corp · Killington, VTBuilt 1987 · S/N E-2392N338HPN338hp LLC · Omaha, NEBuilt 1993 · S/N CE-1724N338JFElkins Quentin D · Andersonville, TNBuilt 1957 · S/N D-5401N338MGEjdeha LLC · Boston, MABuilt 1989 · S/N CE-1325N3390CMelton Jason F · Bennington, INBuilt 1955 · S/N D-4057N3393CKretzler Garrett A · Xenia, OHBuilt 1955 · S/N D-4060N3394CDobson International Parts Inc · Rantoul, KSS/N D-4061N3395CCarre Franki · Loveland, COBuilt 1955 · S/N D-4062N3396CMclenaghan Alvin N · Phoenix, AZS/N D-4064N33ANeo Terra Aviation LLC · Setauket, NYBuilt 1988 · S/N CE-1222N33CVMaintain Aviation LLC · Pomona, MOBuilt 1992 · S/N CE-1678N33DHHarrington David · Lake Saint Louis, MOBuilt 1966 · S/N MB-4N33EBAllardice John M Jr · Seneca, SCS/N D-4046N33EJReinke Bradley H · Pascagoula, MSBuilt 1993 · S/N CE-1721N33FSBvd Inc · Yates Center, KSBuilt 1974 · S/N D-9658N33FXDougfly Inc · Malibu, CAS/N D-10105N33GKDugger Glenn · Denton, TXBuilt 1990 · S/N CE-1468N33HMSands Daniel N · Los Lunas, NMS/N D-5115N33HTGroove LLC · Afton, VABuilt 1965 · S/N D-7885N33JLJ L Flyers LLC · Orinda, CABuilt 1968 · S/N D-8764N33JPScenic Flight Adventures LLC · Coeur D Alene, IDBuilt 1954 · S/N A-998N33JSBroughton Corp · Newtown Square, PABuilt 1976 · S/N CE664N33KKMcguiness Construction Inc · Ramona, CABuilt 1990 · S/N E-2528N33KMEckles Aircraft LLC · Weslaco, TXBuilt 1960 · S/N BA-534N33KSMeggers Roger D · Baker, MTBuilt 1987 · S/N CE-1142N33LPA&H Services LLC · Danville, GAS/N E-1787N33MKFessele Martin · Bridgewater, NJBuilt 1990 · S/N CE1478N33MNIts Plane Fun LLC · Sanford, FLBuilt 1962 · S/N TC-241N33MUKteg LLC · Bridgeport, TXBuilt 1993 · S/N CE-1742N33MY3 Wings LLC · Highland, MIBuilt 1987 · S/N CE-1160N33PCFrisbee Dennis R · Denton, TXBuilt 1966 · S/N TE-77
Back to AD 99-05-13 R1 WD