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.

N3202CJohnson Jeremiah · Fairbanks, AKS/N 18262345N3202LMatta Figueroa Eduardo · Chapman, KSBuilt 1967 · S/N 17256102N3203UKuykendall Kirk O · Lakeside, ORS/N 18254603N3204DGriffith Sherman · Southlake, TXBuilt 1955 · S/N 32002N3204JBecker Charles A · Rice Lake, WIBuilt 1966 · S/N 15065904N3204UBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254604N3204XKulesza Roman · Noblesville, INBuilt 1967 · S/N 15064604N3205DWest James · Monroe, MIS/N 32003N3205UBanducci Debra L Trustee · Bakersfield, CABuilt 1963 · S/N 18254605N3205XAvery Jackson R · Ontario, ORS/N 15064605N3206DDenny Michelle L · Chugiak, AKBuilt 1955 · S/N 32004N3206EMorey Airplane Company Inc · Middleton, WIBuilt 1978 · S/N 17271467N3206SHall David J · Red Bluff, CABuilt 1964 · S/N 18255706N3207EArmstrong Aviation LLC · New Orleans, LABuilt 1978 · S/N 17271468N3207SSouthern Star Aviation LLC · El Campo, TXBuilt 1964 · S/N 18255707N3207UTaf Aerial Services LLC · Beeville, TXBuilt 1963 · S/N 18254607N3208JLandon Christopher L · Portland, ORBuilt 1966 · S/N 15065908N3208SZirul James V · Kenai, AKBuilt 1964 · S/N 18255708N3208UDiller Larry K · Fairview, MIBuilt 1963 · S/N 18254608N3208XRhodenbaugh Mitchel D · Wyndmere, NDBuilt 1966 · S/N 15064608N3208YHamilton Triple C Farms · Ririe, IDFirst renewal noticeBuilt 1962 · S/N 18254208N320DDBronson Robert D Trustee · Prineville, ORBuilt 1972 · S/N 17261193N320PCAom Aircraft LLC · Wilmington, DES/N 402B0621N320RMRd Harrison Inc · Lexington, NCS/N 340A0939N320SWEast West Investment Advisors LLC · Sandy Point, VABuilt 1980 · S/N 414A0451N3210PKilcullen Brian DBA · Fort Lauderdale, FLBuilt 1978 · S/N P21000027N3210SGore Range Aviators LLC · Kremmling, COBuilt 1964 · S/N 18255710N3210UHaas Todd · Pecatonica, ILBuilt 1963 · S/N 18254610N3210YBergren William · Des Moines, IABuilt 1962 · S/N 18254210N3211DNielson Donald L · Independence, ORBuilt 1955 · S/N 32009N3211EApm Leasing LLC · Casper, WYBuilt 1978 · S/N 17271470N3211JGo Captain LLC · Lake Worth, FLBuilt 1966 · S/N 15065911N3211SNoble Tom R · Winnsboro, TXBuilt 1964 · S/N 18255711N3211YFour M Properties LLC · Prague, OKBuilt 1962 · S/N 18254211N3212JBrown Joseph E · Palmdale, CABuilt 1966 · S/N 15065912N3212LBlackstone Rotorcraft Inc · Hartselle, ALBuilt 1967 · S/N 17256112N3212TRichmond Timothy R · Deland, FLBuilt 1967 · S/N 17700512N3213SRosengrants Matthew R · Walsh, COBuilt 1964 · S/N 18255713N3213XAlrubaiie Ihssan R · Fort Worth, TXBuilt 1966 · S/N 15064613N3213YFletcher Jerry D · Yukon, OKBuilt 1962 · S/N 18254213N3214TJohnson Hugh S · Rochester, NYBuilt 1967 · S/N 17700514N3214UBibus Michael A · Austin, MNBuilt 1963 · S/N 18254614N3215TMcgee Debra L · Tuscola, TXBuilt 1967 · S/N 17700515N3215XVoltmer Benjamin P · Excelsior Springs, MOBuilt 1966 · S/N 15064615N3216EChrabot Gerard S · Virginia Beach, VABuilt 1978 · S/N 17271471N3216MN3216m Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0826N3216TWss Aviation Inc · Jerseyville, ILBuilt 1967 · S/N 17700516N3216VTwo Dot Aircraft LLC · Kalispell, MTBuilt 1974 · S/N 15076424N3217JMalinchak Louis Trustee · Bristow, OKBuilt 1966 · S/N 15065917N3217SGrotbeck Christopher L · Albuquerque, NMBuilt 1964 · S/N 18255717
Back to AD 97-01-13