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.

N1471QRader Gregory · Baldwin City, KSBuilt 1971 · S/N 15072771N1471UEast Tenn Pilots Club Inc · Knoxville, TNS/N 17267138N1472FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273007N1472UEbben Robert A · New London, WIS/N 17267139N1473FSilveira Paul J · Valdez, AKS/N 18502851N1473M182p LLC · Oklahoma City, OKBuilt 1975 · S/N 18264340N1473SBattin Robert C · Cartersville, GABuilt 1976 · S/N 18265020N1473YPetty James F · Crandall, GABuilt 1962 · S/N 17249173N1474ESuffolk County Police Pilots Assoc · Bayport, NYBuilt 1978 · S/N 17271015N1474FJlb Aviation Services LLC · Woodbine, NJBuilt 1979 · S/N 17273008N1474UHentges Jerry J · Morris, MNBuilt 1976 · S/N 17267141N1475FAc Group LLC · Helena, MTBuilt 1975 · S/N 18502853N1475SMurdoch-Haig Alexandra · Kailua, HIBuilt 1976 · S/N 18265022N1475VGlobal Flight Training Solutions Inc · Immokalee, FLS/N 17263610N1475YAbe Lincoln Flyers Inc · Lincoln, ILBuilt 1962 · S/N 17249175N1476QHarley Dennis E Sr · Cole Camp, MOBuilt 1971 · S/N 15072776N1476SBk1 Farms LLC · Rock Port, MOBuilt 1976 · S/N 18265023N1476UTampa Bay Aviation Inc · Clearwater, FLBuilt 1976 · S/N 17267143N1476YHamilton Gene A · Saegertown, PABuilt 1962 · S/N 17249176N1477FMavity Reagan Chase · Clayton, GABuilt 1966 · S/N 17254972N1477VSatermo Lee John · New Town, NDBuilt 1974 · S/N 17263612N1478FElliott Gabrial Adam · Hollywood, ALBuilt 1966 · S/N 17254973N1478MWestern Wind Aviation LLC · Suisun City, CABuilt 1975 · S/N 18264343N1478YCunningham Richard E · Lafayette, CABuilt 1962 · S/N 17249178N1479CBuilt Aviation LLC · Haymarket, VABuilt 1977 · S/N 17702735N1479EAero Capital Lending LLC · Miami, FLBuilt 1978 · S/N 17271016N1479USperoni Pablo · Vieques, PRBuilt 1976 · S/N 17267146N147JFour Seven Jays Flying Club Inc · Rapids City, ILBuilt 1973 · S/N 17262545N147KLarson David W · New Iberia, LABuilt 1975 · S/N 18264068N147MCSoloman Lynell J · Forks, WABuilt 1976 · S/N 18265026N147MLPatton Andrew Joseph · Andrews, INBuilt 1968 · S/N 17701000N147NCorr Aviation Inc · Oxford, MSBuilt 2021 · S/N 208B5626N147SHDe Camara Robert Michael · Boone, NCS/N 185-0960N147TXTexas Department Of Transportation · Austin, TXBuilt 1979 · S/N U20604987N147WFConsolidated Aero LLC · Gibsonville, NCBuilt 1981 · S/N 425-0119N1480SAll In One Aviation LLC · Burleson, TXBuilt 1976 · S/N 18265027N1480USchaad Michael · Yorba Linda, CABuilt 1976 · S/N 17267147N1481STraylor Margie · Cave Creek, AZBuilt 1976 · S/N 18265028N1481VTalbert Barbara E · Wesley Chapel, FLBuilt 1974 · S/N 17263615N1481YPoole Timothy W · Lyons, GABuilt 1962 · S/N 17249181N1482VGriffin Samuel · Doniphan, MOBuilt 1974 · S/N 17263616N1482YSamuelian Jenna A · Tehachapi, CABuilt 1962 · S/N 17249182N1483MMaster Aviation LLC · Augusta, GAS/N 18264348N1483QAttax LLC · Missoula, MTBuilt 1971 · S/N 15072783N1483UJohnson William Scott · New Market, TNBuilt 1976 · S/N 17267150N1483VRankin Kevin · Maryville, MOS/N 17250241N1484QIntegrated Structural Services Inc · Ringgold, GABuilt 1971 · S/N 15072784N1484SRegistration Pending · Gualala, CARegistration pendingBuilt 1976 · S/N 18265031N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151N1484YHarrison Dennis N · New London, MOS/N 17249184
Back to AD 97-01-13