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.

N5467DRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 1957 · S/N D-4973N5468DWilliamson William R · Asheboro, NCBuilt 1957 · S/N D-4960N5469VSchweers John · Plano, TXBuilt 1967 · S/N D-8565N5470DDocter Lloyd W · Tacoma, WABuilt 1957 · S/N D-5020N5471DN5471d LLC · Duluth, MNBuilt 1957 · S/N D-5006N5475DDelta Ridge Farms LLC · Oak Grove, LAS/N D-4994N5478DRobb Steven G · Riverside, CABuilt 1957 · S/N D-4985N5480UGwb Air LLC · Waterford, MIS/N D-8553N5483DMclenaghan Alvin N · Phoenix, AZBuilt 1957 · S/N D-5024N5487DSims Daniel E · Salem, ORBuilt 1957 · S/N D-5011N5487USuss Charles H Trustee · Woodford, VTBuilt 1967 · S/N D-8559N5489DJrh Wings LLC · Alva, OKBuilt 1957 · S/N D-5012N5491UAarestad Potato Co Ltd · Halstad, MNBuilt 1967 · S/N D-8584N5492DCekinovich Ted M · Machesney Park, ILBuilt 1956 · S/N D-5018N5493DAcres Aviation LLC · Fremont, NEBuilt 1957 · S/N D-5022N5494DGulp LLC · Ardmore, OKBuilt 1957 · S/N D-5026N5496DYuhr Keith D · Miami, FLBuilt 1957 · S/N D-5263N54FPPlatinum Aero Enterprise LLC · Henderson, NVBuilt 1955 · S/N D-4093N54RHWhite Parker K · Grass Valley, CABuilt 1959 · S/N D-6275N54VKPain Management And Aesthetics LLC · Celina, OHBuilt 1966 · S/N D-8066N5500DSmoky Mountain Vertical Services LLC · Kodak, TNBuilt 1957 · S/N D-5037N5503DDodge Michael T · Wausau, WIBuilt 1957 · S/N D-5029N5505DMolloy Mark E · Waxahachie, TXFirst renewal noticeBuilt 1957 · S/N D-5045N5506DGarrison John P · Temple, TXBuilt 1957 · S/N D-5046N550CVGoodwin-Huber-Wilhelm Linda Lee · Santa Fe, NMBuilt 1973 · S/N D-9505N550JEEssert Joe · Windsor, CORegistration expired, pending cancellationBuilt 1960 · S/N D-6356N550MBRegistered aircraftBuilt 1964 · S/N D-7610N550X550x LLC · Tucson, AZS/N D-9255N5513DManross Marquardt Ltd Partnership · Mesa, AZBuilt 1957 · S/N D-5070N5515DRichards Paul M · Chicago, ILBuilt 1957 · S/N D-5073N5517DTillman Fred L · Lakeland, FLBuilt 1957 · S/N D-5044N551GJanes Christopher D · Columbia, KYBuilt 1968 · S/N D-8772N551TN551t LLC · Hesston, KSBuilt 1977 · S/N D-10013N5522DBrewer Thomas A · Anderson, INBuilt 1957 · S/N D-5057N5522FSchlaffer Sandor · Daytona Beach, FLBuilt 1957 · S/N D-5019N5525DOlsen Gary E · Albuquerque, NMBuilt 1957 · S/N D-5061N5527DCarns Ronald · Killeen, TXBuilt 1957 · S/N D-5063N552BWinkelbauer Kim G · Sun City, AZBuilt 1967 · S/N D-8524N5532DSchaffert Warren E · Trenton, NES/N D-5082N5533DKilo Aviation LLC · East Peoria, ILBuilt 1957 · S/N D-5083N5533KVan Nostran Michael T · Lake Havasu City, AZBuilt 1968 · S/N D-8905N5536DLett Laura D · Dallas, TXBuilt 1957 · S/N D-5086N5545DPartlow Lee · Granbury, TXBuilt 1957 · S/N D-5091N5546DKennedy Kevin L · Moscow, IDFirst renewal noticeBuilt 1957 · S/N D-5130N5548DKirkpatrick Robert · Placerville, CABuilt 1957 · S/N D-5111N5549DRobert T Parker Jr · Bigfork, MTS/N D-5109N5552DZahl Oerjan · Maricopa, AZBuilt 1957 · S/N D-5179N5556DMedic Choppers LLC · Springdale, ARBuilt 1957 · S/N D-5078N5558DSchoenau Michael W · Tulare, CABuilt 1957 · S/N D-5080N555BCHammett Michael James · Hattiesburg, MSBuilt 1966 · S/N D-8341
Back to AD 94-20-04 R2