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.

N7983DSanocki Raveen D · Phoenix, AZBuilt 1957 · S/N D-5281N7983KCormier Christopher J · Anna, TXBuilt 1964 · S/N D-7584N7984KBeech V-Tail LLC · Aurora, COBuilt 1964 · S/N D-7483N7986DClevenger Mark L · Porter, TXBuilt 1957 · S/N D-5276N7987DSparrowhawk Aviation LLC · Moraine, OHBuilt 1957 · S/N D-5273N7987KSharair LLC · Thomasville, GABuilt 1964 · S/N D-7491N7987MKrikorian Philip R · Fresno, CABuilt 1966 · S/N D-8273N7987RHopeful Monster LLC · Ann Arbor, MIBuilt 1969 · S/N D-8975N7988KUnlimited Horsepower LLC · Lewisburg, WVBuilt 1964 · S/N D-7492N7988MBlandon Pedro Md Pa · El Paso, TXBuilt 1967 · S/N D-8471N7989DMoss Charles B · York, SCBuilt 1957 · S/N D-5243N798RDSmith Lawrence M · Jacksonville, FLBuilt 1967 · S/N D-8528N7994KReynolds Gary L · Colorado Springs, COBuilt 1964 · S/N D-7502N7995KHall Benjamin H Jr · Tullahoma, TNBuilt 1964 · S/N D-7501N7998DArizona Red Mountain Enterprises Inc · Mesa, AZBuilt 1957 · S/N D-5278N7998MBertelli Leonard DBA · Lancaster, SCBuilt 1966 · S/N D-8278N7999KBristol Bay Capital LLC · Watkins, COS/N D-7578N79PRHutchinson Andrew J · Gardner, KSBuilt 1970 · S/N D-9138N79RKSlone Thad M · Flectcher, OHBuilt 1957 · S/N D-5172N79VABlack Aero LLC · Las Vegas, NVS/N D-6690N7AWWeese David · Yamhill, ORBuilt 1965 · S/N D-7834N7KTOrtiz Alexander · Walnut Creek, CABuilt 1979 · S/N D-10268N7NSHamilton Robert · Longview, TXBuilt 1958 · S/N D-5559N7PKBohn Robert D Jr · Midway, GABuilt 1974 · S/N D-9608N7SWWheeler Ralph F · Lake City, FLS/N D-3382N7WAWalker Edward A · Solomons, MDBuilt 1964 · S/N D-7668N8000LWeeks Stanley III · Taneyville, MOBuilt 1965 · S/N D-8000N8009RDyczek Albert J · Omaha, NEBuilt 1969 · S/N D-8976N800DRheude Ronald D · Frostproof, FLBuilt 1955 · S/N D-4200N800EEMarks Robin · San Luis Obispo, CABuilt 1979 · S/N D-10288N800MRRoney John F · Mission Hills, KSBuilt 1964 · S/N D7624N8011RChristl Steven J · Shady Shores, TXBuilt 1969 · S/N D-8979N801DDoty Patricia · Ocala, FLBuilt 1956 · S/N D-4660N802RLa Morgia Victor J · Bullhead City, AZBuilt 1959 · S/N D-6002N803DLRapids Ruddervators LLC · Wisconsin Rapids, WIBuilt 1973 · S/N D-9448N8041LEgmond Aircraft LLC · Lewes, DEBuilt 1956 · S/N D-4305N804RRabinovitsj Alexandre D · Keene, TXS/N D-6030N8057SKnutsen Wayne R · Tioga, NDS/N D-5934N80608E&L Enterprises · Chinook, MTBuilt 1963 · S/N D-7176N8069RDouble R Farm Inc · Clayton, NMBuilt 1969 · S/N D-9019N806RAndrews Seth K · Tampa, FLBuilt 1959 · S/N D-6083N8074RHilde Chadwick Q · Statesboro, GABuilt 1969 · S/N D-8982N807RHenricks Alen · Watertown, SDBuilt 1959 · S/N D-6084N807TKelly Michael J · Overgaard, AZBuilt 1964 · S/N D-7691N8080RKubit John · Edgewood, TXS/N D-8993N8081RCook Marvin R · Portales, NMBuilt 1969 · S/N D-8994N808GRRoth Geoffrey Hh Trustee · Sedona, AZBuilt 1963 · S/N D-7214N8093RBrand David E · Touchet, WABuilt 1969 · S/N D-8996N809TTsr Aviation Inc · Rochester, MNBuilt 1973 · S/N D-9460N80DFBeadazzled LLC · Holland, MIBuilt 1976 · S/N D-9982
Back to AD 94-20-04 R2