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.

N41TWFair James A · Derby, CTBuilt 1961 · S/N D-6563N41USLucas Gregory · Santa Rosa, CAS/N TD-624N41VHSutherland Jason · Auburn, WABuilt 1993 · S/N E-2832N41VKGalaxy Aviation LLC · Nantucket, MABuilt 1981 · S/N E-1885N41XEMedic Choppers LLC · Springdale, ARS/N D-2871N4200DHarding Jeromy · Port Richey, FLBuilt 1955 · S/N D-4408N4201DPhilpott Stuart · Taylorsville, KYBuilt 1955 · S/N D-4398N4203SWright John D · Richmond, TXBuilt 1976 · S/N E-958N4208DWiley Robert S · Fayetteville, TNBuilt 1955 · S/N D-4411N420ASBas Part Sales LLC · Greeley, COS/N P-265N420BWGordo Air Inc · Middletown, DENon-citizen corporation, flight hours not reportedS/N EA-636N420EWalker Ray A · Sanger, TXBuilt 1944 · S/N 6671N420JFlying Mules LLC · Hutchinson, KSBuilt 1979 · S/N CE-894N420JDDuke LLC · Reno, NVS/N P-521N420SFunchess Thomas A · Hazlehurst, MSBuilt 1969 · S/N TG-74N420ZBAdaptive Aerospace Corp · Tehachapi, CAFirst renewal noticeBuilt 1980 · S/N E-1765N42101Ross Evan · Lafayette, COBuilt 1970 · S/N TC-1292N4210DKeefer C Paul · Venus, TXS/N D-4415N42114Spiller Gary W · Lafayette, ORS/N 39815N4211BAdair Edward A · Hemet, CAS/N D-4222N4212SColburn Reno Bryan · Turner, MTBuilt 1976 · S/N D-9954N4213ZFarmer Aviation LLC · Milan, MIBuilt 1955 · S/N BG-112N4214BCoburn Brooks · Leesburg, VABuilt 1955 · S/N D-4167N4215DTench William C · Belton, SCBuilt 1955 · S/N D-4421N4215SHolliday Bryan E · Flower Mound, TXBuilt 1976 · S/N CE-678N4216BRasmussen Nathan A · River Falls, WIBuilt 1955 · S/N D-4175N4217DNation Linda S · Sanford, FLBuilt 1955 · S/N D-4426N4217SAnla Aviation LLC · Bentonville, ARBuilt 1977 · S/N D-9968N4218ARed Skye 52 LLC · Port Orange, FLS/N 52-8271AN4218DHarris Beth · Albuquerque, NMBuilt 1955 · S/N D-4412N421BJRegistered aircraftBuilt 1968 · S/N TC-1057N421NMWings Over The Rockies Air & Space Museum · Denver, COBuilt 1961 · S/N G-720N421PWMead Lawrence C Trustee · Powell, OHBuilt 2002 · S/N E-3466N4224DBurgher Ronald · Fallbrook, CABuilt 1955 · S/N D-4432N4225BJobelle Albert M · Los Angeles, CABuilt 1955 · S/N D-4193N4226DClark Douglas E · Petal, MSBuilt 1955 · S/N D-4435N4228BKcuce LLC · Kalispell, MTS/N D-4197N422ATDec Flight Services LLC · Sandy Springs, GABuilt 2000 · S/N E-3333N422DBHarron Eric J · Austin, TXBuilt 1978 · S/N E-1386N422DCJohnson John K · Portland, ORBuilt 1959 · S/N D-5843N422GRHolden Virgil Gary Trustee · Upland, CABuilt 1966 · S/N D-8243N422MMBolt Robert S · Tampa, FLBuilt 1998 · S/N E-3217N422MNNogle & Black Aviation Inc · Champaign, ILS/N G833N422NMRhyne Gregory L · Port Orange, FLS/N 52-8265N422SBHudak Christopher · South Miami, FLBuilt 1978 · S/N P-479N4230BYonge Chase L · Summerfield, FLS/N D-4201N4230DKoski John M · Wichita Falls, TXBuilt 1955 · S/N D-4438N4232DRuppel Robert E · New Orleans, LAS/N D-4441N4233DLaine John J · Katy, TXBuilt 1955 · S/N D-4442N4234BLionudakis Mike Alan · Scotts Valley, CABuilt 1955 · S/N D-4207
Back to AD 99-05-13 R1 WD