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.

N78JGHorinek Troy C · Goodland, KSS/N D-3254N78KKJim Heck Investments LLC · Findlay, OHBuilt 1977 · S/N D-10075N78KMRegistered aircraftAssigned, pending cancellationS/N D-5497N78RSSkorpiks Inc · Tyndall, SDBuilt 1980 · S/N D-10360N78WHDel Rosi Anthony J · Key Largo, FLBuilt 1978 · S/N D-10145N7900DWesley Hunt Renovations LLC · Helena, MTS/N D-5134N7900KThykeson Air LLC · Portland, NDBuilt 1964 · S/N D-7403N7900MRegistered aircraftBuilt 1966 · S/N D-8223N7900SPanther City Air LLC · Fort Worth, TXBuilt 1965 · S/N D-7900N7901KBarber Victor L · Blanket, TXBuilt 1964 · S/N D-7404N7902MBig Blue Sky LLC · Indianapolis, INBuilt 1966 · S/N D-8227N7903KRegistered aircraftBuilt 1964 · S/N D-7710N7906DCrawley James T · Parker, COBuilt 1957 · S/N D-5384N7907DKilo Bravo LLC · Greensboro, NCBuilt 1957 · S/N D-5184N7908KManning Howard L · South Lake Tahoe, CABuilt 1964 · S/N D-7407N7909DKlein James M · Pinconning, MIBuilt 1957 · S/N D-5171N7910KTyler William R · Plantation, FLBuilt 1964 · S/N D-7405N7911AOboyle Joseph E · Danville, VABuilt 1964 · S/N D-7490N7911DPowell Curtis · Tucson, AZBuilt 1957 · S/N D-5145N7911MGillette David L · Mount Pleasant, TXBuilt 1966 · S/N D-8225N7913DOstwinkle Robert J · Mormon Lake, AZBuilt 1957 · S/N D-5161N7914DLosee Dan · Lehi, UTBuilt 1957 · S/N D-5198N7914RFrith Smith Michael J · Bishop, CABuilt 1969 · S/N D-8943N7915RWoods Todd Ryan · Perry, OKBuilt 1969 · S/N D-8941N7917KStratospheric Flyers Group Inc · Louisville, KYBuilt 1964 · S/N D-7416N7917RPh Air LLC · Turners Falls, MAFirst renewal noticeBuilt 1969 · S/N D-8940N7918DGolden Stephen J · Berkeley Springs, WVBuilt 1957 · S/N D-5146N7919DCarroll Aviation LLC · Kissimmee, FLBuilt 1957 · S/N D-5149N791VWGreenawalt Bryan M · Durham, NCBuilt 1958 · S/N D-5570N7921DSmith Lee Holdings LLC · Oklahoma City, OKBuilt 1957 · S/N D-5167N7921KFrieders Bryan · Thompsons Station, TNBuilt 1964 · S/N D-7713N7921MMiller Dennis J · Bartlett, TNBuilt 1966 · S/N D-8251N7922KChand Jaison A · Astoria, ORBuilt 1964 · S/N D-7456N7922MDestination Aero LLC · Lubbock, TXBuilt 1966 · S/N D-8235N7924DTimberline Aircraft LLC · Kalispell, MTBuilt 1957 · S/N D-5174N7925DBowers Christian R · Troy, ALBuilt 1957 · S/N D-5209N7925RHoward Philip D · Glen Rose, TXBuilt 1969 · S/N D-8949N7926DRegistered aircraftBuilt 1957 · S/N D-5194N7926KOconnell Raymond · Brawley, CABuilt 1964 · S/N D-7421N7928DNovak Warren D G · Lake Placid, FLBuilt 1957 · S/N D-5195N792DMDkl Inc · Ardmore, OKBuilt 1966 · S/N D-8354N7930DGronau Brian · Oxford, OHBuilt 1957 · S/N D-5197N7932MPower James P · Box Elder, SDBuilt 1966 · S/N D-8241N7932RIowa Aircraft Inc · Burlington, IABuilt 1969 · S/N D-8954N7933KCross Marc W · Corpus Christi, TXBuilt 1964 · S/N D-7424N7933RBeech Runner LLC · Wilmington, DEBuilt 1969 · S/N D-8955N7935RWhitney Frederick C · Hampton, NJBuilt 1969 · S/N D-8960N7936DMartin Tully T · Idalou, TXBuilt 1957 · S/N D-5210N7936KTurbo Air Charter LLC · Boise, IDBuilt 1964 · S/N D-7428N7936RCloud Surfing LLC · Missoula, MTBuilt 1969 · S/N D-8962
Back to AD 94-20-04 R2