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.

N16MJacobsen Chris · Arvada, COBuilt 1944 · S/N 6765N16MJHangarfinds LLC · Westminster, COBuilt 1959 · S/N D-6023N16NHRutgers Nicholas G IV · Camas, WABuilt 1985 · S/N E-2220N16RBHotel Sierra Aviation LLC · Texarkana, TXBuilt 1965 · S/N TC-840N16SInternational Air Services Inc Trustee · Carson City, NVBuilt 1946 · S/N 6687N16THMosquera Daniel · Miami, FLBuilt 1966 · S/N M-994N16UTWhite Alan J · Fishersville, VABuilt 1972 · S/N M-1396N16YBBolea Air Inc · Morgan Hill, CABuilt 1974 · S/N TC-1688N1700BJohnson David E · Blair, NEBuilt 1960 · S/N D-6358N1700XRegistered aircraftBuilt 1954 · S/N D-3866N1701WJagz Aviation LLC · Akron, OHS/N D-9394N1702TDans Shop Inc · Montevideo, MNBuilt 1963 · S/N TC-527N1703WNeimeier Henry P · Bowling Green, KYBuilt 1971 · S/N D-9303N1704WNiskanen Michael · Framingham, MABuilt 1972 · S/N TC-1486N17061Beech Fun Aviation LLC · Spring Grove, ILBuilt 1936 · S/N 112N17064Lindsay David C Trustee · Warrensburg, MOBuilt 1937 · S/N 128N1706GBarcenas Shawn · Weirsdale, FLBuilt 1962 · S/N TC-274N1706WHinton Bay Management LLC · Jackson, WYBuilt 1972 · S/N E-366N17071Saunders Christopher D · Lehighton, PAS/N 156N17072Switzer Shyler T · Athens, OHS/N 130N17073Brightwell Joseph R · Louisville, KYBuilt 1937 · S/N 131N17074Port Townsend Aero Museum · Port Townsend, WABuilt 1937 · S/N 132N17078White Bill E · Estacada, ORS/N 133N1707WRussell Marc R · Simi Valley, CABuilt 1972 · S/N E-367N17082Scaletta Samuel L · Middleton, WIBuilt 1940 · S/N 137N17083Beechcraft Heritage Museum Inc · Tullahoma, TNS/N 138N1708WCassaday Jonathan A · Visalia, CABuilt 1964 · S/N D-7340N170HPKoven Mark Lee · Logan, UTBuilt 1975 · S/N CE-615N170MWilliams John R Jr · Marfa, TXFirst renewal noticeBuilt 1966 · S/N D-8317N170SWalker Ray A · Sanger, TXBuilt 1945 · S/N 4817N1711VAggravation Aviation Inc · Wilmington, DEBuilt 1964 · S/N TC-591N1713GRight Away Trucking Inc · Hazlehurst, GABuilt 1962 · S/N D-6939N1717SXp Silva Air LLC · Rockaway, NJS/N TJ-53N1717WAdkins Zachary R · Scottsboro, ALBuilt 1972 · S/N D-9368N171CEGarrison Randy · Queen City, TXBuilt 1973 · S/N E-504N171DFDkg Motorized Conveyances Inc · Beaverton, ORBuilt 1978 · S/N TJ-155N171FBrassell Andrew Keith · Argyle, TXBuilt 1964 · S/N TC-609N171FBBiggs Aircraft Inc · Wellston, OKBuilt 1977 · S/N TC-2039N171HTodd Doug · De Witt, IABuilt 1965 · S/N D-7959N171JTropicaire LLC · Hamilton, MTBuilt 1965 · S/N D-7957N171JDStoffel Duane L · Hamilton, MTBuilt 1961 · S/N TC-90N171PBHarding Derrick S DBA · Adair, OKBuilt 1995 · S/N E2992N171PFRegistration Pending · Los Osos, CARegistration pendingBuilt 1980 · S/N EA-164N171RPRosales Partners Air LLC · Austin, TXBuilt 1977 · S/N D-10092N171XLifto Patrick J · Miles City, MTBuilt 1962 · S/N D-5857N171YCesarano Billy · Maryville, TNBuilt 1958 · S/N D-5467N1720GRegistration Pending · Kalispell, MTRegistration pending, pending cancellationBuilt 1962 · S/N D-6943N1721GCorlett Samuel E · Fort Worth, TXBuilt 1962 · S/N D-6944N1722TNoldin John · Griffith, INS/N D-7139N1725WEdwards John G · Stoneville, NCS/N D-9400
Back to AD 99-05-13 R1 WD