OpenAirDocs.org
AD 94-05-05 R1

Registered aircraft · 26,231

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-05-05-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-05-05-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.

N4001HLapiair LLC · Vergennes, VTBuilt 1940 · S/N 41108N4001VKittelman Tom L · Buckley, WAS/N 18320N4002NRiggin Flight Service Inc · Madison, SDS/N 13460N4002VLofstrom David S · Chugiak, AKS/N 18321N4003EKnight Aaron P · Marion, INBuilt 1947 · S/N 11BC91N4003FMartin Rogers K · Rome, GABuilt 1958 · S/N 36903N4003UGambassi Saverio · Bealeton, VAS/N 15061403N4003VPa Services Gulfsouth LLC · Minden, LAS/N 18322N4004FCreelman Richard A · San Marcos, TXBuilt 1958 · S/N 36904N4004VDitges Nathanael · Creston, IABuilt 1948 · S/N 18323N4005FRound Engine Aero · Nashville, MIS/N 36905N4005USteinberg Alan R · Iron Mountain, MIBuilt 1965 · S/N 15061405N4005VScarberry Dennis L · Goddard, KSBuilt 1948 · S/N 18324N4006FBig Sky Fkyers LLC · Billings, MTS/N 36906N4006JGreenstreet Robert A · Lake Geneva, WIBuilt 1966 · S/N 15065306N4006NRafford Mark D · Ashland, MEBuilt 1947 · S/N 13464N4007NMurray Madison L · Buena Vista, GABuilt 1947 · S/N 13465N4008AJuniata Valley Rv · Mifflintown, PABuilt 1947 · S/N 47-1095N40091Skaug Douglas C · North Branch, MNS/N REN574N4009BOoi Lucy M · Catlett, VAS/N 7BCM-380N400PGGwennap Josh A · Rogersville, MOBuilt 2007 · S/N CC11-00014N400SKCappello Dave A · Cottonwood, CABuilt 1967 · S/N 17256077N4010FLarsen Harry A · The Dalles, ORBuilt 1958 · S/N 36910N4010UPorter Christopher · Pinnacle, NCBuilt 1965 · S/N 15061410N4010VSale Reported · Saint Joseph, MOSale reportedBuilt 1948 · S/N 18329N4011FMiller Kerry N · Owensville, MOBuilt 1958 · S/N 36911N4011UGreene Pete M · Pembroke Pines, FLBuilt 1965 · S/N 15061411N4011VDeal Michael R · Elko, NVBuilt 1948 · S/N 18330N4012EFogle Timothy G · Lindsay, TXBuilt 1947 · S/N 11BC-100N4012NIrwin Richard C · Bedias, TXBuilt 1947 · S/N 13470N4012UMorris Donna L · Yelm, WABuilt 1965 · S/N 15061412N4012VBaker Air Service Inc · Baker, MTBuilt 1948 · S/N 18331N4013JMacomber Daniel · Chehalis, WABuilt 1966 · S/N 15065313N4013NLingenfelter Stephen D · Davenport, WABuilt 1947 · S/N 13471N4013ULetourneau University · Longview, TXBuilt 1965 · S/N 15061413N4013VBaldwin John D · Sisters, ORBuilt 1948 · S/N 18332N4014FMaxification LLC · Lavonia, GABuilt 1958 · S/N 36914N4014NHoffman Conrad D · Madison, SDBuilt 1947 · S/N 13472N4015BFletcher John G · Diamondhead, MSS/N 7BCM-401N4015ESeefeldt Richard K · Denver, COS/N 11BC-103N4016UThompson Don E · Long Beach, CABuilt 1965 · S/N 15061416N4017VSimpson James H · Craig, COBuilt 1948 · S/N 18336N40184Stoots David A · Fairbanks, AKBuilt 1958 · S/N 55245N4018BAven Michael R · Yorba Linda, CAS/N 7BCM-337N4018NHunsberger Robert E · Ramona, CABuilt 1947 · S/N 13476N4019BKapellair LLC · Wickenburg, AZS/N 7CCM-62N4019JPowell Edward H · Potsdam, NYBuilt 1966 · S/N 15065319N4019UWeeks Lindell M · Kingston, NHBuilt 1965 · S/N 15061419N4019VEastman Gregory L · Pueblo, COBuilt 1948 · S/N 18338N401FEasley Daniel W · Wasilla, AKBuilt 1953 · S/N 26115
Back to AD 94-05-05 R1