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.

N3420BMeruelo Ernesto A · Ouray, COBuilt 1953 · S/N D-3658N3422BPenney Casey J K · Camden, SCBuilt 1953 · S/N D-3660N3423BPetik Neil L · Barney, NDS/N D-3661N3426BHammons Gordon D · Downing, WIBuilt 1953 · S/N D-3664N3429BAbel Jeffrey J · Fort Worth, TXBuilt 1953 · S/N D-3667N342BFritz John R · Chester, MTBuilt 1957 · S/N D-4927N342UWelch Robert T · Alamogordo, NMBuilt 1971 · S/N D-9251N3430BChen Adeline B · West Lafayette, INBuilt 1953 · S/N D-3668N3435BHadley Paul T · Yelm, WABuilt 1953 · S/N D-3673N3436BRome Timothy · Garden City, KSBuilt 1953 · S/N D-3674N3439BSnyder Chris Allen · Benton, KSBuilt 1953 · S/N D-3677N3443BSwift Air International Inc · San Pedro, CAS/N D-3681N3445BNordhagen Melvin L · Spokane, WABuilt 1953 · S/N D-3683N3447BMahoney Christopher P · Quakertown, PAS/N D-3685N344BCote Stephen P · Montgomery, TXS/N D-4953N3456GLawson Michael · Athens, TNBuilt 1952 · S/N D-3195N345BCScalera Dominic P · West Boylston, MABuilt 1960 · S/N D-6567N345CBR&E Bv LLC · Jupiter, FLBuilt 1961 · S/N D-6714N345PMMay Benjamin V Jr · Charlottesville, VABuilt 1961 · S/N D-6635N345ZMetz Howard L · Los Angeles, CABuilt 1961 · S/N D-6713N3461BAnderson Daniel · Venus, TXS/N D-3687N3462BConner W Larry · Los Lunas, NMBuilt 1953 · S/N D-3688N3463BBeveridge Brothers LLC · Columbia, TNBuilt 1953 · S/N D-3689N3464BKimball James W · Mount Dora, FLBuilt 1953 · S/N D-3690N3465BMaxwell Spencer C · Sterling, KSS/N D-3691N346BGWebstrong Aviation LLC · Conway, ARBuilt 1973 · S/N D9494N346S200 Knot LLC · Amarillo, TXBuilt 1969 · S/N D-9092N3472BGroszer Todd A · Saint Marys City, MDBuilt 1953 · S/N D-3698N3474BYoung Donald L · Anniston, ALBuilt 1954 · S/N D-3700N347TMccartney Matthew T · Lake Tapps, WABuilt 1962 · S/N D-7058N3486BCal Aerofab Flight Academy Inc · Chino, CABuilt 1954 · S/N D-3708N348GErickson Clarence B · Shreveport, LAFirst renewal noticeBuilt 1956 · S/N D-4532N348SKoritz Iowa Properties LLC · Key Colony Beach, FLBuilt 1970 · S/N D-9125N3490BSchable Roland J · Janesville, WIBuilt 1954 · S/N D-3710N3491BHinkle Airspray Inc · Cavalier, NDBuilt 1954 · S/N D-3711N3495BGerhardt James L · Owasso, OKBuilt 1954 · S/N D-3713N3499BRegistration Pending · Perkins, OKRegistration pending, pending cancellationBuilt 1954 · S/N D-3717N34TTaylor Kennedy · Courtland, MSS/N D-3712N34UAInternational Air Services Inc Trustee · Carson City, NVS/N D-7241N3502BKnight Clifton T · Kemah, TXBuilt 1954 · S/N D-3719N3503BWelsh Steven M · Oxford, NCBuilt 1954 · S/N D-3721N3509BBeauchamp William J · Rigby, IDBuilt 1954 · S/N D-3726N350BShaffer Benjamin C · Adair, OKBuilt 1957 · S/N D-4905N350HAims Community College · Greeley, COS/N D-8188N350NEMaresco International Corp · Alpha, NJBuilt 1980 · S/N D-10351N350YRSilverman Kenneth · Pelham, NHBuilt 1982 · S/N D-10383N3511VCypress Creek Shooting Lodge LLC · Greenbrier, ARBuilt 1980 · S/N D-10353N3512BSkb Aviation LLC · Moreland Hills, OHBuilt 1954 · S/N D-3729N3514BHabenicht Duane E · Berrien Center, MIS/N D-3731N351ATRegistered aircraftBuilt 1967 · S/N D-8507
Back to AD 94-20-04 R2