AD 75-10-01

Registered aircraft · 132

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:75-10-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-10-01')
  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.

N71NWFour Creeks Aviation · Visalia, CABuilt 1962 · S/N 1315N76431Four Creeks Aviation Inc · Visalia, CABuilt 1958 · S/N 992N80CBAero-Tech Helicopters LLC · Kingstree, SCS/N 5048N853BBSaile Daniel K · Skiatook, OKBuilt 1958 · S/N 1147N875WEEastern Stearman Inc Trustee · Leesburg, VAS/N 5183N88782Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1965 · S/N 1734N891HAHiller Aircraft Corp · Firebaugh, CAS/N HA3047N893FWFort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1979 · S/N 5085N90457Hiller Aviation Group Inc · Laveen, AZS/N 2507N90476Lyle Daniel · Westmoreland, KSS/N 2367N90483Hayes Jack D · Kingman, AZBuilt 1966 · S/N 2526N90487Hiller Aircraft Corp · Firebaugh, CABuilt 1966 · S/N 2533N9063LKnutson Flying Service Inc · Tioga, NDBuilt 1965 · S/N 1801N909BCFort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1964 · S/N 1626N9151THiller Aircraft Corp · Firebaugh, CAS/N 5089N920HAMshr Helicopter Service LLC · Chehalis, WABuilt 1962 · S/N 1361N922HAHiller Aviation Group Inc · Laveen, AZS/N 5015N9299ZBryant Jonathan E · Joaquin, TXS/N 1150N93456Ward Mark P · Wasilla, AKBuilt 1958 · S/N 1062N94515Hiller Aircraft Corp · Firebaugh, CAS/N 1172N945HADechene Corp · Big Lake, MNBuilt 1964 · S/N 2057N94APSummit Helicopters Inc · Salem, VABuilt 1959 · S/N 1211N95580Smith David B · Yakima, WABuilt 1962 · S/N 1444N95587Belnap Bob R · Vale, ORBuilt 1958 · S/N 1111N96071Slikker Flying Service Inc · Buttonwillow, CABuilt 1964 · S/N 1487N9631AMadden Russell E · Graford, TXS/N 1072/58-5423N9737CM&D Aerial LLC · Coleman, TXBuilt 1962 · S/N 2163N9749CSummit Helicopters Inc · Salem, VAS/N 2146N9754CLands End Transport Inc · Grand Junction, COBuilt 1961 · S/N 2149N9762CFort Wolters Helicopters · Mineral Wells, TXBuilt 1962 · S/N 2159N9785CSummit Helicopters Inc · Salem, VAS/N 2269N99262Slikker Flying Service Inc · Buttonwillow, CABuilt 1959 · S/N 1212
Back to AD 75-10-01