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.

N2873YMorris Ben M · Albany, GABuilt 1962 · S/N 18253873N2874KWashburn Kent F · Grants Pass, ORBuilt 1979 · S/N 18053110N2874LSchirack John · Decatur, INBuilt 1967 · S/N 17256074N2875LDavenport Ross K · Raleigh, NCBuilt 1967 · S/N 17256075N2875QLani Lea Sky Tours LLC · Honolulu, HIBuilt 1971 · S/N 17259875N2875SHolland Van D · Sandy Valley, NVBuilt 1967 · S/N 15066775N2875UWalter Karl F · Fayetteville, GABuilt 1963 · S/N 17250475N2876FJohnston Natalie R · Edgewood, TXBuilt 1966 · S/N 18256976N2876SRay Charlie B · Prosser, WAS/N 15066776N2876UPianalto David · Wichita, KSBuilt 1963 · S/N 17250476N2876YForbes Richard L · Plano, TXBuilt 1962 · S/N 18253876N2877ADutremble Donald L · Amherst, NHBuilt 1953 · S/N 30077N2877SWarner David F · Altoona, IABuilt 1967 · S/N 15066777N2877UMelin James · Livingston, MTBuilt 1963 · S/N 17250477N2877XJim Doherty Trucking Inc · Sacramento, CABuilt 1967 · S/N 17700277N2877YBrumback Recreation LLC · Bluffdale, UTBuilt 1962 · S/N 18253877N2878AAero Garage Inc · Fort Myers, FLS/N 30078N2878LHolbrook David A · Toccoa, GABuilt 1967 · S/N 17256078N2878QFields Williams H · Greensboro, NCBuilt 1971 · S/N 17259878N2879FMinich Sophie R · Anchorage, AKS/N 18256979N2879KTwo Niner Kilo LLC · Seattle, WABuilt 1979 · S/N 18053115N2879QBlue Side Aviation LLC · Tampa, FLBuilt 1971 · S/N 17259879N2879XGregoire Louis Bernard III · Blairsville, GABuilt 1967 · S/N 17700279N287BWDaniels Kelly M · Humble, TXBuilt 1979 · S/N R18201329N287TCAiv Con Inc · Charlevoix, MIBuilt 1969 · S/N 18260183N2880EDemulling Michael C · New Richmond, WIBuilt 1978 · S/N 17271358N2880RPhelps Thomas J · Orem, UTBuilt 1967 · S/N 18258480N2880SHigh Exposure Inc · Wilmington, DEBuilt 1967 · S/N 15066780N2880XGerstung Dennis R · Anchorage, AKBuilt 1967 · S/N 17700280N2880YRegistered aircraftBuilt 1962 · S/N 18253880N2881FAirplanes Over Niagara LLC · Lewiston, NYBuilt 1966 · S/N 18256981N2881LCore Alan L · Indianola, IABuilt 1967 · S/N 17256081N2881QNeenah Aircraft Leasing LLC · Neenah, WIBuilt 1971 · S/N 17259881N2881SSerbus Gary E · Olivia, MNBuilt 1967 · S/N 15066781N28822Edwards Gordon O · Casper, WYBuilt 1966 · S/N 15063015N2882YVx Aviation LLC · Palisade, COBuilt 1962 · S/N 18253882N28835Waddingham William B · Rancho Cucamonga, CABuilt 1969 · S/N 421A-0050N2883RCallegari Sergio P · Reno, NVBuilt 1967 · S/N 18258483N2883UPaul Aviation LLC · Sault Sainte Marie, MIBuilt 1963 · S/N 17250483N2883XRamano Raymond C · Napa, CABuilt 1967 · S/N 17700283N2884ADowns M Todd · De Leon, TXFirst renewal noticeBuilt 1953 · S/N 30084N2884FTurner Michael B · Covington, TNBuilt 1966 · S/N 18256984N2884KJ Robert Finley And Associates Inc · Mountain Home, ARBuilt 1979 · S/N 18053118N2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeBuilt 1967 · S/N 18258484N2884UEast Tenn Pilots Club Inc · Knoxville, TNBuilt 1963 · S/N 17250484N2884YTri-Aviation Inc · Amarillo, TXBuilt 1962 · S/N 18253884N2885LBlevens George A Jr · Franklin, KYS/N 17256085N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885N2885SWinter Thomas N · Lincoln, NEBuilt 1967 · S/N 15066785N2885UEda4 LLC · Cresson, TXBuilt 1963 · S/N 17250485
Back to AD 97-01-13