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.

N77GVBon Vol Ltd · Joliet, ILFirst renewal noticeBuilt 1964 · S/N D-7693N77LMElephants & Airplanes LLC · Wakeforest, NCBuilt 1969 · S/N D-8950N77QJBelzberg Gary Md · Sneads Ferry, NCBuilt 1967 · S/N D-8610N77QQBurkhardt Wayne W · Deming, NMBuilt 1979 · S/N D10251N77RJWilkinson Dane W · Morgan, UTBuilt 1960 · S/N D-6533N77VBMorgenroth Aviation LLC · Victoria, TXBuilt 1974 · S/N D-9629N77XFDuwane D Skipper · Booker, TXBuilt 1977 · S/N D-9989N77XSCarlson Jonathan J · Hernando, MSS/N D-3446N7800YH&H Aviation Of Oklahoma LLC · Oklahoma City, OKBuilt 1978 · S/N D-10072N7802RPiroli John M · Nokomis, FLBuilt 1968 · S/N D-8886N7807RRife Rick R · Scottsdale, AZBuilt 1968 · S/N D-8889N7813RGonzales Donald W DBA · Mercer Island, WABuilt 1969 · S/N D-8912N781LDKeane James P · West Islip, NYBuilt 1978 · S/N D-10132N781ZFolk Jerald F · Ocklawaha, FLBuilt 1960 · S/N D-6471N7820RGabriel Donald E · Tucson, AZBuilt 1968 · S/N D-8866N7828RHoward Donald V · Goldthwaite, TXFirst renewal noticeBuilt 1968 · S/N D-8903N7832RSmith Brian S · Johnson City, TNBuilt 1969 · S/N D-8916N7835VRoney John P · Charlotte, NCBuilt 1978 · S/N D-10155N783TMElliott Frank A · Oxford, MSBuilt 1973 · S/N D-9489N7841MDocmax LLC · Tucson, AZBuilt 1964 · S/N D-7398N7843LLampe Robert T · Kendall, KSS/N D-8817N7843RTrupkin Steven J · Wantagh, NYBuilt 1969 · S/N D-8918N7845RCurley Quinn T · Copperopolis, CABuilt 1968 · S/N D-8908N7848REntrekin Gary W · Ventura, CABuilt 1968 · S/N D-8904N784AAHayden Charles J Jr · Richmond, TXBuilt 1961 · S/N D-6858N7856LGall Peter D · Morgantown, WVBuilt 1966 · S/N D-8289N785JBFuller Aire Inc · Wilmington, DEBuilt 1969 · S/N D-8915N7865RSpangler Bryan G · Manteno, ILBuilt 1969 · S/N D-8932N7866RN7866r Leasing LLC · Linden, MIBuilt 1969 · S/N D-8926N7868LJacob William G · Glendora, CABuilt 1966 · S/N D-8292N7869LCrawford Scott · Newalla, OKBuilt 1966 · S/N D-8293N7870REtchell Russell Allan Trustee · Santa Rosa, CABuilt 1969 · S/N D-8928N7875LRegistered aircraftBuilt 1966 · S/N D-8295N7875RJohnson Joel Andrew · Winterset, IABuilt 1969 · S/N D-8934N7879LCjp Air LLC · Mustang, OKBuilt 1966 · S/N D-8318N7879RMorgan Mark T · Corryton, TNS/N D-8936N787DMoore Christopher R · Cape Coral, FLBuilt 1952 · S/N D-3056N787JVRegistered aircraftBuilt 1977 · S/N D-10082N7880CSilvia Scott A · Valley Springs, CAS/N D-2742N7883LJinnette James G · Raleigh, NCBuilt 1966 · S/N D-8301N7885LGriffin Brad W · Salome, AZBuilt 1966 · S/N D-8303N788KRegistered aircraftBuilt 1977 · S/N D-9992N7892RCutler Sewall C Jr · Fredericksburg, TXBuilt 1969 · S/N D-8944N7893LLilya Trever L · Mesa, AZBuilt 1966 · S/N D-8306N7894RMaul Russell L · Jacksonville, ILBuilt 1969 · S/N D-8946N7895LRemington Pierce S · De Kalb, MOS/N D-8297N789DDrury Kevin S · Walker, LAS/N D-3058N789PDSwords Steven T · Rancho Mirage, CABuilt 1966 · S/N D-8290N789RDomeracki Douglas P · Elgin, ILBuilt 1965 · S/N D-7777N789RGBonanza N789rg LLC · Oro Valley, AZBuilt 1973 · S/N D-9483
Back to AD 94-20-04 R2