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.

N8232DPagliari Emil R · Fort Walton Beach, FLBuilt 1957 · S/N D-5334N8233DTangobravo Consulting LLC · Redlands, CAS/N D-5335N8236DThompson Ronald L · Lemon Cove, CAS/N D-5341N8237DPts Inc · Wichita, KSBuilt 1957 · S/N D-5342N823RBma Ventures LLC · Boca Raton, FLBuilt 1959 · S/N D-6049N823TKnight Koby Ernest · Haslet, TXS/N D-9521N823VUsher James C · Fort Worth, TXBuilt 1976 · S/N D-9872N8241DMco Holdings LLC · De Pere, WIS/N D-5343N8243DMalkin John · Rockport, TXBuilt 1957 · S/N D-5345N8247DIndy Air Sales LLC · Anderson, INBuilt 1957 · S/N D-5347N8257DWhicker Jacob Edward · Willard, UTBuilt 1957 · S/N D-5374N8258DMatthew Avionics Testing & Technical Support LLC · Stevensville, MTBuilt 1957 · S/N D-5361N8259DBlack Hunter F · Blanding, UTBuilt 1957 · S/N D-5362N8261DGrimmett Carl W · Gravois Mills, MOBuilt 1957 · S/N D-5366N8263DKroll Douglas W · Brighton, COBuilt 1957 · S/N D-5387N8265DPreston Jack Aviation LLC · Mesa, AZBuilt 1957 · S/N D-5365N8268DSmith Nafis T · Wayne, PABuilt 1957 · S/N D-5369N826RA & D Aviation LLC · Menominee, MIBuilt 1959 · S/N D-6153N826RSSpence Charles A · Midland, TXBuilt 1971 · S/N D-9272N826TBonanza H35 LLC · Greensboro, NCBuilt 1973 · S/N D-9518N826VMills Aviation Ltd · Wapakoneta, OHBuilt 1977 · S/N D-9950N8272DHenderson Will · Buffalo, SDBuilt 1957 · S/N D-5370N8272TWayne Clinton · Greenfield, INBuilt 1967 · S/N D-8473N8274DLim William Taek · Rancho Cucamonga, CABuilt 1957 · S/N D-5364N8279DBullard Thomas Eugene · Midlothian, TXBuilt 1957 · S/N D-5392N827LWarfield Gerald A · Saltillo, MSBuilt 1960 · S/N D-6519N827RRatliff Aviation Inc · Sevierville, TNBuilt 1959 · S/N D-6082N827WCustom Air Inc · Roe, ARBuilt 1968 · S/N D-8743N8282DHenry Craig A · East Troy, WIS/N D-5400N8287DWhite Steven · Oxnard, CABuilt 1957 · S/N D-5371N828JGGunderson Marvin · Greenwood Village, COBuilt 1955 · S/N D-4121N828RDebs Raymond E · Boise, IDBuilt 1959 · S/N D-6071N8293DVeum Todd E · Sault Sainte Marie, MIBuilt 1957 · S/N D-5382N8295DHorning Martin R · Lincoln, CAS/N D-5379N8297DDunlap Martin L · Hartville, OHS/N D-5383N82HCVan Buskirk Steven · Denver, COBuilt 1974 · S/N D-9584N82JTRegistered aircraftBuilt 1964 · S/N D-7581N82MSShifflett Kenneth · Olive Branch, MSBuilt 1966 · S/N D-8108N8300DAltitude Adjustment LLC · Solvang, CABuilt 1957 · S/N D-5394N8300NErect A Tube Inc · Harvard, ILBuilt 1968 · S/N D-8719N8302DSmith Luke Allbee · Houston, TXBuilt 1957 · S/N D-5396N8309DBrown Willard Ferrell · Fayetteville, GABuilt 1958 · S/N D-5428N8309NNewman Michael Jay · Sherborn, MABuilt 1968 · S/N D-8720N830NRegistration Pending · Boring, ORRegistration pendingS/N D-6169N8311DCunningham James J · Midlothian, TXBuilt 1957 · S/N D-5414N8313DMclenaghan Alvin N · Phoenix, AZBuilt 1957 · S/N D-5417N8314DMclean Angus L · Bradenton, FLBuilt 1958 · S/N D-5439N8315DBurnd C R · Town Creek, ALBuilt 1958 · S/N D-5462N8318DHice Robert L · Panama City Beach, FLBuilt 1958 · S/N D-5427N8318MChristian Ralph B III · Fort Worth, TXS/N D-3944
Back to AD 94-20-04 R2