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.

N678HCMckisson Holdings LLC · Renton, WABuilt 1980 · S/N EA-180N678JREberhardt John R Jr · Katy, TXBuilt 1977 · S/N D-10095N67901Fly Safe Partners LLC · Sugar Land, TXBuilt 1984 · S/N E-2135N6791Maschmeyer Thomas L · Bedford, TXBuilt 1961 · S/N D-6791N6791KJj&R A36 Inc · Moosic, PABuilt 1984 · S/N E-2136N6797YFar West Ranches Inc · Brawley, CABuilt 1995 · S/N E-2974N679APMilam James J · Lampasas, TXS/N E-679N679CWSims Steve · Quinlan, TXS/N D-6679N679VAMoyes Ronald G Trustee · Phoenix, AZBuilt 1967 · S/N TG-11N67ALAlan Gaudenti · Groveland, CABuilt 1988 · S/N E-2420N67CDAspen Aircraft LLC · Oklahoma City, OKS/N E-2554N67CSBymaster Mark · Knoxville, TNBuilt 1960 · S/N D-6442N67DRLarson Jeffrey · Spearfish, SDS/N D-9772N67ERWhitfield Michael L · Leander, TXBuilt 1976 · S/N TJ-43N67GFOld Buzzard Aviation Inc · Middleburg, FLBuilt 1967 · S/N TD-700N67JWManley Steven T · Dallas, TXS/N E-1530N67KWMunoz Rodolfo A Jr · Midland, TXBuilt 1967 · S/N TE-462N67LRoad Kill Aviation Inc · Wilmington, DEBuilt 1973 · S/N TE-908N67RCBueter Eric J · Wauseon, OHS/N D-8049N67RMBlue Side Up Aviation Services Inc · Fort Pierce, FLS/N TC-1362N67TA2planks LLC · Newark, DEBuilt 2002 · S/N E-3478N67VBRegistration Pending · Athens, TNRegistration pending, pending cancellationBuilt 1967 · S/N D-8428N6801SMastropole James W · Great Falls, VABuilt 1976 · S/N D-9849N6801THoffman Peter · Monrovia, CABuilt 1984 · S/N EA-429N6808SKlw Flight Management LLC · Booneville, MSS/N D-9852N680BChisum Robert · Lorenzo, TXS/N D-1683N680DClint Worman Construction Inc · Volborg, MTBuilt 1951 · S/N D-2954N680RSSamples Ryan · Edmond, OKBuilt 1966 · S/N D-8298N6810QFerraraccio Chris · Clarksville, TNBuilt 1964 · S/N D-7594N6816SHodges Seth L · Omaha, TXBuilt 1976 · S/N E-810N681BClatterbuck Guy E Jr · Springfield, VABuilt 1948 · S/N D-1684N681DAustin Paul W · Des Moines, IABuilt 1951 · S/N D-2955N681VStandby One Aircraft LLC · Tulsa, OKBuilt 1960 · S/N D-6392N6821SSouthern States Aircraft LLC · Walland, TNBuilt 1976 · S/N D-9853N6824QBartholomew And Associates Realty Inc II · Edmond, OKBuilt 1964 · S/N D-7447N6826QBeechcraft Heritage Museum · Tullahoma, TNBuilt 1964 · S/N D-7450N6826SRocking D Aviation LLC · Granbury, TXBuilt 1976 · S/N TC-2014N6828QHenson Jimmy Dean · Maysville, OKBuilt 1964 · S/N D-7595N6829WGroupe Caraibe LLC · Wilmington, DEBuilt 1984 · S/N EA-407N6831SJordan David N Jr · Knoxville, TNBuilt 1977 · S/N D-9971N6832SGelaude James J · Lakewood, COBuilt 1976 · S/N TC-1935N6833QLittle Paul K · Coronado, CAS/N D-7223N6834APlum Family Buildings LLC · Marengo, IABuilt 1984 · S/N EA-408N6834QJones Larry L · Paragould, ARBuilt 1964 · S/N TC-673N6837QLa Brada Fabio · Decatur, TXBuilt 1984 · S/N E-2143N683SDMurray Steven L · Webster, NYBuilt 1980 · S/N EA-148N6840QIdell Enterprises LLC · Wilmington, DEBuilt 1964 · S/N D-7445N6846CDillon T34 6846c LLC · Scottsdale, AZS/N CCF34-58N6848CRegistration Pending · Sheridan, WYRegistration pendingBuilt 1984 · S/N E-2147N6849QE H L Aviation LLC · Greenbush, MNS/N TC-667
Back to AD 99-05-13 R1 WD