OpenAirDocs.org
AD 94-20-04 R2

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-R2')
    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-R2')
  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.

N3797QKolb Norman R · Tijeras, NMBuilt 1967 · S/N D-8415N3798QMartin-Fosters Fuel Service Inc · Seminole, OKBuilt 1967 · S/N D-8416N3799QDtb Aviation Inc · Los Gatos, CABuilt 1967 · S/N D-8433N379TCherney Cody L · Belleville, KSS/N D-7220N37KBMccraw Michael · Myakka City, FLBuilt 1966 · S/N D-8046N37MKSkyhoundmedia Inc · Royal Oak, MIBuilt 1970 · S/N D-9168N3803MRegistered aircraftBuilt 1980 · S/N D-10357N38065Boyd David · Havasu, AZBuilt 1980 · S/N D-10361N3806BHutchinson Roger W · Boonville, INBuilt 1955 · S/N D-4071N3808BGlens Pilot Services LLC · Yulee, FLBuilt 1955 · S/N D-4097N3809BN3809b LLC · Columbia, ILBuilt 1955 · S/N D-4072N3810BDekanich Anthony S · Hermitage, PABuilt 1955 · S/N D-4070N3812BPel Enterprises LLC · Newark, DEBuilt 1955 · S/N D-4078N3815BPacifica LLC · Grand Junction, COS/N D-4088N3819BLucky 20 Gourmet And Adventure Club LLC · Syracuse, INS/N D-4079N3822URegistration Pending · Stillwater, MNRegistration pendingBuilt 1981 · S/N D-10364N3826BVandusen Jason D · Grants Pass, ORBuilt 1955 · S/N D-4091N3829BIntermountain Valve Services Inc · Santaquin, UTBuilt 1955 · S/N D-4100N3836BThompson Aero Inc · Amana, IABuilt 1955 · S/N D-4107N3838BBarnes Patrick R · Berryton, KSBuilt 1955 · S/N D-4095N3840BBata Anthony P · Fort Worth, TXS/N D-4110N3843BBrown Consulting Inc · Bessemer, ALBuilt 1955 · S/N D-4113N3847BBrine William R · Pahrump, NVS/N D-4117N3847XCrowder Jonathan Slade · Columbus, INS/N D-10368N3848BBrown Ronald D · Auburn, WABuilt 1955 · S/N D4118N3853BNoble Jeffrey C · Henderson, TXBuilt 1955 · S/N D-4148N3856BGold Terry C · Folsom, CAS/N D-4122N3857BChristensen Marshall J · Canton, SDBuilt 1955 · S/N D-4124N3858BDodson International Parts Inc · Rantoul, KSBuilt 1955 · S/N D-4125N385BRust Jeffrey J · San Antonio, TXBuilt 1960 · S/N D-6477N3861BNorrix James · Elk River, MNBuilt 1955 · S/N D-4128N3862BTroxel Larry K · Palmdale, CABuilt 1955 · S/N D-4129N3867BColeman Aircraft LLC · Molalla, ORBuilt 1955 · S/N D-4173N3868URegistered aircraftBuilt 1981 · S/N D-10372N3869BHackbart Gary H · Las Vegas, NVBuilt 1955 · S/N D-4102N3870BFresneda Rafael Ruiz · Daytona Beach, FLS/N D-4150N3872BLucarelli David L · Moncks Corner, SCBuilt 1955 · S/N D-4137N3874BLong Lawrence R · South Whitley, INBuilt 1955 · S/N D-4172N3875BRegistration Pending · Spokane, WARegistration pendingBuilt 1955 · S/N D-4198N3877BWilliams Danny J · Mabelvale, ARS/N D-4140N3880BStiles David W · Saint Petersburg, FLS/N D-4133N3887BDouglas Steven L · Huntsville, ALBuilt 1955 · S/N D-4163N388BCAerospace Trust Management LLC · Wilmington, DEBuilt 1975 · S/N D-9786N388GBInternational Air Services Inc Trustee · Carson City, NVBuilt 1951 · S/N D-2761N3892BKirvida James · Hudson, WIBuilt 1955 · S/N D-4171N3893BEngel Carson D Trustee · Amboy, INBuilt 1955 · S/N D-4177N3894BBishop Ernie · Los Angeles, CABuilt 1955 · S/N D-4179N3896BAlden K Butcher Autioneering LLC · Jane Lew, WVBuilt 1955 · S/N D-4146N3897BDiamond Stephen C · West Bloomfield, MIBuilt 1955 · S/N D-4304N3898BHenson Larry B · Haslet, TXBuilt 1955 · S/N D-4376
Back to AD 94-20-04 R2