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.

N6005EMakiyama Todd · San Ramon, CAS/N D5927N6006ESchoenau Michael W · Tulare, CABuilt 1959 · S/N D-5909N6007EOboa Enterprises LLC · Edmond, OKBuilt 1959 · S/N D-5915N6008FShared 08f Inc · Pensacola Beach, FLBuilt 1965 · S/N D-7798N600MDDowning Scott L · Fitzgerald, GABuilt 1965 · S/N D-7803N6010EBruce Mkristo E · Ravensdale, WABuilt 1959 · S/N D-5942N6015EGlaysh-Air Aviation LLC · Cary, ILBuilt 1959 · S/N D-5941N6016EHagins Chrisopher Ryan · Yulee, FLBuilt 1959 · S/N D-5918N6016FHanson Enterprises Inc · Hamel, MNBuilt 1965 · S/N D-7823N6018EBurns Robert D · Billings, MTBuilt 1959 · S/N D-5962N6019ECobb Lee C · Van Alstyne, TXBuilt 1959 · S/N D-5980N6019FFlying R LLC · Apison, TNBuilt 1965 · S/N D-7901N601SGBrynildson Scott W · Rifle, COBuilt 1959 · S/N D-5949N601UJBurton Donald O · Mooresville, NCBuilt 1966 · S/N D-8117N6020EDominianni Michael J · Chester, NJBuilt 1959 · S/N D-5922N6021EMerhar Timothy J · Shoreview, MNBuilt 1959 · S/N D-5919N6022EWard John B · Fishers, INBuilt 1959 · S/N D-5930N6024AAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N D-10210N6025TVtales LLC · Urbana, ILBuilt 1979 · S/N D-10213N60264Buttram John Randal · Panama City, FLBuilt 1979 · S/N D-10219N6026ERegistered aircraftBuilt 1959 · S/N D-5936N6026UJohnsson Johan C · Monterey, CABuilt 1979 · S/N D-10218N6027EJava LLC · Oxford, MSBuilt 1959 · S/N D-5928N6027FPease David · Santa Cruz, CABuilt 1965 · S/N D-7895N6027GBell William F · Hartwell, GABuilt 1979 · S/N D-10220N6028FFlying Ospreys LLC · Camas, WABuilt 1965 · S/N D-7808N6029FTeeple Leighton B · Plainview, TXBuilt 1965 · S/N D-7809N6032VLawler Craig R · Milton, PABuilt 1979 · S/N D-10227N6034EKoch Gary B · Roseville, CAFirst renewal noticeS/N D-5953N6035BMontgomery Aviation Corporation · Montgomery, ALFirst renewal noticeBuilt 1980 · S/N D-10348N6036GBulldawg Aviation LLC · Helena, MTBuilt 1979 · S/N D-10229N6037EN6037e LLC · Williamstown, WVBuilt 1959 · S/N D-5998N60394Sears Brothers Farming · Joes, COBuilt 1979 · S/N D-10233N6039ELangford John · Pilot Point, TXS/N D-5991N6040FJct Holdings LLC · Henderson, NVS/N D-7814N6041EGirod Consulting Inc · Duncan, OKBuilt 1959 · S/N D-5975N6041FKabo LLC · Las Vegas, NVBuilt 1965 · S/N D-7816N6043EWhitaker Charles D · Kettering, OHBuilt 1959 · S/N D-5983N6046EMaltby Gary M · Malvern, ARBuilt 1959 · S/N D-5976N6047ECampisi Brian James · Eliot, MEBuilt 1959 · S/N D-5971N6048ESones Kelly L · South Lake Tahoe, CABuilt 1959 · S/N D-5973N6049EBeale Paul D · Longmont, COBuilt 1959 · S/N D-5982N6049FBrown Boot Aviation LLC · Chesapeake, VABuilt 1965 · S/N D-7820N604TTaxman Arthur Michael · Port Orange, FLBuilt 1958 · S/N D-5535N6050EJohnson Jay L · Hillsboro, MOBuilt 1959 · S/N D-5977N60527Smith Sidney R Trustee · Rllng Hls Est, CABuilt 1979 · S/N D-10235N6053EDublin Airforce LLC · Dublin, GABuilt 1959 · S/N D-5992N6054EKj & J LLC · Lamar, MOBuilt 1959 · S/N D-6001N6055EBurns Ortis R · Warner Robins, GABuilt 1959 · S/N D-6010N6056YDiesel Flying LLC · Wilmington, DEBuilt 1979 · S/N D-10242
Back to AD 94-20-04 R2