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.

N916RCDw Aviation LLC · San Diego, CABuilt 1966 · S/N D-8326N9171QBeech Babe Ltd · Colorado Springs, COBuilt 1970 · S/N D-9246N917SDTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9988N918CSDubberly David · St Simons Is, GABuilt 1961 · S/N D-6881N918QHardey John L · Spring, TXBuilt 1961 · S/N D-6812N919TPWarren Jason J · Silverdale, WABuilt 1977 · S/N D-10068N91JPJackson Gerald M · Lake City, MIBuilt 1975 · S/N D-9810N91KMj Aviation Inc · Custer, SDBuilt 1975 · S/N D-9764N91VPBravo Sierra Holdings LLC · Downers Grove, ILBuilt 1969 · S/N D-9035N920JKeppen Charles Joseph · Wentworth, SDS/N D-4671N9216QOsage Aviation LLC · Yates Center, KSBuilt 1971 · S/N D-9268N9219QMedia Exp LLC · Portland, ORBuilt 1971 · S/N D-9265N921MKCognito Design Inc · Punta Gorda, FLS/N D-9321N9221QPhelan Raymond F · Portland, ORBuilt 1971 · S/N D-9264N9233QMid America Aviation LLC · Wilmington, DEBuilt 1971 · S/N D-9274N9242QSample Donald L · Houston, TXBuilt 1970 · S/N D-9242N9243QFlegler Barry Bronson · Eagle, MIBuilt 1970 · S/N D-9243N924VBauman Ronald L · Stuttgart, ARBuilt 1974 · S/N D-9702N9253QN9253q LLC · Goldsby, OKBuilt 1971 · S/N D-9253N925MVan Wylen Mary F · Grand Rapids, MIBuilt 1973 · S/N D-9474N925QPlane Fun Inc Tr Trustee · Snellville, GABuilt 1961 · S/N D-6821N925RCCastle Shelter Group LLC · Clearwater, MNBuilt 1969 · S/N D-9001N925TPreserve Land Company LLC · Franklin Lakes, NJBuilt 1964 · S/N D-7371N927DCCiruli David E · Lafayette, CABuilt 1976 · S/N D-9855N927JBAirgroup Express LLC · Santa Rosa, CABuilt 1980 · S/N D-10345N927MWStrauss Michael · Ormond Beach, FLBuilt 1973 · S/N D-9546N9287QElarel Corporation · Lewes, DEBuilt 1971 · S/N D-9287N9289QCoutu Bobby L · Plano, TXBuilt 1971 · S/N D-9289N928MMRegistration Pending · Mesa, AZRegistration pendingBuilt 1969 · S/N D-8942N9293QChalk 2 Inc · Apple Valley, CABuilt 1971 · S/N D-9293N9296QReichert Aviation Enterprises LLC · El Cajon, CABuilt 1971 · S/N D-9294N929QMorlen Aviation Mechanical And Electrical Svcs LLC · Conroe, TXBuilt 1961 · S/N D-6826N92NJDan Cox LLC · Troutdale, ORBuilt 1960 · S/N D-6604N92RMAutry Marbella A · Montrose, COBuilt 1958 · S/N D-5667N9303YBoden Josh L · Waldo, KSBuilt 1960 · S/N D-6513N9304QK Factor Aircraft Corp · Jupiter, FLBuilt 1971 · S/N D-9296N9306YTff Inc · Dexter, MIBuilt 1960 · S/N D-6515N9309QBehrent Carl D · Granbury, TXBuilt 1971 · S/N D-9295N9311YWolf Zachary J · Rochester, MNBuilt 1960 · S/N D-6503N9315YAero Con Brio LLC · Wichita, KSBuilt 1960 · S/N D-6518N931BSorenson Michael Justin · Pasco, WABuilt 1961 · S/N D-6792N9323YAgerton William David Jr · Weatherford, TXBuilt 1960 · S/N D-6539N9324YHart Aviators LLC · Sparks, NVBuilt 1960 · S/N D-6528N9325YSimpkins Larry D · Danville, KYBuilt 1960 · S/N D-6529N9327YEpley John F · Enid, OKBuilt 1960 · S/N D-6581N9338YSingleton Jude G · Spring Branch, TXBuilt 1960 · S/N D-6542N933QBates Leonard M · Folsom, CABuilt 1961 · S/N D-6827N933WDGuadagni Carlo · Golden, COBuilt 1963 · S/N D-7206N9340YWaters Kenneth A · Pleasant Hill, CABuilt 1960 · S/N D-6545N9343QMorris Mark · Jasper, GABuilt 1971 · S/N D-9304
Back to AD 94-20-04 R2