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.

N2563ZWien Richard A · Fairbanks, AKBuilt 1963 · S/N 185-0563N2564GGarrison Jeffrey R · Clemson, SCBuilt 1959 · S/N 51864N2564RBusse William J · Twin Lakes, WIBuilt 1967 · S/N 18258264N2564UBurris Bruce · Deer Park, WAS/N 17250164N2564VMay Matthew J · Weatherford, TXBuilt 1974 · S/N 177RG0617N2564YBrewer George H · Muskegon, MIBuilt 1962 · S/N 17249864N2564ZDownwind Aviation LLC · Kodiak, AKBuilt 1963 · S/N 185-0564N2565GMoore Timothy L · Wendell, IDBuilt 1959 · S/N 51865N2565JRohl Bradley S · Thompson, OHBuilt 1965 · S/N 15061065N2565RSanders David D · Alvin, TXBuilt 1967 · S/N 18258265N2566RRastetter Harold · Douglaston, NYBuilt 1967 · S/N 18258266N2566YAns Aircraft LLC · Midland, TXS/N 17249866N2567GSunrise Exploration Inc · Northport, WABuilt 1959 · S/N 51867N2567KBryant Kenneth D · Black Diamond, WABuilt 1978 · S/N 18052990N2567RGone Flying LLC · Loveland, OHBuilt 1967 · S/N 18258267N2567URegistration Pending · Fort Worth, TXRegistration pendingBuilt 1963 · S/N 17250167N2567VHarness Ben · Covelo, CAFirst renewal noticeBuilt 1976 · S/N R1722223N2568GKoechen Wayne L · Cooper Landing, AKBuilt 1959 · S/N 51868N2568ULuce Mark E · Tucson, AZBuilt 1963 · S/N 17250168N2569JMapes Peter B · Oscoda, MIS/N 15061069N2569KHarris Curtis M · Anchorage, AKS/N 18052991N2569SMatanane Roke C · Barrigada, GUBuilt 1968 · S/N 337-0869N2569UHalladay Roy · Erie, COBuilt 1963 · S/N 17250169N2569ZEitilt Aviation LLC · Parker, COBuilt 1963 · S/N 185-0569N256CAHyannis Air Service Inc · Hyannis, MAS/N 402C0606N256MWLease Air LLC · Moab, UTBuilt 1977 · S/N 17269958N256NYAlexander David H · Warrensburg, NYBuilt 1956 · S/N 29049N256RPAfrica Inland Mission International Inc · Peachtree City, GABuilt 1995 · S/N 208B0463N256SAAirview Inc · Ligonier, PABuilt 1983 · S/N R18201967N256SJSan Juan Aviation LLC · Wilmington, DEBuilt 1979 · S/N R1723166N256TETimberline Excuvation Inc · Fairbanks, AKBuilt 1969 · S/N U2061336N2570JKnutson Family Ltd Partnership 2 · Chetek, WIBuilt 1964 · S/N 15061070N2570LHerman John K Jr · Flagler, COBuilt 1967 · S/N 17255770N2570QGolden Thomas J · Bishop, GAS/N 18257770N2570RSkyblazers LLC · Boones Mill, VABuilt 1967 · S/N 18258270N2570ZLucci Robert J · Long Lake, NYBuilt 1963 · S/N 185-0570N2571GGolf Air LLC · Anchorage, AKBuilt 1959 · S/N 51871N2571JWullner Leeroy J · Cedar Rapids, IABuilt 1964 · S/N 15061071N2571LClements Jim L · Cushing, OKBuilt 1967 · S/N 17255771N25722Mitchell Brian J · Boise, IDBuilt 1963 · S/N 18051274N2572GMorgan Nathan · Boise, IDBuilt 1959 · S/N 51872N2572LBuick Robin B · Redding, CABuilt 1973 · S/N A1500485N2572RMladejovsky Michael G Trustee · Paulden, AZBuilt 1967 · S/N 18258272N2572SGwin Bryan · La Porte, TXBuilt 1976 · S/N 21061332N2572VJarvis Michael Lynn · Orem, UTBuilt 1974 · S/N 177RG0620N2573KDonham Sonjia F · Portland, ORBuilt 1978 · S/N 18052995N2573QJayviation Inc · Lake City, FLBuilt 1969 · S/N 21059173N2573VOldfield Raymond M Jr · Waupaca, WIBuilt 1974 · S/N 177RG0621N2573YFritz David C · Lincoln, NEBuilt 1960 · S/N 17247906N2574RChauvin Junius · Franklin, LAS/N 18258274
Back to AD 97-01-13