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.

N8696MSale Reported · Madisonville, TXSale reportedBuilt 1963 · S/N D-7282N8697QPas Aviation Inc · Modesto, CABuilt 1965 · S/N D-7768N8699QSmith Sidney R Trustee · Rllng Hls Est, CABuilt 1964 · S/N D-7692N86BVMila Air LLC · Cincinnati, OHBuilt 1991 · S/N CE-1582N86CBSweeney David P · Gilmer, TXS/N TC-1383N86CDBri Mar Aviation Corp · New Britain, CTBuilt 1997 · S/N E-3145N86FLTwin Bonanza LLC · Meridian, IDBuilt 1954 · S/N CH-96N86MESutherland Jason · Auburn, WABuilt 1999 · S/N E-3285N86TEBowers Stephen W · Richland, MIS/N D-10342N86ZZSchermer Jacob D · Denver, COBuilt 1966 · S/N MA-85N8700AJurskis Joseph S · Darien, GABuilt 1949 · S/N D-2110N8702Montgomery Andreas M · Athens, TNBuilt 1951 · S/N D-3245N8704MDodson International Parts Inc · Rantoul, KSBuilt 1963 · S/N M-488N8708AMcilvenna John · Chandler, AZS/N D-2118N8708MLetch Clinton J · Wyoming, MNBuilt 1963 · S/N M-492N870SMarsh Air Corps LLC · North Las Vegas, NVBuilt 1973 · S/N TC-1600N870TWjr Enterprises Inc · El Paso, TXBuilt 1962 · S/N D-7011N87140Cgl Media LLC · Jupiter, FLBuilt 1975 · S/N MC-335N8714MCole Leonard O III · Sunrise Beach, MOS/N M-498N8716MWilliams Excavating Inc · Partlow, VABuilt 1963 · S/N M-500N8718AMcnutt Brian K · Dillon, MTBuilt 1949 · S/N D-2245N8718MGilson David R · New Port Richey, FLBuilt 1963 · S/N M-502N871CSTurquoise Blue Aviation LLC · Santa Rosa Beach, FLS/N E-2291N8720MHulme Aviation LLC · Gilbert, AZBuilt 1964 · S/N M-509N8720YEmpire Rental & Leasing Inc · Eden, NCBuilt 1991 · S/N CE-1555N8721AHoffman Kevin · Chatsworth, GAS/N D-2248N8724AMoncks Corner Flyers LLC · Moncks Corner, SCBuilt 1950 · S/N D-2251N8724MKleiber Timothy D · Independence, KSS/N M-513N8724RShewalter Nicholas · Frankfort, MIBuilt 1950 · S/N D-2650N8725AApostolico Richard D · Charleston, SCS/N D-2364N8725MFix Janice M · Crete, NEBuilt 1963 · S/N M-514N8727ACossairt Keith L · Elk Grove, CABuilt 1949 · S/N D-2149N8729ASpivey Kenneth R Jr · Vestavia, ALBuilt 1949 · S/N D-2151N872GMWilliams Tod C · Sheffield, MAS/N DH-112N872TMarroquin-Rivers Diane L · Milford, DEBuilt 1965 · S/N D-7748N872WNsi Flight Services LLC · Idaho Falls, IDS/N EA-681N8732MMusketeer Mike LLC · Yukon, OKBuilt 1963 · S/N M-522N8733Nason David F · Kent, WABuilt 1987 · S/N CE1159N8733AArmstrong Craig V · Casstown, OHFirst renewal noticeBuilt 1949 · S/N D-2155N8735ARhoades Randal W · Newcastle, WYBuilt 1949 · S/N D-2157N8738AErickson Jacob · Graham, WAS/N D-2160N873BCMedia Stew LLC · Carson City, NVS/N CE-1227N873TBryan John Charles Jr · Mocksville, NCBuilt 1965 · S/N TC-845N8741MDodson International Parts Inc · Rantoul, KSBuilt 1963 · S/N M-529N8743MRoberts Randy · Clayton, NMBuilt 1963 · S/N M-530N8747MSmith Peter · Liberty Lake, WABuilt 1963 · S/N M-535N8748MTorres Michael Anthony · Brownsboro, TXBuilt 1964 · S/N M-536N8753GPlane Fun Inc Tr Trustee · Snellville, GABuilt 1957 · S/N D-4930N8755MTraver Ronald D · Lantry, SDS/N M-543N87565Jerrys Kids Aviation LLC · Wilmington, DEBuilt 1967 · S/N D-8490
Back to AD 99-05-13 R1 WD