OpenAirDocs.org
AD 97-02-13

Registered aircraft · 35

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

N154ACHelicopter Express LLC · Chamblee, GABuilt 1967 · S/N 64037N159ACHelicopter Express LLC · Chamblee, GABuilt 1970 · S/N 64084N172ACHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 64061N173ACHelicopter Express LLC · Chamblee, GABuilt 1967 · S/N 64015N176ACHelicopter Express LLC · Chamblee, GABuilt 1962 · S/N 64003N178ACHelicopter Express LLC · Chamblee, GABuilt 1971 · S/N 64097N179ACHelicopter Express LLC · Chamblee, GABuilt 1970 · S/N 64091N189ACHelicopter Express LLC · Chamblee, GABuilt 1997 · S/N 641001N194ACHelicopter Express LLC · Chamblee, GABuilt 1967 · S/N 64017N217ACHelicopter Express LLC · Chamlee, GABuilt 1968 · S/N 64064N218ACHelicopter Express LLC · Chamblee, GABuilt 1967 · S/N 64033N243ACHelicopter Express LLC · Chamblee, GABuilt 1967 · S/N 64022N4035SSiller Helicopters LLC · Chamblee, GABuilt 1975 · S/N 64099N4037SSiller Helicopters LLC · Chamblee, GABuilt 1975 · S/N 64101N600HXHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 64081N610HXHelicopter Express LLC · Chamblee, GABuilt 1967 · S/N 64F5001N615HXHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 64065N623HXSiller Helicopters LLC · Chamblee, GABuilt 1994 · S/N 66-18411N625HXHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 64034DN630HXHelicopter Express LLC · Chamblee, GABuilt 1993 · S/N 64093N655HXHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 64052N6962RHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 64058N6979RU S Leaseco Inc · Aurora, ORBuilt 1968 · S/N 64079N7095BSiller Helicopters LLC · Chamblee, GABuilt 1994 · S/N 67-18430N715HTU S Leaseco Inc · Aurora, ORBuilt 1969 · S/N 69-18470N716HTU S Leaseco Inc · Aurora, ORBuilt 1969 · S/N 69-18484N718HTU 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-18468N792HTU S Leasco Inc · Aurora, ORBuilt 1968 · S/N 68-18447N793HTU S Leaseco Inc · Aurora, ORBuilt 1967 · S/N 67-18427N795HTU S Leaseco Inc · Aurora, ORBuilt 1968 · S/N 6818458N9125MSiller Helicopters LLC · Chamblee, GABuilt 1968 · S/N 68-18455
Back to AD 97-02-13