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.

N35HVProdigy Aviation LLC · Port Orange, FLBuilt 1957 · S/N D-5236N35JSkybound Shenanigans LLC · Dubuque, IABuilt 1958 · S/N D-5699N35JGJalu Financial Corp · Gray, GABuilt 1963 · S/N D-7181N35JWN35jw LLC · Enid, OKBuilt 1959 · S/N D-5872N35KAHacker Timothy J · Pangburn, ARBuilt 1979 · S/N D-10231N35KJBunn John Timothy · Winter Garden, FLBuilt 1972 · S/N D-9326N35KWCoy Walter Thomas · Titusville, FLBuilt 1975 · S/N D-9827N35LELyall Enterprises Inc · Pauma Valley, CABuilt 1955 · S/N D-4371N35LFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N D9820N35LGAnderson Charles · Bakersfield, CABuilt 1958 · S/N D-5529N35LVDelta Fox Aviation LLC · Fort Worth, TXBuilt 1969 · S/N D-8900N35MSimmons Dennis L · Wichita, KSBuilt 1970 · S/N D-9143N35MASidetrack Investments LLC · Flower Mound, TXBuilt 1969 · S/N D-8925N35MFFlying Barefoot Ranch LLC · Wilmington, DEBuilt 1980 · S/N D-10304N35MSHazeltine Hugh J · Saint Petersburg, FLBuilt 1964 · S/N D-7637N35MTToft Michael O · Brock, TXBuilt 1966 · S/N D-8338N35MVWeaver Kibwe · Kalamazoo, MIBuilt 1967 · S/N D-8617N35MXMontanez George O · Mesa, AZBuilt 1960 · S/N D-6411N35NBBert John Boyd III · Vero Beach, FLBuilt 1975 · S/N D-9802N35NYPerry Charles E · Aldie, VABuilt 1970 · S/N D-9193N35QTReady Aim Flyer LLC · New Castle, DES/N D-8839N35RBBarnes Roger A · Cheyenne, WYBuilt 1963 · S/N D-7219N35RCG5 Aviation Inc · Englewood, COBuilt 1964 · S/N D-7393N35REDakota Aero Inc · Steamboat Springs, COS/N D-8930N35SHulteen Grant S · Tumwater, WABuilt 1964 · S/N D-7481N35SCCramp Steven J · Cleveland, TXBuilt 1973 · S/N D-9442N35STHess Hendrix · New York, NYBuilt 1951 · S/N D-2936N35TBCencalcom Inc · Santa Barbara, CABuilt 1977 · S/N D-9985N35TJBeech D9462 LLC · Perry, OHBuilt 1973 · S/N D9462N35TPMccallister Mark A · Qulin, MOBuilt 1977 · S/N D-10018N35TTJ B & B LLC · Midwest City, OKBuilt 1965 · S/N D-7812N35TWRice Timothy J · Anchorage, AKBuilt 1955 · S/N D-4339N35UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N D-6795N35UPBarker Terry · Purvis, MSBuilt 1965 · S/N D-7998N35VBEquipment Lessors Inc · Lake Hawatha, NJBuilt 1977 · S/N D-10000N35VEMckibben Howard Stephens · Elk Grove, CABuilt 1961 · S/N D-6694N35VSRcp3 Enterprises LLC · Chesterfield, MOBuilt 1966 · S/N D-8247N35WFWashburn Robert D · Newbury Park, CABuilt 1959 · S/N D-4223N35WKSchnell Thomas · Iowa City, IABuilt 1955 · S/N D-4366N35WVN35wv LLC · Charleston, WVBuilt 1955 · S/N D-4273N35XFCaudle David William · Arlington, TXBuilt 1958 · S/N D-5674N35XLWilliams James R · Scotts Valley, CABuilt 1964 · S/N D-7321N35YRTonini Farm And Cattle Co · San Luis Obispo, CABuilt 1982 · S/N D-10397N35YTArmstrong Samuel V · Lovelock, NVBuilt 1955 · S/N D4058N3601BMiller William M · Albuquerque, NMBuilt 1954 · S/N D-3831N360BGregs Inc · Tiburon, CABuilt 1957 · S/N D-4910N360TThroop Greg J · Spokane, WABuilt 1967 · S/N D-8427N361Anderson G Drew · Kent, WABuilt 1952 · S/N D-3202N3627AHint Mart H · Peachtree City, GABuilt 1969 · S/N D-9079N3629ADarrow Mark A Trustee · Mukilteo, WABuilt 1969 · S/N D-9080
Back to AD 94-20-04 R2