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.

N1947MMoeny James A · Cottonwood, AZBuilt 1964 · S/N D-7547N1948DDuncan Rodney P · Las Vegas, NVBuilt 1952 · S/N D-3227N194HAMagnor Clifford E · Fayetteville, NCS/N D-5052N194NASharrit Edgar W · Sebring, FLS/N D-8409N1953DFox Christopher R · Modesto, CAS/N D-3233N1954DMontes Muriel E · Edgewood, NMBuilt 1952 · S/N D-3234N1957DLiggenstoffer Buddy L · Kiowa, KSBuilt 1952 · S/N D-3238N1958Stonitsch Rudy H · Crestwood, ILBuilt 1958 · S/N D-5619N1963PBordeaux Bo Co · Sacramento, CABuilt 1963 · S/N D-7300N1965SN1965s LLC · Williamstown, NJBuilt 1964 · S/N D-7653N1965TWeld Kenneth Jr DBA · Port Orange, FLBuilt 1964 · S/N D-7543N1965ZBushwack Air Inc · Phoenix, AZBuilt 1965 · S/N D-7805N1966DKing Kevin L · Anaheim, CABuilt 1952 · S/N D-3249N1975DAlsworth Cinimin Sea · Anchorage, AKBuilt 1952 · S/N D-3172N1975KFly By Night Management LLC · Downers Grove, ILBuilt 1974 · S/N D-9715N1976DRobertson William Jr · Powell, TNBuilt 1956 · S/N D-3190N1978DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1952 · S/N D-3177N1979DRoberts Lawrence A Trustee · Fishersville, VABuilt 1952 · S/N D-3200N197BDill Jeffrey R · Pleasant View, TNBuilt 1956 · S/N D-4527N197QUrban Andrew W · Sun Prairie, WIBuilt 1965 · S/N D-7930N1984DFoster Buell M · Yucca Valley, CABuilt 1952 · S/N D-3215N1985CCollins Bruce J · Caldwell, TXS/N D-7438N1986DWolfe Thomas V · Mountain Lakes, NJBuilt 1952 · S/N D-3220N1991DCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1952 · S/N D-3250N1993DSale Reported · Summer Shade, KYSale reportedBuilt 1952 · S/N D-3256N1995DAment Robert · Merritt Island, FLBuilt 1952 · S/N D-3265N1998DLundberg Cole M · Junction City, WIBuilt 1952 · S/N D-3263N199AAHeide Charles H · Kenosha, WIBuilt 1958 · S/N D-5781N199KMOrloff Kenneth Lee Trustee · Groveland, CABuilt 1979 · S/N D-10243N19ABYong Andrew · Newnan, GABuilt 1964 · S/N D-7701N19BMRicks Aviation Inc · Wilmington, DEBuilt 1957 · S/N D-5259N19MAAvco Security Systems Inc · Jupiter, FLBuilt 1966 · S/N D-8173N19SLMifflin Enterprises LLC · Mansfield, OHBuilt 1976 · S/N D-9848N19WWood Alton K · Bee Spring, KYS/N D-3734N19WCV35a LLC · Beacon, NYBuilt 1969 · S/N D-8998N1AWKoedam Robert E · Saint Louis, MOBuilt 1960 · S/N D-6617N1BWMbs Ventures Inc · Wilmington, DEBuilt 1977 · S/N D-9963N1NMShaffer Thomas F DBA · Somerset, PAS/N D-5211N1PVMuzny Gregory · Magnolia, TXS/N D-3028N1QGLos Arboles Management Company LLC · Moriarty, NMBuilt 1966 · S/N D-8328N1SKWienhoff Kevin Bruce · Salem, ORS/N D-9339N1UZJet X Leasing Inc · Johnson, KSBuilt 1964 · S/N D-7420N1WFRegistered aircraftBuilt 1968 · S/N D-8880N1XDOne X-Ray Delta LLC · Shreveport, LABuilt 1961 · S/N D-6702N1YRPerley Kevin G Trustee · Sioux City, IABuilt 1975 · S/N D-9797N2001BBangert Computer Systems Inc · Shawnee, KSBuilt 1966 · S/N D-8216N2001DOn The Roll Aviation LLC · Vail, AZBuilt 1952 · S/N D-3351N2001WCyrus Ely G · Kiana, AKBuilt 1965 · S/N D-7965N2002WWilliams Howard Dale II · Oklahoma City, OKBuilt 1965 · S/N D-7988N2004WPeter Schiff Aero Inc · Cookeville, TNBuilt 1965 · S/N D-7966
Back to AD 94-20-04 R2