AD 76-06-01

Registered aircraft · 77

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:76-06-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:76-06-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.

N715HTU S Leaseco Inc · Aurora, ORBuilt 1969 · S/N 69-18470N716HTU S Leaseco Inc · Aurora, ORBuilt 1969 · S/N 69-18484N718HGConstruction Helicopters LLC · Howell, MIS/N 61718N718HTU S Leaseco Inc · Aurora, ORBuilt 1969 · S/N 69-18467N719HTU S Leaseco Inc · Aurora, ORS/N 69-18469N720HTUS Leaseco Inc · Aurora, ORS/N 69-18463N721HTU S Leaseco Inc · Aurora, ORBuilt 1969 · S/N 69-18466N722HTUS Leaseco Inc · Aurora, ORBuilt 1969 · S/N 69-18468N745AWCoulson Aviation USA Inc · Portland, ORS/N 61745N7563WWithrotor Aviation Inc · Lakeview, ORS/N 61752N760HTU S Leaseco Inc · Aurora, ORBuilt 1978 · S/N 61811N761HGConstruction Helicopters LLC · Howell, MIBuilt 1977 · S/N 61761N762HTUS Leaseco Inc · Aurora, ORBuilt 1976 · S/N 61755N765AWCroman Corp · White City, ORBuilt 1976 · S/N 61765N773WC61 Me LLC · Wichita, KSBuilt 1978 · S/N 61807N775HGConstruction Helicopters LLC · Howell, MIBuilt 1977 · S/N 61775N804ARCroman Corp · White City, ORBuilt 1964 · S/N 61222N825WLHeligroup Fire LLC · Missoula, MTBuilt 1980 · S/N 61825N826WCConstruction Helicopters LLC · Howell, MIBuilt 1980 · S/N 61826N827HGConstruction Helicopters LLC · Howell, MIBuilt 1980 · S/N 61827N833ARCroman Corp · White City, ORBuilt 1974 · S/N 61738N904CHConstruction Helicopters LLC · Howell, MIBuilt 1977 · S/N 61777N905CHConstruction Helicopters LLC · Howell, MIS/N 61711N906CHConstruction Helicopters LLC · Howell, MIBuilt 1971 · S/N 61490N907CHHeligroup Fire LLC · Missoula, MTBuilt 1979 · S/N 61819N91158US Leaseco Inc · Aurora, ORBuilt 1968 · S/N 61424N968CLClayton International Inc · Peachtree City, GABuilt 1978 · S/N 61816
Back to AD 76-06-01