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.

N4831JSiewert Michael H · Columbus, OHBuilt 1966 · S/N D-8335N4839JFlying For Fun LLC · Sunnyvale, TXBuilt 1966 · S/N D-8340N48458Peterson Timothy R · Monument, COBuilt 1971 · S/N D-9291N4847JLittle River Corp · Anchorage, AKBuilt 1966 · S/N D-8346N4850JCardamone Rayner Mark Gibson · Manistique, MIBuilt 1966 · S/N D-8345N4852JStoffel Christopher David · Colorado Springs, COS/N D-8349N4853JNaca 130 LLC · Cameron Park, CABuilt 1966 · S/N D-8350N4856JN4856j LLC · Boulder, COBuilt 1967 · S/N D-8536N4871JGray Robert R · Granbury, TXBuilt 1966 · S/N D-8356N488Woodward Jeffery Scott · San Angelo, TXBuilt 1955 · S/N D-4243N4889JRegistered aircraftBuilt 1967 · S/N D-8424N488FDLittleton Darrell D · Atlanta, TXBuilt 1968 · S/N D-8700N488TWilliams Alvis Leon · Heavener, OKS/N D-6726N4894JCapri Blue Aviation LLC · Norcross, GABuilt 1967 · S/N D-8430N4896JMyshatyn Michael · Eaton, COBuilt 1967 · S/N D-8435N489MHendrix Danny J · Aledo, TXBuilt 1960 · S/N D-6505N48ABBailey Robert L · Dover, DEBuilt 1954 · S/N D-3769N48KUWildcat Aviation LLC · Wilmington, DEBuilt 1979 · S/N D-10303N48LFKraxberger Scotty L · Salida, COBuilt 1964 · S/N D-7489N48MHSeventh North Hangar LLC · Bolton, MAS/N D-9184N48RSColin A Oerton · Miami Beach, FLBuilt 1966 · S/N D-8250N4908Ballew Jackie C · Rogersville, MOBuilt 1962 · S/N D-7014N490TBowen Edmund L · Laguna Beach, CAS/N D-6644N4919BKirvida James Mitchell · New Richmond, WIS/N D-4257N4920BHain Christopher O · Merritt Island, FLBuilt 1955 · S/N D-4325N492TZuestek Inc · Diana, TXBuilt 1960 · S/N D-6597N4951VBranam John R · Clinton, TNBuilt 1952 · S/N D-3197N496TWalker Stephen E · Mcgregor, TXBuilt 1961 · S/N D-6684N4971BOlstad Christopher A · El Cajon, CABuilt 1958 · S/N D-5551N4975BYates Gary · Punta Gorda, FLS/N D-5567N4984MBas Part Sales LLC · Greeley, COBuilt 1978 · S/N D-10137N4989MRistevski Bill · Vacaville, CABuilt 1978 · S/N D-10140N499Dancer Thomas M · Dallas, TXBuilt 1954 · S/N D-3963N4998BMclenaghan Alvin N · Phoenix, AZBuilt 1956 · S/N D-4516N499DSDelta Sierra Aviation · Wilmington, DEBuilt 1967 · S/N D-8316N499MBCook Joshua D - Trustee · Nashville, TNBuilt 1964 · S/N D-7587N49PGVasiloff Mark · Barberton, OHBuilt 1967 · S/N D-8452N49TRVincent T Remcho Phd LLC · Corvallis, ORBuilt 1974 · S/N D-9628N49WPWilkinson Graham · Camano Island, WAS/N D-2725N49YTTotten Floyd M · Wamego, KSS/N D-5186N4ERJet Mentors USA LLC · Littleton, COBuilt 1961 · S/N D-6869N4EVSchlueter Gerald C · Lincoln, CABuilt 1952 · S/N D-3302N4FHWall Jacob · Grapevine, TXBuilt 1976 · S/N D-9973N4HHAndrews Terry · Camp Verde, AZS/N D-8422N4JXCosta James J · Tulare, CABuilt 1974 · S/N D-9642N4WNBlair Aircraft No 2 LLC · Herriman, UTS/N D-5689N4WRShoemaker David J · Menlo Park, CABuilt 1967 · S/N D-8497N4XPPazdziora Ronald G · St Charles, ILBuilt 1982 · S/N D-10401N5000QNowalzyk Daniel C · Downers Grove, ILBuilt 1957 · S/N D-5000N5002BPeacock Jeffery D · Cleburne, TXS/N D4271
Back to AD 94-20-04 R2