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.

N250TCGroth William B · Hixson, TNBuilt 1969 · S/N D-9048N254AAKelly Charles M · San Angelo, TXBuilt 1959 · S/N D-6032N255BDInmotion Media Group LLC · Henderson, NVBuilt 1954 · S/N D-3817N25632Struck Larry G · Gardnerville, NVS/N D-9435N25633Paolercio Alan D · Grants Pass, ORBuilt 1973 · S/N D-9438N25662Atcnavion LLC · Hinckley, OHBuilt 1973 · S/N D-9522N25717Vaadi LLC · Babson Park, FLBuilt 1973 · S/N D-9542N25719Brunner Robert L · Jefferson, ORBuilt 1973 · S/N D-9540N257MWillis Charles A · Arlington, TXBuilt 1958 · S/N D-5604N258TCDunn Mark A · Lufkin, TXBuilt 1966 · S/N D-8351N259JHall James A · Bozeman, MTBuilt 1973 · S/N D-9430N259TTaylor Ted H · Corsicana, TXBuilt 1967 · S/N D-8664N25BTFernandez Sergio R · Port Saint Lucie, FLBuilt 1981 · S/N D-10373N25HHCorn Dustin M · Muncie, INBuilt 1953 · S/N D-3693N25LTCaudell Currin B · Dallas, TXBuilt 1957 · S/N D-5330N25VBOtto Aircraft Sales Inc · Sarasota, FLBuilt 1976 · S/N D-9841N260AACarpenter Timothy A · Phoenix, AZBuilt 1966 · S/N D-8325N261AARoy Michael W · Pear Valley, TXBuilt 1959 · S/N D-5855N262DHansen Nicholas R · Dayton, MTS/N D-3024N263AAWilkey Michael B · Kingston, GABuilt 1958 · S/N D-5581N2667Marlow Air LLC · Gilmanton Iw, NHBuilt 1965 · S/N D-7997N266PDLiberty Garden Center Inc · Norwich, NYBuilt 1967 · S/N D-8654N2682AAnacortes Associates LLC · Anacortes, WABuilt 1969 · S/N D-9045N269BACorporate Aviation Center LLC · Wilmington, DEBuilt 1958 · S/N D-5618N26EPErid Air LLC · Blackfoot, IDS/N D-5533N2701TGray Stephen T · Lafayette, CAS/N D-8436N2714TVertical Flight Leasing LLC · Wilmington, DEBuilt 1967 · S/N D-8438N2717AMitchell Matthew · Roanoke, TXBuilt 1969 · S/N D-9049N2720TMiller Mark · Bellevue, WABuilt 1967 · S/N D-8441N2721TGalvin Peter · Laytonsville, MDBuilt 1967 · S/N D-8443N2722AMontgomery Douglas Tanner · San Antonio, TXBuilt 1969 · S/N D-9050N2728TMilk Ranch LLC · Stephenville, TXBuilt 1967 · S/N D-8447N2729TWasileski David J · Auburn, NYS/N D-8451N272MSHinkle Paul · Broken Arrow, OKBuilt 1964 · S/N D-7429N272PSNormandie Air LLC · Santa Clara, CAS/N D-4056N272SBofinger Jr John M · Hewitt, NJBuilt 1965 · S/N D-8002N2731TFocus LLC · Missoula, MTBuilt 1967 · S/N D-8454N2735TWhite Michael W · Key Largo, FLBuilt 1967 · S/N D-8455N2736TM & N Leasing Co · Marietta, GAS/N D-8458N2739TPickering Kevin P · Lakeland, TNBuilt 1967 · S/N D-8457N2740AMcdaniel Joseph Stewart II · Henderson, TXS/N D-10113N2746TFranklin Ronald C · Las Vegas, NVBuilt 1967 · S/N D-8460N2749TCaudle Nathan · Fort Worth, TXBuilt 1967 · S/N D-8475N274HSWebb Alan J · Medford, ORBuilt 1976 · S/N D-9922N274SScott Joseph Brian · Sarasota, FLBuilt 1966 · S/N D-8329N2753AThomas Dale A · Gooding, IDBuilt 1969 · S/N D-9052N27550Anderson Herman A · Basalt, COBuilt 1967 · S/N D-8465N2759TLopas Jon D Trustee · Prescott, AZBuilt 1967 · S/N D-8468N275BBrunsvold Gene R · Selma, ORBuilt 1970 · S/N D-9206N275BMWestchester Flying Club Inc · Purchase, NYBuilt 1966 · S/N D-8196
Back to AD 94-20-04 R2