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.

N8680MFrastaci Jeffrey A · Pioneer, OHS/N D-7291N8682QNoguess Levi B · Belton, TXBuilt 1964 · S/N D-7696N8684QBush Mark B · Crosby, TXBuilt 1964 · S/N D-7688N8686MTrujillo Joe E · Oakland, CABuilt 1963 · S/N D-7275N8687MMassingale Harold L · Lenoir City, TNS/N D-7277N8687QWhite Thomas B · Long Beach, CABuilt 1964 · S/N D-7694N8690MScruggs Steven C · Astoria, ORBuilt 1964 · S/N D-7279N8690QWallek Dustin L · Corpus Christi, TXBuilt 1964 · S/N D-7700N8692MBowser Adam L · Lake City, FLBuilt 1963 · S/N D-7288N8693MLandis Rob R · Seabrook, TXBuilt 1963 · S/N D-7276N8693QFester John P · Sullivan, MOBuilt 1964 · S/N D-7703N8694QBonkowski & Associates Inc · Emeryville, CABuilt 1964 · S/N D-7704N8695MGround Floor Design LLC · Idyllwild, CABuilt 1964 · S/N D-7336N8696MSale Reported · Madisonville, TXSale reportedBuilt 1963 · S/N D-7282N8697QPas Aviation Inc · Modesto, CABuilt 1965 · S/N D-7768N8699QSmith Sidney R Trustee · Rllng Hls Est, CABuilt 1964 · S/N D-7692N86TEBowers Stephen W · Richland, MIS/N D-10342N8702Montgomery Andreas M · Athens, TNBuilt 1951 · S/N D-3245N870TWjr Enterprises Inc · El Paso, TXBuilt 1962 · S/N D-7011N872TMarroquin-Rivers Diane L · Milford, DEBuilt 1965 · S/N D-7748N8753GPlane Fun Inc Tr Trustee · Snellville, GABuilt 1957 · S/N D-4930N87565Jerrys Kids Aviation LLC · Wilmington, DEBuilt 1967 · S/N D-8490N875TMw Leasing Inc · Redlands, CABuilt 1965 · S/N D-7837N876THighrider LLC · Humble, TXBuilt 1965 · S/N D-7753N8788Renken Jeremy L · Fairfax, VAS/N D-2778N878BBarber Colman Co · Rockford, ILRegistration revokedBuilt 1956 · S/N D-4820N879MCJ P IV LLC · Hickory, NCBuilt 1977 · S/N D-10008N87DBBlanchat Manufacturing Inc · Harper, KSBuilt 1967 · S/N D-8570N87DGLow Wing Aviation LLC · Mountain Home, ARBuilt 1959 · S/N D-5794N87KSockey Investments LLC · Poteau, OKBuilt 1964 · S/N D-7607N87SPBorabora LLC · Tampa, FLBuilt 1968 · S/N D-8804N8800MFlying Leatherheads LLC · Lakeland, FLBuilt 1964 · S/N D-7324N8803MFerwerda Beech LLC · Fremont, NHBuilt 1964 · S/N D-7328N8807MCatanese Marc V · Cumberland, RIBuilt 1964 · S/N D-7330N8812MTri-County Ag Service Inc · Ipswich, SDBuilt 1964 · S/N D-7332N8815MGidusko James Patrick II · Hanover, PABuilt 1964 · S/N D-7334N881RParker Steven L · Many, LABuilt 1960 · S/N D-6290N8824MHalpern Joseph Robert · Apo, AEBuilt 1964 · S/N D-7344N8826MAeolus LLC · Portland, MEBuilt 1964 · S/N D-7373N8827MNewport Elite LLC · Newport Beach, CABuilt 1964 · S/N D-7347N882BPalmer Christopher J · Soddy Daisy, TNS/N D-6780N882RFoss James K · Anchorage, AKBuilt 1960 · S/N D-6291N882TGoing Bonanzas LLC · Scottsdale, AZBuilt 1965 · S/N D-7784N8830MRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1964 · S/N D-7348N8834MPilots Discretion LLC · Atlanta, GABuilt 1964 · S/N D-7352N8835MKnight Robert T · Baton Rouge, LABuilt 1964 · S/N D-7353N8837MNewpower Scott · Seeley Lake, MTBuilt 1964 · S/N D-7346N883RRegistered aircraftBuilt 1960 · S/N D-6373N883TEasley Toby · Lucama, NCBuilt 1965 · S/N D-7770N8841MBanana Boys LLC · Seattle, WABuilt 1964 · S/N D-7365
Back to AD 94-20-04 R2