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.

N170FSShe-Rat Aviation Inc · Wilmington, DEBuilt 1956 · S/N 27126N170GAOtey Neil F · White Bear Lake, MNBuilt 1951 · S/N 19948N170HTJon Gibson Co · Cameron Park, CAS/N 20347N170JGivens Steve W · Pendleton, INBuilt 1948 · S/N 18471N170JACrosby Kenneth R · Trapper Creek, AKBuilt 1952 · S/N 25251N170JEBarrett John E · St Charles, ILBuilt 1953 · S/N 25501N170JGErbey Donald L · Wasilla, AKBuilt 1954 · S/N 26239N170JKSchreier James J · Fort Dodge, IABuilt 1955 · S/N 26948N170JLGodes Terry J · Soldotna, AKBuilt 1953 · S/N 25560N170JRRing John A · La Conner, WABuilt 1952 · S/N 20750N170JSDocjosh Ltd LLC · Essex, NYBuilt 1962 · S/N 15059706N170JTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1953 · S/N 25827N170JWStark David M · Merkel, TXS/N 25973N170KBBecker Kurt G · Dexter, NMBuilt 1956 · S/N 27103N170KHFossa Joseph S · Essex, MABuilt 1952 · S/N 25030N170KMMarlow Properties LLC - Marlow Aviation LLC Series · Knoxville, TNBuilt 1949 · S/N 19166N170KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 15079154N170KTHughes Michael D · Erie, COBuilt 1955 · S/N 26758N170KWCrews Cobert · Shady Shores, TXBuilt 1955 · S/N 26712N170LSchaible Peter J · Springfield, VABuilt 1954 · S/N 26252N170LCMacy Richard M · Lebanon, NEBuilt 1955 · S/N 26928N170LEArends Brian H · Mahomet, ILS/N 18271N170LMGlastonbury Michael C · Sioux Falls, SDS/N 18457N170MBCoffman Richard A II · Hernando, MSBuilt 1950 · S/N 19203N170MSMidstate Aviation Inc · Ellensburg, WAFirst renewal noticeBuilt 1953 · S/N 26085N170MWN88tg LLC · Fairbanks, AKBuilt 1952 · S/N 25411N170NDau Jason E · Fairbanks, AKBuilt 1955 · S/N 26899N170PBFancher Scott · Granite Falls, WABuilt 1950 · S/N 19800N170PPBarry Stephen J · Beaverton, ORBuilt 1955 · S/N 26695N170PRHicks Arch A · Oxford, NCBuilt 1953 · S/N 25686N170PSMcgavock Edward A · Columbus, WIBuilt 1951 · S/N 20152N170PTSabos Anthony J · Bolingbrook, ILBuilt 1950 · S/N 19300N170REBerbig Daniel J · Anchorage, AKBuilt 1953 · S/N 25922N170RHBas Part Sales LLC · Greeley, COBuilt 1947 · S/N 18030N170RKBelphegor LLC · Madison, WIBuilt 1953 · S/N 26053N170RPDejesus Kennet J · Troy, OHBuilt 1953 · S/N 25865N170RSWilson Benjamin A · Shawnee, KSBuilt 1950 · S/N 19611N170SBMacbean Stanley F Trustee · Orem, UTBuilt 1952 · S/N 25140N170SLSimmons Kenton L · Van Alstyne, TXBuilt 1948 · S/N 18138N170STDow Jeff W · Port Hadlock, WABuilt 1948 · S/N 18666N170TCGammelin Robert · Alta, WYBuilt 1949 · S/N 19183N170TPNorthrop John · Fairfield, CAFirst renewal noticeBuilt 1950 · S/N 19609N170UWBlocher Kristyn A · Tumwater, WABuilt 1948 · S/N 18403N170VPocock Milne David · Cal Nev Ari, NVBuilt 1952 · S/N 20656N170VWPratz Chris · Ellensburg, WABuilt 1952 · S/N 20592N170WRFinkel Charles M · Taylorsville, NCBuilt 1954 · S/N 26450N170WSSikorski Bradley · Colorado Springs, COBuilt 1950 · S/N 19490N170WYLarsen Michael S · Cody, WYBuilt 1954 · S/N 26592N170YPocock Milne D · Cal Nev Ari, NVBuilt 1953 · S/N 25882N17101Vasquez Juan E · Miami, FLBuilt 1972 · S/N 15073623
Back to AD 94-05-05 R1