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.

N1548WCrabb Joseph M · Tempe, AZBuilt 1972 · S/N D-9344N155BPooky Aviation LLC · Augusta, GABuilt 1958 · S/N D-5701N155JWTcpb LLC · Lewes, DEBuilt 1975 · S/N D-9837N1560ZYoung James Scott · Kemah, TXBuilt 1961 · S/N D-6863N1563WArmstrong James L Trustee · Santa Barbara, CABuilt 1972 · S/N D-9370N1565ZStowe Martin D · Carlsbad, CABuilt 1961 · S/N D-6867N1566LRedden Timothy Ray · Citrus Heights, CABuilt 1976 · S/N D-9862N1567SWegener Properties LLC Series Bonanza · Aurora, ILBuilt 1962 · S/N D-6993N1568ZKeenan Michael Richard Sr · Albuquerque, NMBuilt 1961 · S/N D-6870N1570ZSalvay Michael E · Long Beach, CABuilt 1961 · S/N D-6872N1571WWest Elk Construction Ltd · Milliken, COBuilt 1972 · S/N D-9349N1576WPowis Michael P · Oak Grove, MOBuilt 1972 · S/N D-9350N1577ZAthuil Philippe · Beverly Hills, CABuilt 1961 · S/N D-6878N1578ZProctor Brian S · Leesburg, TXBuilt 1961 · S/N D-6877N1579LEvans Christopher A · Lynden, WABuilt 1976 · S/N D-9863N157FBeech Cristina I · Lake Mary, FLBuilt 1954 · S/N D-3934N1580ZLiebmann Christopher J · Tehachapi, CABuilt 1961 · S/N D-6879N1581WBrown David C · Overland Park, KSS/N D-9352N1582ZAugust Aero LLC · Kalispell, MTBuilt 1961 · S/N D-6880N1583WNorton William P · Lakeville, MNBuilt 1972 · S/N D-9353N1585ZKnoche Matthew · Clarkston, MIBuilt 1961 · S/N D-6883N1586ZJoe L Fisher · Downers Grove, ILBuilt 1961 · S/N D-6882N1587ZGlittenberg Bryson · Flower Mound, TXBuilt 1961 · S/N D-6876N1589LCain James W · Big Rapids, MIS/N D-9866N158SHoffman Eric M · Kerman, CABuilt 1953 · S/N D-3568N1593SHoward Paul D Jr · Williamson, WVS/N D-7013N1593ZButler Richard Austin · Gatesville, TXBuilt 1961 · S/N D-6885N1594ZWondra Wayne L · Friendswood, TXBuilt 1961 · S/N D-6886N1595LClemens Jerry W · Parsons, KSBuilt 1976 · S/N D-9869N1596ZBarnett Paul S · Brookhaven, MSBuilt 1961 · S/N D-6887N1597WSmith William J · Wichita Falls, TXBuilt 1972 · S/N D-9359N1598SDougherty William G · Hacksneck, VABuilt 1962 · S/N D-7008N1598WCanvasback Investments LLC · Kerrville, TXBuilt 1972 · S/N D-9356N1598ZMitchell Lester L · Okmulgee, OKBuilt 1961 · S/N D-6889N159AMakray Joseph C · Port Charlotte, FLBuilt 1958 · S/N D-5598N159MDLaw Offices Of Shawn A Mcmillan Apc · San Diego, CABuilt 1959 · S/N D-5849N159PKRegistered aircraftBuilt 1957 · S/N D-5363N15DTBernal Cresencio · Pittsburg, CABuilt 1968 · S/N D-8725N15JFHumanitarian Airlift International · Owasso, OKS/N D-3095N15KCGostanian Gregory K · Fresno, CAS/N D-3478N15VMGagne Jay A · Dyersburg, TNBuilt 1976 · S/N D-9936N1601WSix Ten Ventures LLC · Grand Prairie, TXBuilt 1972 · S/N D-9360N160SPAerospace Trust Management LLC Trustee · Wilmington, DES/N D-9615N161WCater Christopher B · Lowell, MIBuilt 1965 · S/N D-7914N1625WGunter Professional Pilot Services LLC · Wichita Falls, TXBuilt 1972 · S/N D-9365N1628WT W Air LLC · Worthington, KYS/N D-9366N1632WCdg Aviation LLC · Cresson, TXBuilt 1972 · S/N D-9363N1634WTaglieri Ronald F · Pass Christian, MSBuilt 1972 · S/N D-9378N164BPlummer Keith G · Tishomingo, OKBuilt 1955 · S/N D-4437N165BHawkins Flying Service LLC · Franktown, COS/N D-4451
Back to AD 94-20-04 R2