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.

N2977JBandy Suzanne M · Newport, ORS/N 15065777N2977NFarrell Tammy J · Sterling, AKBuilt 1947 · S/N 13235N2977VKnott Brody · Camarillo, CABuilt 1974 · S/N 15076340N2978SRoach David · Modena, NYS/N 15066878N2979DParker Benjamin E · Wasilla, AKS/N 26922N2979JStygar Richard M · Coal City, ILBuilt 1966 · S/N 15065779N2979ZHickle William H · Inyokern, CABuilt 1959 · S/N 18-7090N2980JOrsak Eddie J · Seymour, TXBuilt 1966 · S/N 15065780N2982HBarnstormers Club LLC · Cape Coral, FLBuilt 1946 · S/N 3607N2982JTijman Esteban M · Potomac, MDBuilt 1966 · S/N 15065782N2982NNewman Richard D · South Beach, ORBuilt 1947 · S/N 13240N2982SHerzog Daniel L · Clinton, MIS/N 15066882N2983DIngalsbe David L · Flowery Branch, GABuilt 1955 · S/N 26926N2983NCmr Aviation LLC · Perry, UTBuilt 1947 · S/N 13241N2984JBell Edward A · Richfield, OHBuilt 1966 · S/N 15065784N2984UJuris Ronald D · Bickleton, WABuilt 1966 · S/N 17255040N2985JScott Jason Eton · Seattle, WABuilt 1966 · S/N 15065785N2985NMcvay Myron A · Auburndale, FLBuilt 1947 · S/N 13243N2985UConnersville Flying Club Inc · Connersville, INBuilt 1963 · S/N 17250585N2986JWylam Thomas S · Ocala, FLBuilt 1966 · S/N 15065786N2986NChartier Michael W · Las Vegas, NVBuilt 1947 · S/N 13244N2986SHouglan Norman L · Shepherdsville, KYBuilt 1967 · S/N 15066886N2986ULuebke Austin D · Corsica, SDS/N 17250586N29876Kegin Kevin M · Salem, ILS/N 2727N2987DScheda Mark R · Brockport, NYBuilt 1955 · S/N 26930N2987UMott Charles A Jr · Chesapeake, VABuilt 1963 · S/N 17250587N2988DBrown Hector M · Glenwood Springs, COBuilt 1955 · S/N 26931N2988HKramer Craig W · Dyersville, IABuilt 1946 · S/N 3613N2988JRegistration Pending · Asotin, WARegistration pendingBuilt 1966 · S/N 15065788N2988UFrost Eddy L · Bishop, TXS/N 17250588N2989JWright Brandon C · Cave City, KYS/N 15065789N2989UGodinez Mauricio U · San Diego, CABuilt 1963 · S/N 17250589N298SQEastern Stearman Inc Trustee · Leesburg, VABuilt 1952 · S/N 18-1586N2990JHale Randall C · Bloomburg, TXS/N 15065790N2990NPaulson Michael J · Fargo, NDBuilt 1947 · S/N 13248N2990SAndresen Paul S · Chandler, AZS/N 15066890N2990UShiny Pigeon LLC · Fort Worth, TXBuilt 1963 · S/N 17250590N2991SVanbrocklin Valerie A · Anchorage, AKBuilt 1967 · S/N 15066891N2991UNeary Joseph P · Lindenhurst, ILBuilt 1963 · S/N 17250591N2992DArnold Scott M · Peachtree City, GAS/N 26935N2992SN2992s LLC · Bristol, VTBuilt 1967 · S/N 15066892N2993DBcw Aviation LLC · Sigourney, IABuilt 1955 · S/N 26936N2993KLee Robert E · Medford, WIBuilt 1947 · S/N 5720N2993SCintron Jaime · Lake City, FLS/N 15066893N2993U63 Aviation LLC · Petoskey, MIBuilt 1963 · S/N 17250593N2993ZKrupinski Floyd M · Chugiak, AKBuilt 1959 · S/N 18-7112N2994DAncam Lc · West Burlington, IABuilt 1955 · S/N 26937N2995DPapoulias Michael A · Jackson, MIBuilt 1955 · S/N 26938N2995SWillard Kevin C · Bartlett, NEBuilt 1967 · S/N 15066895N2996DParker Stephen H · Montgomery, TXBuilt 1955 · S/N 26939
Back to AD 94-05-05 R1