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.

N9021RSky Horse Helicopters Inc · Brady, TXS/N CCI-165N9025Ocean Air Inc · Eugene, ORBuilt 1958 · S/N 2292N9043TBlair Helicopter Service Inc · Lemoore, CABuilt 1975 · S/N CCI74-10N9044THendrickson Flying Service Inc · Rochelle, ILBuilt 1975 · S/N CCI75-1N90457Hiller Aviation Group Inc · Laveen, AZS/N 2507N9045TScotts Helicopter Service Inc · Le Sueur, MNBuilt 1975 · S/N CCI-75-2N90476Lyle Daniel · Westmoreland, KSS/N 2367N90483Hayes Jack D · Kingman, AZBuilt 1966 · S/N 2526N90487Hiller Aircraft Corp · Firebaugh, CABuilt 1966 · S/N 2533N9061TSky Horse Helicopters Inc · Brady, TXBuilt 1975 · S/N CCI-75-3N9062TTriple F Flying Inc · Benton, PABuilt 1975 · S/N CCI-75-4N9088TSlykerman John A · Bakersfield, CABuilt 1978 · S/N CCI-78-2N9093TScotts Helicopter Services Inc · Le Sueur, MNS/N CCI78-5N909BCFort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1964 · S/N 1626N91184Enrich Simon P · Colorado Springs, COBuilt 1996 · S/N 1842N922HAHiller Aviation Group Inc · Laveen, AZS/N 5015N92358Simmons Aviation Services LLC · Pawcatuck, CTBuilt 1993 · S/N 4622147N9299ZBryant Jonathan E · Joaquin, TXS/N 1150N93WDWindsong Farms Ltd · Wilmington, DEBuilt 1967 · S/N 3797N9421HElliott Miles DBA · Porterville, CABuilt 1950 · S/N 178N94515Hiller Aircraft Corp · Firebaugh, CAS/N 1172N945HADechene Corp · Big Lake, MNBuilt 1964 · S/N 2057N9526Dykstra Donald J · Dorr, MIBuilt 1954 · S/N 1288-16N955West Thomas P · Bridgeport, OHBuilt 1965 · S/N 1409N95580Smith David B · Yakima, WABuilt 1962 · S/N 1444N95587Belnap Bob R · Vale, ORBuilt 1958 · S/N 1111N955BLambert Brian J · Owasso, OKBuilt 1954 · S/N 711N959Tailormade Aviation Inc · Middletown, DEBuilt 1956 · S/N 1501N9595BSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 6528N96071Slikker Flying Service Inc · Buttonwillow, CABuilt 1964 · S/N 1487N96194Wheatley Lester E Jr · Priest River, IDS/N 2702N96785Helvey Michael H · Sheridan, WYBuilt 1968 · S/N 3771N972BRegistration Pending · Mcqueeney, TXRegistration pendingBuilt 1959 · S/N 1320N9737CM&D Aerial LLC · Coleman, TXBuilt 1962 · S/N 2163N9749CSummit Helicopters Inc · Salem, VAS/N 2146N9754CLands End Transport Inc · Grand Junction, COBuilt 1961 · S/N 2149N9785CSummit Helicopters Inc · Salem, VAS/N 2269N99262Slikker Flying Service Inc · Buttonwillow, CABuilt 1959 · S/N 1212N993BSorenson Mark A · Senoia, GAS/N 1448N99628Jernigan Fred S · Falmouth, KYBuilt 1967 · S/N 6715924N999YZWheatley Lester E Jr · Priest River, IDS/N 1763
Back to AD 80-04-04 R1