AD 97-01-13

Registered aircraft · 54,837

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-01-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-01-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.

N2765XBa Aviation LLC · Anacortes, WAS/N 18051565N2766FBrach Raymond S · Henderson, NVBuilt 1966 · S/N 18256866N2766JBedford Dennis · Auke Bay, AKBuilt 1975 · S/N A1500591N2766QThree Airmigos LLC · New Port Richey, FLBuilt 1967 · S/N 18257966N2766SJohnston Beryle Lee · Franklin, PABuilt 1967 · S/N 15066666N2767GBrowns Valley Aviation LLC · Utica, KYS/N 52067N2767LGay David B · Citronelle, ALBuilt 1967 · S/N 17255967N2767UFisher James S · Texarkana, TXBuilt 1963 · S/N 17250367N2768GCarrion John H · Colusa, CABuilt 1959 · S/N 52068N2768JRussell Mark Alex · Fairbanks, AKBuilt 1969 · S/N 185-1518N2768LJoseph Gary L · Ludlow, VTBuilt 1967 · S/N 17255968N2768SSibley Michael Neal · Kenai, AKBuilt 1971 · S/N 15066668N2768VRegistration Pending · Woodland Hills, CARegistration pendingBuilt 1975 · S/N 177RG0691N2768XMullett James L · Mccall, IDBuilt 1965 · S/N 18051568N2769FMatthews George W · Hillsboro, OHBuilt 1965 · S/N 18256869N2769GFraser Kevin J · Snohomish, WABuilt 1959 · S/N 52069N2769KMillennium Air Inc · Maurice, IAS/N 18053064N2769LRedditt Brian W · Columbia Station, OHBuilt 1967 · S/N 17255969N2769QPrecision Truck Equipment Inc · Lansing, ILBuilt 1967 · S/N 18257969N2769UMckinney Edward L · Candler, NCFirst renewal noticeBuilt 1963 · S/N 17250369N2769ZPacheco Ricardo · Albuquerque, NMBuilt 1956 · S/N 29077N276ACSmith Air Inc · Ukiah, CABuilt 1976 · S/N 21061442N276AKSalo Mark W · Poulsbo, WABuilt 1958 · S/N 50284N276CKHuckabee Charles J · Seadrift, TXBuilt 1982 · S/N R18201852N276MABank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 20800276N276NYFogarty Richard · Mandeville, LAS/N R1722393N2770FEmmons Jack E · Elizabeth City, NCBuilt 1965 · S/N 18256870N2770SBirk Ronald G · Wellington, NVBuilt 1967 · S/N 15066670N2770UStandard Equipment Leasing And Sales LLC · Wilmington, DEBuilt 1963 · S/N 17250370N2771GWhitt Sana F III · East Quogue, NYS/N 52071N2771LP&N Corp · Marion, IABuilt 1967 · S/N 17255971N2771UTobin Eric L · Cambridge, OHBuilt 1963 · S/N 17250371N2772JMagoffin David S · Fairbanks, AKBuilt 1969 · S/N 185-1522N2772LBell William E Jr · Summerville, SCBuilt 1967 · S/N 17255972N2772XBratten Douglas D · North Pole, AKBuilt 1965 · S/N 18051572N2773FAdriatic Holdings LLC · Cheyenne, WYBuilt 1966 · S/N 18256873N2773JN2773j LLC · Titusville, FLBuilt 1975 · S/N A1500596N2773VBeale Air Force Base Aero Club · Beale Afb, CABuilt 1975 · S/N 177RG0694N2773XLee Ty K · Anchorage, AKBuilt 1965 · S/N 18051573N2774JPerez Guillermo · Castaic, CABuilt 1979 · S/N 17273649N2774QRdj Brothers Trucking Inc · Bigfork, MTBuilt 1967 · S/N 18257974N2774SPeterson Dennis · Cambridge, MNBuilt 1967 · S/N 15066674N2774XElk Creek Investments LLC · Helena, MTBuilt 1965 · S/N 18051574N2775EFaulkner Harry E Jr · Bethel, AKBuilt 1978 · S/N 17271316N2775FJock Carl A Trustee · Roscommon, MIBuilt 1966 · S/N 18256875N2775LKing Mons A · Paoli, PABuilt 1967 · S/N 17255975N2775QRay Chris J · Ironside, ORBuilt 1967 · S/N 18257975N2775RMiller David · Tyler, TXBuilt 1980 · S/N 172RG0624N2775SRichardson Arthur · Herald, CAS/N 15066675N2775ULuff John W · Odessa, MOBuilt 1963 · S/N 17250375
Back to AD 97-01-13