OpenAirDocs.org
AD 80-04-04 R1

Registered aircraft · 341

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:80-04-04-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:80-04-04-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.

N64702Hendrickson Flying Service Inc · Rochelle, ILBuilt 1962 · S/N 2706N64741Misner Everett L · Harlowton, MTBuilt 1976 · S/N 2189N65520Sale Reported · Troy, MOSale reportedBuilt 1957 · S/N 2012N67065Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1957 · S/N 1023N6707DMines Keith A · White Cloud, MIBuilt 1958 · S/N 2187N6711DAnderson Christopher T · Janesville, WIBuilt 1958 · S/N 2192N67155Horizon Helicopters LLC · Toms River, NJBuilt 1961 · S/N 1335N6720DNorthwind Hilos LLC · Schoolcraft, MIBuilt 1958 · S/N 2204N6744DDyer Randall J · Frazier Park, CAS/N 2238N6749DCj Air LLC · Nezperce, IDBuilt 1959 · S/N 2240N6750DMorten Jesse L · Larimore, NDBuilt 1959 · S/N 2241N6758DCaruso Dennis · Saint Marys, PAS/N 2249N6774DSouthern Cross Aviation · Wilmington, DES/N 2450N6776DMilam Inc · Trussville, ALBuilt 1959 · S/N 2439N6784DNorth Coast Helicopter Svc Inc · Napa, CABuilt 1960 · S/N 2589N689HSTexxon Resources Inc · Winter Park, FLBuilt 1959 · S/N 1169N693CWSale Reported · Oklahoma City, OKSale reported, pending cancellationBuilt 1980 · S/N 7328B633N703WAAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1963 · S/N 2276N7060JWilbur-Ellis Co · Salinas, CABuilt 1970 · S/N 25017N715BHWilbur-Ellis Co · Salinas, CABuilt 1973 · S/N 25105N7162MFast Toys For Boys Inc · Wenatchee, WABuilt 1967 · S/N 7569N73207Hendrickson Flying Service Inc · Rochelle, ILBuilt 1962 · S/N 2697N73223Churchill Scott W · Le Sueur, MNBuilt 1962 · S/N 2722N73228Wheatley Lester E Jr · Priest River, IDS/N 1862N73249English Air Service LLC · Georgetown, TXBuilt 1964 · S/N 2781N73279Mc Helicopter LLC · Summerfield, FLS/N 3134N73286Sze Alexander · San Francisco, CABuilt 1964 · S/N 2882N737MCCoggin Mark · Burleson, TXBuilt 1967 · S/N 7560N73905Fingerlakes Wing And Rotor LLC · Seneca Falls, NYBuilt 1963 · S/N 2860N73907Denlinger Darin · Modesto, CABuilt 1962 · S/N 2857N73943Green Rick A · Hudson, IAS/N 2862N73953Ritel Copter Service Inc · Hudson, IABuilt 1963 · S/N 2866N73960Celebrate Freedom Foundation Inc · West Columbia, SCS/N 2839N73966Forbis Michael J · Calera, OKS/N 2871N73974Triple F Flying Inc · Benton, PABuilt 1964 · S/N 2874N74822Nockair Inc · Longboat Key, FLBuilt 1964 · S/N 456N7574Charles Farms Inc · Lancaster, PABuilt 1961 · S/N 2665N7575Barr Andrew B · Beulah, MSBuilt 1960 · S/N 2463N7576Classic Rotors Museum · Ramona, CABuilt 1969 · S/N 2666N7578Scotts Helicopters Service Inc · Le Sueur, MNBuilt 1961 · S/N 2674N7579Coastal Helicopters Inc · Panama City, FLBuilt 1961 · S/N 2659N7730Gay Richard L · Middleville, MIBuilt 1968 · S/N K821N7764Reeves Mark S · Baldwinsville, NYBuilt 1970 · S/N K-7054N777TCCook Timothy · Byrdstown, TNBuilt 2018 · S/N 0834N77DPDt Pralle Enterprises Inc · Hampton, IABuilt 1965 · S/N 3343N7800SSlykerman John A · Bakersfield, CABuilt 1967 · S/N 7854N7801SRital Copter Service Inc · Hudson, IAS/N 7855N7832SSjd Aviation LLC · Nescopeck, PABuilt 1967 · S/N 7859N7836SWilbur-Ellis Co · Salinas, CABuilt 1967 · S/N 7860N7841SChurchill Scott W · Le Sueur, MNBuilt 1967 · S/N 7862
Back to AD 80-04-04 R1