OpenAirDocs.org
AD 94-18-04 R1

Registered aircraft · 1,310

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-18-04-R1')
    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-18-04-R1')
  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.

N3152HMay John D · Ward, ARBuilt 1946 · S/N 3777N3155HPayne Glenn A · Oregon, MOBuilt 1946 · S/N 3780N3156HFoster Scott R · Federal Way, WABuilt 1946 · S/N 3781N3165HWilson Hunter W · Williston, NDBuilt 1946 · S/N 3790N3170HSchimmel O L · Port Hueneme, CABuilt 1946 · S/N 3795N3174HSchaffer Richard C · Sparta, WIBuilt 1946 · S/N 3799N3175HGoitia Juan C · Toa Alta, PRBuilt 1946 · S/N 3800N3193HWarren Howard E · Cookeville, TNBuilt 1946 · S/N 3818N3194HSickles Garry M · Minooka, ILS/N 3819N3210HDixon James L · Eastland, TXBuilt 1946 · S/N 3835N3219HSerrano Juan Carlos · Buckeye, AZS/N 3844N3224HLeonardo Alan W · Higbee, MOS/N 3849N3227HOrtland Richard J · Franklin, MIBuilt 1946 · S/N 3852N3233HCourson Keith A · Boise, IDBuilt 1946 · S/N 3858N3239HEschholz Hans-Joachim · Marietta, GABuilt 1946 · S/N 3864N323TBBoatright Kenneth R · Louisville, KYBuilt 1959 · S/N 5705N3243HSpecht Leo M · Towner, COS/N 3868N3244HManning Gary D · Newalla, OKBuilt 1946 · S/N 3869N3245HBrewer Curtis E · Garland, TXS/N 3870N3254BBeek Dudley E · Miami, FLBuilt 1946 · S/N 1018N3254HWiens James B · Hillsboro, KSBuilt 1946 · S/N 3879N3259HFowler Joshua N · Dayton, NVBuilt 1946 · S/N 3884N3272HHeard Gary S · Delta, COS/N 3897N3276HRoush Jeremy P · West Terre Haute, INBuilt 1946 · S/N 3901N3281HJardine Brian E · Greenleaf, IDS/N 3906N3282HScott Kaden S · Juneau, AKBuilt 1946 · S/N 3907N3287HHouston Aeronautical Heritage Society Inc · Houston, TXBuilt 1946 · S/N 3912N3324HNicholls Kenneth E · Glide, ORBuilt 1947 · S/N 3949N3330HBeil Victor F · Morgan Hill, CABuilt 1946 · S/N 3955N3336HO + W Ag Enterprises Inc · Van Wert, IABuilt 1947 · S/N 3961N3345HWhitaker David E · Canton, OHBuilt 1946 · S/N 3970N3349HGoranson Jan David · Cherry Valley, ILBuilt 1946 · S/N 3974N3359HOdonnell Michael A · Delanco, NJBuilt 1946 · S/N 3984N3363HBailey Riley W Jr · Ada, OKS/N 3988N3376HTaylor Laura M · Tucson, AZBuilt 1946 · S/N 4001N3378HTopken Erick W · Greeley, COBuilt 1946 · S/N 4003N3383HMessina David A · Currituck, NCBuilt 1946 · S/N 4008N3390HMyers Robert W · Fort Wayne, INBuilt 1946 · S/N 4015N3392HWilliams Robert B · Azle, TXBuilt 1955 · S/N 4017N3396HSpecht Leo M · Towner, COBuilt 1946 · S/N 4021N3398HSanderson Donald J · Mckinney, TXBuilt 1946 · S/N 4023N3405HHolman Steve R · Vero Beach, FLBuilt 1946 · S/N 4030N3411HSexton Thomas G · Pelzer, SCBuilt 1946 · S/N 4036N3418HRegistration Pending · Brady, TXRegistration pendingBuilt 1946 · S/N 4043N3426HRomanjenko Fred · Gillette, WYS/N 4051N3428HSnider Thomas G · Arizona City, AZBuilt 1946 · S/N 4053N3435HCasa Del Pajaro LLC · Plaistow, NHBuilt 1946 · S/N 4060N3437HAbrams Linda T · San Pedro, CABuilt 1946 · S/N 4062N3439HDream Flight Aviation LLC · Frederick, MDBuilt 1946 · S/N 4064N3443HPereira Ronaldo · Bridgewater, MABuilt 1947 · S/N 4068
Back to AD 94-18-04 R1