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.

N1110CGriffith Danny E · Little Rock, ARS/N D-5117N1110WFoulks Alan Lee Trustee · Glendale, AZBuilt 1972 · S/N D-9310N11114Daly Arthur P · El Paso, TXBuilt 1968 · S/N D-8901N1115YSmith Phillip · Arlington, TXS/N D-4248N111BWKnudsen Kent A · Rosenberg, TXBuilt 1954 · S/N D-3780N111CVN2xt LLC · Austin, TXS/N D-7718N111ECGs Wings Inc · Pawnee, ILBuilt 1967 · S/N D-8385N111GMCarder Wiley C · Cameron Park, CAS/N D-10081N111GSWiebener John W · Alva, OKBuilt 1968 · S/N D-8780N111KFrizzell Kim F · Lakeville, MNBuilt 1961 · S/N D6786N111MSMid America Sprayers Inc · Johnson, KSBuilt 1966 · S/N D-8249N111PFFinefield James P · Cary, ILBuilt 1971 · S/N D-9300N111TMIreland David A · Eatonville, WABuilt 1976 · S/N D-9974N111TWScott Hersmon Builder Inc · Ada, MIBuilt 1967 · S/N D-8641N111YBVanicek Nicholas Andrew · Whispering Pines, NCBuilt 1962 · S/N D-6962N1120MRichter Keith B · Oro Valley, AZBuilt 1972 · S/N D-9346N1122PTroccoli Peter Trustee · Paradise Valley, AZBuilt 1978 · S/N D-10120N1129TStapleton Thomas · Avon, INBuilt 1976 · S/N D-9867N112SPowell Paul L · Rancho Cucamonga, CABuilt 1964 · S/N D-7466N112XAir Corriente LLC · Columbia, TNBuilt 1966 · S/N D-8121N1130MTelbo LLC · Vonore, TNBuilt 1965 · S/N D-8023N113JLHare Richard C · Northville, MIBuilt 1966 · S/N D-8167N113TWD'Antoni Gary L · Katy, TXBuilt 1973 · S/N D-9539N113VSaravis Darren S · Long Beach, CABuilt 1965 · S/N D-7958N113XClement James G · Cresson, TXBuilt 1966 · S/N D-8112N1148TCorlett Samuel E · Fort Worth, TXBuilt 1958 · S/N D-5453N114JDVintage Motors Inc · Beattyville, KYBuilt 1973 · S/N D-9420N114SIrby Darrell L · Keller, TXBuilt 1951 · S/N D-2709N114TPGrj LLC · Lexington, SCBuilt 1975 · S/N D-9801N114WREstes Aviation LLC · Vicksburg, MSS/N D-10052N1151XSummers Jayson V · Poway, CABuilt 1961 · S/N D-6705N1156TAero 1 LLC · Kalispell, MTBuilt 1975 · S/N D-9761N115CA8k Entertainment Inc · Wells, MEBuilt 1981 · S/N D-10371N115MRRussell Keith M · Ivoryton, CTBuilt 1960 · S/N D-6394N1165TFlying J Partners Asset Management LLC · Casper, WYBuilt 1975 · S/N D-9754N1169TMorin Daniel P · New Harbor, MEBuilt 1975 · S/N D-9770N116FTaylor John · Mammoth Spring, ARBuilt 1953 · S/N D-3488N116TWHatfield David A · West Ossipee, NHBuilt 1973 · S/N D-9529N1170TJf Capital Series LLC · Truckee, CABuilt 1975 · S/N D-9777N1183ABronson Nw Inc · Redmond, ORBuilt 1969 · S/N D-9006N118NSagouspe Consulting Services LLC · Hayden, COBuilt 1960 · S/N D-6427N118VSmith Gregg W · Lake Jackson, TXBuilt 1966 · S/N D-8096N119DDColeman Russell L · St Charles, ILBuilt 1952 · S/N D-3380N119JBWagner Mathew J · Gary, SDBuilt 1958 · S/N D-5683N119JSFennen David A · Katy, TXBuilt 1961 · S/N D-6861N119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1966 · S/N D-8231N119TTBurrell Anthony · Stillwater, OKBuilt 1981 · S/N D-10369N119WRatliff Hayden N · Clarkesville, GABuilt 1953 · S/N D-3518N11EMEstus Chad · North Las Vegas, NVBuilt 1957 · S/N D-5159N11FPShannon Rcs LLC · Kalispell, MTBuilt 1952 · S/N D-3104
Back to AD 94-20-04 R2