OpenAirDocs.org
AD 77-07-05 R1

Registered aircraft · 221

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:77-07-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:77-07-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.

N6417VStokes Teddie V · Holly Pond, ALBuilt 1952 · S/N 417N6470Slikker Flying Service Inc · Buttonwillow, CABuilt 1963 · S/N 1601N64764Registration Pending · Riverbank, CARegistration pendingBuilt 1952 · S/N 489N65048Bartlett Robert E · Cleveland, TXBuilt 1964 · S/N 1722N65NWFour Creeks Aviation Inc · Visalia, CABuilt 1964 · S/N 2364N67016Grein Darrell L · Cypress, TXS/N 492N67065Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1957 · S/N 1023N67155Horizon Helicopters LLC · Toms River, NJBuilt 1961 · S/N 1335N6744CKiska Farms Inc · Pasco, WAS/N 556N686PSimply Living LLC · Fort Myers, FLS/N 592783N68962Pockrus Pat B · Mineral Wells, TXS/N 104N689HSTexxon Resources Inc · Winter Park, FLBuilt 1959 · S/N 1169N69085Clarcq Richard D · Cohocton, NYS/N 103N702WAFort Wolters Helicopter Inc · Mineral Wells, TXS/N 2185N703WAAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1963 · S/N 2276N70904Fort Wolters Helicopter Inc · Mineral Wells, TXS/N 5100N7090QFort Wolters Helicopter Inc · Mineral Wells, TXS/N 2248N7090VFort Wolters Helicopter Inc · Mineral Wells, TXS/N 5181N7173FFour Creeks Aviation Inc · Visalia, CAS/N 2011N7173SCraig Helicopters Inc · Craig, COBuilt 1965 · S/N 2351N71NWFour Creeks Aviation · Visalia, CABuilt 1962 · S/N 1315N7212HCarriveau Vincent A · Franksville, WIBuilt 1956 · S/N 212N727JRMiddlestetter Matt · Camp Sherman, ORBuilt 1953 · S/N 571N7299Classic Rotors Museum · Ramona, CABuilt 1955 · S/N 729N73875Husby Jeff · Eau Claire, WIBuilt 1964 · S/N WH6002N76431Four Creeks Aviation Inc · Visalia, CABuilt 1958 · S/N 992N780CHousken George E · Gardnerville, NVBuilt 1956 · S/N 780N783TTSpengler Raymond Frances Jr · Longview, TXBuilt 1956 · S/N 783N80CBAero-Tech Helicopters LLC · Kingstree, SCS/N 5048N8109HRagan Randall R · Sarasota, FLBuilt 1949 · S/N 109N8116HThompson John A Trustee · Carson City, NVBuilt 1949 · S/N 116N8117HWilliams Charles S · Anacoco, LABuilt 1949 · S/N 117N8178HRotor Wing Nuts LLC · Kansas City, MOBuilt 1950 · S/N 178N8180HPockrus Pat B · Mineral Wells, TXBuilt 1950 · S/N 180N853BBSaile 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 5085N900JRHoelzen Robert D Trustee · Kent, WABuilt 1952 · S/N 664N9010QYearwood John F · Georgetown, TXBuilt 1955 · S/N 804N9019TBerry Darrel L · Camden, TNS/N 697N90424Meeks William M III · Tulsa, OKBuilt 1951 · S/N 389N90476Lyle Daniel · Westmoreland, KSS/N 2367N90580Lloyd Brian P · Spring Branch, TXBuilt 1951 · S/N 298N9063LKnutson Flying Service Inc · Tioga, NDBuilt 1965 · S/N 1801N90724Marsh Thomas R · Washington, DCS/N 810N909BCFort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1964 · S/N 1626N91556Botich David A DBA · Clark Fork, IDBuilt 1952 · S/N 300N920HAMshr Helicopter Service LLC · Chehalis, WABuilt 1962 · S/N 1361
Back to AD 77-07-05 R1