OpenAirDocs.org
AD 94-20-04 R1

Registered aircraft · 4,469

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:94-20-04-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R1')
  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.

N6695HMegan Anderson Nursing Services Inc · Yucaipa, CABuilt 1980 · S/N D-10343N6696WClift William R II · Princeton, KYBuilt 1980 · S/N D-10329N669D1000 Springs Aviation LLC · Buhl, IDBuilt 1951 · S/N D-2940N66TCJohnson Dennis A · Bowman, GAS/N D-8061N66VVFarrell William J · Fort Myers, FLBuilt 1966 · S/N D-8271N66WCWeiner Ronald I · Jackson, TNBuilt 1978 · S/N D-10199N670TWThunderbolt Ltd · Salem, NEBuilt 1967 · S/N D-8434N670WSchmitt Rudy · Brookshire, TXBuilt 1960 · S/N D-6445N671SHEnochian Gary F · Santa Rosa, CABuilt 1966 · S/N D-8034N6728YDashdale Aviation LLC · Fort Dodge, IABuilt 1980 · S/N D-10330N672DWlad Joseph M Trustee · Alameda, CABuilt 1963 · S/N D-7204N6731RHaidlen Ford Inc · Oakdale, CABuilt 1980 · S/N D-10331N673DHagglund Carl D · Pendleton, ORS/N D-2948N673TBalchunas Anthony B · Robinson, TXBuilt 1967 · S/N D-8470N6746BMoran Ted B · Spokane, WABuilt 1980 · S/N D-10344N6747ZMclouth Fred E · Elkhorn, NEBuilt 1980 · S/N D-10346N674DSale Reported · Fountain, COSale reportedBuilt 1951 · S/N D-2946N674TTumbling Mirth Mt LLC · Cody, WYBuilt 1969 · S/N D-9007N675BWFreedman Stephen Eric · Falls Church, VABuilt 1978 · S/N D-10134N675VCroft Lloyd B · Galveston, TXBuilt 1960 · S/N D-6575N676TFry Aviation LLC · Piqua, OHBuilt 1963 · S/N D-7248N6778ZSkorina Air LLC · Walla Walla, WABuilt 1959 · S/N D-6033N678DCentral Virginia Aviation Inc · North Dinwiddie, VAS/N D-2951N678JREberhardt John R Jr · Katy, TXBuilt 1977 · S/N D-10095N6791Maschmeyer Thomas L · Bedford, TXBuilt 1961 · S/N D-6791N679CWSims Steve · Quinlan, TXS/N D-6679N67CSBymaster Mark · Knoxville, TNBuilt 1960 · S/N D-6442N67DRLarson Jeffrey · Spearfish, SDS/N D-9772N67RCBueter Eric J · Wauseon, OHS/N D-8049N67VBRegistration Pending · Athens, TNRegistration pending, pending cancellationBuilt 1967 · S/N D-8428N6801SMastropole James W · Great Falls, VABuilt 1976 · S/N D-9849N6808SKlw Flight Management LLC · Booneville, MSS/N D-9852N680DClint 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-7594N681DAustin 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-7450N6828QHenson Jimmy Dean · Maysville, OKBuilt 1964 · S/N D-7595N6831SJordan David N Jr · Knoxville, TNBuilt 1977 · S/N D-9971N6833QLittle Paul K · Coronado, CAS/N D-7223N6840QIdell Enterprises LLC · Wilmington, DEBuilt 1964 · S/N D-7445N684TSpa N684t LLC · Titusville, FLS/N D-5892N6855QPlehn Thomas R Trustee · Las Vegas, NVBuilt 1964 · S/N D-7464N6860QEschenbach Ralph · San Jose, CABuilt 1964 · S/N D-7475N686DCMedbery Nathan J · Minto, NDBuilt 1956 · S/N D-4748N687DRiffenburgh Walter V · Big Bear Lake, CAS/N D2963N688VBonanza Flyers LLC · Newport News, VABuilt 1960 · S/N D-6393
Back to AD 94-20-04 R1