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.

N3BGHildreth James D · Kennedy, ALBuilt 1967 · S/N D-8612N3BRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N D-9447N3BW4rc LLC · Kenedy, TXBuilt 1976 · S/N D-9870N3CNCheck Six LLC · Champaign, ILBuilt 1981 · S/N BG-198N3DXMchugh Michael J Trustee · Hailey, IDBuilt 1973 · S/N D-9531N3HERidgemont Real Estate Inc · Huntington Woods, MIBuilt 1974 · S/N TC-1710N3HFHughes Farms Inc · Fayette, MOBuilt 1975 · S/N D-9791N3JFBruegget Shannon B · Lance Creek, WYBuilt 1958 · S/N D-5628N3JWJason Flood · Vineland, NJBuilt 1964 · S/N D-7591N3KNKing Martin E · Friendswood, TXBuilt 1980 · S/N E-1770N3MDMcdavid James J · Weatherford, TXBuilt 1965 · S/N D-7856N3MJLarsh Steven S · Libby, MTBuilt 1956 · S/N D-4894N3MYLee Brian E · Peoria, AZBuilt 1974 · S/N D-9661N3PFTuinstra Aaron C · Marinette, WIBuilt 1962 · S/N TC-296N3QASg&F LLC · Riverside, CABuilt 1984 · S/N EA-427N3SUJenkins David G · Grantville, GABuilt 1965 · S/N TE-21N3SVYoung Karen Sue · Cincinnati, OHBuilt 1967 · S/N D-8426N3THHayden Charles J III · Rhome, TXBuilt 1967 · S/N TC-1034N3TYEvelyn Aviation Inc · Wilmington, DEBuilt 1975 · S/N TE-1065N3UCYahraus Andrew · Phoenix, AZBuilt 1981 · S/N TJ-337N3VYSilverstein Adam R · Pittstown, NJBuilt 1957 · S/N BG-334N3WJLlorca Carlo A · Naples, FLBuilt 1974 · S/N TC-1713N3XTHammock Jerry G · Waxahachie, TXBuilt 1970 · S/N D-9156N4000MDonair LLC · Enid, OKBuilt 1962 · S/N M-90N4000WN4000w LLC · Prescott, AZBuilt 1974 · S/N TE-1004N4001SLeckonby David · Waterford, NYS/N TC-1817N4002FDoyle Patrick T · Fond Du Lac, WIBuilt 1955 · S/N G-779N4003TCorey Jason R · Meridian, IDBuilt 1968 · S/N M-1109N4004APrice Jason R · Lillington, NCBuilt 1970 · S/N D-9098N4004TBennett John G · Melbourne, FLBuilt 1968 · S/N M-1110N4007TThurmond Paul J · Huntley, MTBuilt 1968 · S/N M-1114N4009TLake Gary M · Edmond, OKBuilt 1968 · S/N M-1116N400BLBuilding Busters Demolition & Excavation Corp · Saint Louis, MOBuilt 1962 · S/N TC-319N400CAGroundloop Mafia LLC · Desha, ARBuilt 1974 · S/N TC-1727N400DMAlborn Mary L · Eagle River, AKS/N E-748N400GLAaces Flight Operations LLC · Ellisville, MOBuilt 1987 · S/N CE-1201N400KUGudgel Daniel R · Lemoore, CABuilt 1961 · S/N BA-572N400LFBoboltz Randy · Hector, MNBuilt 1975 · S/N D-9825N400LLMentor Flyers Inc · Paragon, INBuilt 1957 · S/N BG-400N400MTSpevco Inc · Pfafftown, NCBuilt 1955 · S/N G-145N400PBonanza V35 LLC · Bakersfield, CABuilt 1976 · S/N D-9933N400RCSpiwak Andrew J · Canyon Lake, TXBuilt 1972 · S/N D-9312N400RLJacobsson Charles A · San Gabriel, CAS/N WA-104N400VHalford John · Ballinger, TXBuilt 1973 · S/N D-9535N400WEOberti Gary A · Hillsborough, CABuilt 1975 · S/N D-9814N400WTArtspret Aviation LLC · Sugar Grove, ILBuilt 2001 · S/N EA-690N400YCTuca 27 LLC · Lewes, DES/N G-128N4010ARegistered aircraftBuilt 1970 · S/N D-9099N4012TStull Joshua S · Tacoma, WABuilt 1968 · S/N M-1119N4013AGeoghagan Dewayne · Indianapolis, INBuilt 1970 · S/N D-9115
Back to AD 99-05-13 R1 WD