OpenAirDocs.org
AD 97-06-07 R1

Registered aircraft · 27

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-06-07-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:97-06-07-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.

N250BGKilburn Brian · Parker, COBuilt 1994 · S/N 3025N28AYBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 3024N307EFU S Air Force Special Operations Command · Hurlburt Field, FLBuilt 1998 · S/N 3097N328MMBank Of Utah Trustee · Salt Lake City, UTS/N 3092N328STUS Air Force Special Operations Command · Hurlburt Field, FLBuilt 1997 · S/N 3086N329MXBay Aeroservices Inc · Austin, TXBuilt 1996 · S/N 3049N340LSUS Air Force Special Operations Command · Hurlburt Field, FLBuilt 1995 · S/N 3040N347EFU S Air Force Special Operations Command · Hurlburt Field, FLBuilt 1995 · S/N 3047N355EFU S Air Force Special Operations Command · Hurlburt Field, FLBuilt 1995 · S/N 3050N360EFUS Airforce Special Operations Command · Hurlburt Field, FLBuilt 1995 · S/N 3060N385EFU S Air Force Special Operations Command · Hurlburt Field, FLBuilt 1997 · S/N 3085N38CXBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 3034N391EFU S Air Force Special Operations Command · Hurlburt Field, FLBuilt 1997 · S/N 3091N524AWUS Air Force Special Operations Command · Hurlburt Field, FLBuilt 1994 · S/N 3020N525EFU S Air Force Special Operations Command · Hurlburt Field, FLBuilt 1999 · S/N 3106N545EFUS Air Force Special Operations Command · Hurlburt Field, FLBuilt 1997 · S/N 3093N565EFUS Air Force Special Operations Command · Hurlburt Field, FLBuilt 1998 · S/N 3068N570EFPrattville Turbine Engines LLC · Prattville, ALBuilt 1995 · S/N 3058N577EFU S Air Force Special Operations Command · Hurlburt Field, FLBuilt 1997 · S/N 3077N645HM645th Aeronautical Engineering Group (Aesg) · Wright Pat, OHBuilt 1994 · S/N 3013N825XTBank Of Utah Trustee · Salt Lake City, UTS/N 3035N907EFUS Air Force Special Operations Command · Hurlburt Field, FLBuilt 1998 · S/N 3104N90YPBank Of Utah Trustee · Salt Lake City, UTS/N 3044N929EFUS Air Force Special Operations Command · Hurlburt Field, FLBuilt 1994 · S/N 3026N941EFUS Air Force Special Operations Command · Hurlburt Field, FLBuilt 1994 · S/N 3016N953EFUS Air Force Special Operations Command · Hurlburt Field, FLBuilt 1995 · S/N 3075N975EFU S Air Force Special Operations Command · Hurlburt Field, FLBuilt 1995 · S/N 3031
Back to AD 97-06-07 R1