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.

N941AChalk 2 Inc · Apple Valley, CABuilt 1965 · S/N D-7865N941ALWatson Alfred L · Bucklin, MOS/N D-6423N9420SBaumann James R · Muskogee, OKS/N D-8015N9420YPremier One Express LLC · Orlando, FLBuilt 1964 · S/N TC-582N9421SFugate Kirk A · El Dorado Springs, MOBuilt 1965 · S/N D-8017N9422SWindwalker Adventures LLC · Scottsdale, AZBuilt 1965 · S/N D-8020N9423STlc Aero LLC · Magnolia, TXBuilt 1965 · S/N D-8018N9424YDurham Dusty Lowell · Lubbock, TXBuilt 1960 · S/N D-6603N9426YMy Pilot Ltd · Northridge, CAS/N D-6605N9427YKing Rodney R · Lucedale, MSBuilt 1960 · S/N D-6601N9428YFlying W LLC · Ridgeland, SCBuilt 1960 · S/N D-6606N942TBillen Jarod H · Lakeland, TNBuilt 1960 · S/N TD-363N942VEndeavor Enterprises LLC · Alta Loma, CAS/N E-715N9430Cochise College · Douglas, AZBuilt 1968 · S/N TC-1194N9430QHoyt Stuart T · Raleigh, NCBuilt 1972 · S/N D-9316N9430YGcw Aero LLC · Naples, FLBuilt 1960 · S/N D-6609N9431QN9431q LLC · Round Rock, TXBuilt 1972 · S/N CE-365N9431SBurgdorf Dale A · Plano, TXBuilt 1965 · S/N D-8021N9431YSims Steve · Greenville, TXBuilt 1960 · S/N D-6610N9432QKnh LLC · Bozeman, MTBuilt 1972 · S/N E-310N9435YGailey Henry S · Elberton, GAS/N D-6613N9436SShrauner Harry Scott Trustee · Elkhart, KSS/N TE-48N9436YRominger Kent V · Cottonwood Heights, UTBuilt 1960 · S/N D-6614N9437YKramer Kaleb R · Henderson, TXBuilt 1960 · S/N D-6615N9439SDocs Huckleberry LLC · Cornell, WIS/N D8025N943BCrawford Alan R · Buchanan Dam, TXBuilt 1966 · S/N TE-88N943PWRegistered aircraftAssigned, pending cancellationS/N TC-627N9440QKatz Alan E · Hopkinton, MABuilt 1972 · S/N D-9319N9440YWhite Travis W · Charleston, SCBuilt 1960 · S/N D-6621N9441YBennett Innocent Rwagasore · San Marcos, TXS/N D-6623N9445YSkpy LLC · Kalispell, MTBuilt 1961 · S/N D-6629N944LFAir Northeast LLC · Colorado Springs, COBuilt 1995 · S/N E-2968N944PACrebbs Ben H · Tucson, AZBuilt 1982 · S/N EA-300N944QRoach Terrance J · Little Falls, MNBuilt 1961 · S/N D-6818N944RMKrol Matthew D · Hideaway, TXBuilt 1965 · S/N D-8026N944TDiedrick Michael R · Brooksville, FLBuilt 1960 · S/N TD-400N944VCoastal 944v LLC · Wilmington, NCBuilt 1975 · S/N M-1662N9450SDakota Sierra LLC · Horace, NDBuilt 1966 · S/N D-8045N9450YBatchelor Sarah Hall · Decatur, ALS/N D-6624N9455SBlythe Edward A · Dallas, TXBuilt 1966 · S/N D-8050N9456SHerrick Richard J Trustee · Lenox, MABuilt 1966 · S/N D-8036N9456YWilliams Management Inc · Anacoco, LABuilt 1961 · S/N D-6643N9457YTennyson Ricky Lee · Stephenville, TXBuilt 1961 · S/N D-6634N9459YLadelle L George · Ashley, NDBuilt 1961 · S/N D-6771N945BRegistered aircraftBuilt 1974 · S/N TC-1826N945GWAlcyone Trust Corp Trustee · Wichita, KSBuilt 1979 · S/N P-497N9461QRose Kim N · East Wenatchee, WABuilt 1972 · S/N D-9322N9461SAndre David A Trustee · Webster Groves, MOBuilt 1966 · S/N D-8053N9462QR & B Corp · Pittstown, NJBuilt 1972 · S/N E-313N9463HEzell Chadwick S · Breckenridge, TXBuilt 1944 · S/N 6900
Back to AD 99-05-13 R1 WD