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.

N3572Kindred Douglas G · Eugene, ORBuilt 1971 · S/N P553N3572CFrasca John A · Champaign, ILBuilt 1954 · S/N 26616N3572JUpchurch Air And Sea LLC · Fort Lauderdale, FLBuilt 1965 · S/N 15061272N3572SWeidman Paul D · Lebanon, PABuilt 1963 · S/N 17250772N3572THaase Israel A · Wasilla, AKBuilt 1975 · S/N F-033N3572VRoberts Nigel C · The Plains, VABuilt 1948 · S/N 14955N3573DBohl Howard M Jr · Long Beach, CABuilt 1956 · S/N 27116N3573LGlasgow Jason D · Tecumseh, OKBuilt 1965 · S/N 15062373N35745Smith Robert D · Roanoke, TXS/N 5-747N3574LMillican Marc J · Anchorage, AKFirst renewal noticeBuilt 1965 · S/N 15062374N3574TCalifornia Airways LLC · Hayward, CABuilt 1975 · S/N F-040N3574VRau Bradley W · Payette, IDS/N 14749N3575DTufts Peter A · Bethel, CTBuilt 1956 · S/N 27118N3575JSv Aviation LLC · Gilbert, AZBuilt 1965 · S/N 15061275N3575VSale Reported · Acworth, GASale reportedS/N 15076552N35764Routh Gary L · Lebanon, TNBuilt 1941 · S/N 5-758N3576CRamaswamy Gautam · Clearwater, FLS/N 26620N3576DVorpagel Stephen L · Readfield, MEBuilt 1956 · S/N 27119N3576SGarrison Jerry L · Leavenworth, KSBuilt 1963 · S/N 17250776N3576TSplonskowski Steven J · Oregon City, ORBuilt 1975 · S/N F-042N3576ZRaymond Jeff R · Fairbanks, AKBuilt 1960 · S/N 18-7365N3577CCrystoff James J · Kodiak, AKBuilt 1954 · S/N 26621N3577JArvo Aviation LLC · Newport Beach, CABuilt 1965 · S/N 15061277N3577LWimpey Robert J · Roundhill, KYBuilt 1965 · S/N 15062377N3577STorman Kevin B · Umatilla, FLBuilt 1963 · S/N 17250777N3577TChaplin Lyndon Yeager · Anchorage, AKBuilt 1975 · S/N F-043N3578JCaswell David B · Owosso, MIBuilt 1965 · S/N 15061278N3578SHigley Jon · Jerome, IDS/N 17250778N3578TMeachen Jeffry · Chippewa Falls, WIBuilt 1975 · S/N F-044N3578V198 Main Street Aviation LLC · Sullivan, WIBuilt 1948 · S/N 14747N35793Mcenery Brian T · Elmendorf, TXBuilt 1941 · S/N 5-770N3579CA&J Aeronautics LLC · Nerstrand, MNS/N 26623N3579DSchumacher Thad A · Wasilla, AKBuilt 1957 · S/N 27122N3579TWilke Daniel D · Fairmount, NDBuilt 1975 · S/N F-045N3579VGreslin Michael D · Spearfish, SDBuilt 1948 · S/N 14748N357BFRezac Lauren J · Wichita, KSBuilt 1942 · S/N 8854N357HPAllred Thierry J · Casa Grande, AZBuilt 1946 · S/N 8836N35809Merritt Robert L · Afton, WYBuilt 1941 · S/N 6607N3580JJamieson Robert F · Friday Harbor, WABuilt 1965 · S/N 15061280N3580TYliniemi Glenn C · Frazee, MNBuilt 1975 · S/N F-046N3580ZRoma Air Corp · Belle Glade, FLBuilt 1960 · S/N 18-7370N35819Erickson Mark D · Valley Springs, SDS/N 5-781N3581FSkyline Aviation Services LLC · Miramar, FLBuilt 1973 · S/N A1500413N3581HDickard Gary D · Kimberly, IDBuilt 1947 · S/N 4206N3581NClement Jesse W · Louisville, KYBuilt 1947 · S/N 22822N3581VBryan Les E · Evansville, INBuilt 1948 · S/N 14850N35822Mcrobie Roger L · Maryville, TNBuilt 1941 · S/N 5-786N3582CBenedict Larry D · Dexter, NMBuilt 1955 · S/N 26626N3582DFrench Guy · Maple Valley, WABuilt 1956 · S/N 27125N3582JMorris Jon · Thatcher, AZBuilt 1965 · S/N 15061282
Back to AD 94-05-05 R1