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.

N2320WThompson Robert J · Irwin, PABuilt 1966 · S/N MB-2N2321LHill Tim C · Savannah, GABuilt 1963 · S/N M-147N2321QHarkness James D · Locust Grove, VABuilt 1963 · S/N M-385N2321WBarre Fly Aviation LLC · Bryan, TXBuilt 1965 · S/N M-920N2323AOutdoorsmans Dream LLC · Kalispell, MTBuilt 1969 · S/N D-9032N2323ECherokee Beech Boys LLC · Kennesaw, GABuilt 1998 · S/N E3187N2324AFst Aviation & Logistics LLC · Sheridan, WYBuilt 1997 · S/N E-3124N2324L2324l LLC · Sharpsburg, GABuilt 1963 · S/N M-150N2324WTolhurst Bruce Clinton · Silver City, NMBuilt 1965 · S/N MA-1N2325QPoitras Don T · Cary, NCBuilt 1963 · S/N M-389N2326AValcourt Robert F · Chicopee, MABuilt 1998 · S/N E-3165N2327AN2327a LLC · Murrells Inlet, SCBuilt 1997 · S/N E-3127N2328ZEagle Richard R · Catawba, NCBuilt 1962 · S/N M-31N2329LJessup Gordon J R · White Plains, NYBuilt 1963 · S/N M-160N2329WSwonke Adam J · Spring, TXBuilt 1966 · S/N MB-20N232FXAvp II LLC · Winnetka, ILBuilt 1993 · S/N E-2772N232JBLundell Plastics Corp · Odebolt, IABuilt 1973 · S/N CE-448N232NTorbett Michael G · Lakeway, TXBuilt 1981 · S/N CE971N232WVLewis And Clark Adventures LLC · Lewes, DEBuilt 1994 · S/N E-2906N2330WLarsen Bo · Portland, ORBuilt 1965 · S/N M-927N2331JTechnical Education Services Inc · Virginia Beach, VABuilt 1963 · S/N M-284N2331WEmpire Contractors · Shelby, MIBuilt 1965 · S/N M-928N2331ZDovetail Aviation LLC · Saint George, UTBuilt 1962 · S/N M-41N2332JDon M Barron Contractor Inc · Farmerville, LABuilt 1999 · S/N E-3262N2333QLawarch LLC · Hollywood, FLBuilt 1963 · S/N M-399N2333VTytan Holdings LLC · Kalispell, MTBuilt 1998 · S/N E-3183N2333WVillage Of Choudrant · Choudrant, LABuilt 1965 · S/N M-932N2334LDupuy Christopher R · Pass Christian, MSBuilt 1963 · S/N M-165N2334QBledsoe Timothy Ronald Jr · Woodstock, GABuilt 1963 · S/N M-396N2334WBlazek James T · Malta, ILBuilt 1997 · S/N E-3134N2335JDank Noah S · Jacksonville, FLS/N M-291N2335KBflyin LLC · Scottsdale, AZBuilt 1997 · S/N E-3135N2335WWhite Traver O · Inkom, IDBuilt 1965 · S/N M-931N2336LBerry Kenneth W · Amarillo, TXBuilt 1963 · S/N M-167N2336MHerd James L · Gardnerville, NVBuilt 1997 · S/N E-3136N2336QRodenbaugh Alan G · Tulsa, OKS/N M-401N2336WFrankenfield Francis R · Quakertown, PABuilt 1966 · S/N M-933N2337LAbitia Alberto · Phoenix, AZBuilt 1963 · S/N M-168N2337QFleener Michael C · Livingston, TXS/N M-402N2337TPate Jason L · Bedford, TXBuilt 1997 · S/N E-3137N2338QWinkels Jeffrey P · Candy, MNFirst renewal noticeBuilt 1963 · S/N M-403N233AKRoettele Mark · Lake Havasu City, AZBuilt 1991 · S/N CE-1609N233CNw Beech Boys LLC · Everson, WABuilt 1969 · S/N CJ-18N233CKAllen Max · Jefferson, GABuilt 1977 · S/N E-1014N233DKitley David Matthew · Dolores, COBuilt 1961 · S/N D-6753N233DFFleckenstein David · Nacogdoches, TXBuilt 1987 · S/N CE1171N233ESSpain Aviation LLC · Lynchburg, VABuilt 1992 · S/N CE-1683N233FCPulliam Dan · Baldwin City, KSBuilt 1970 · S/N CE-293N233GKGoodwin Joseph N · Grass Valley, CABuilt 1968 · S/N D-8777N233JRNorthstar Aerospray Inc · Clara City, MNBuilt 1976 · S/N CE-643
Back to AD 99-05-13 R1 WD