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.

N189AROverstreet Investments Inc · Boonville, MOBuilt 2021 · S/N 208B5650N189CFRascher Lawrence · Pacific, MOS/N 18255465N189DCWorthan Gary T Trustee · Storm Lake, IABuilt 1976 · S/N 177RG0927N189ERMustang Sally Aviation LLC · Camden, SCBuilt 1974 · S/N 15076412N189JAPapillon Airways Inc · Kirkland, WABuilt 1969 · S/N 18259569N189MKS2ar Aviations LLC · Lantana, FLBuilt 1978 · S/N 414A0100N189SElfdog Aviation LLC · New Franken, WIBuilt 1960 · S/N 52778N189WMatta Figueroa Eduardo · Chapman, KSBuilt 1967 · S/N 17255907N189WHBonafide Investments LLC · Dover, DEBuilt 1969 · S/N 18052059N18ADEzs Flyers LLC · Bonduel, WIBuilt 1972 · S/N 18261116N18BBMuseum Of Flight Foundation · Seattle, WAFirst renewal noticeBuilt 1967 · S/N 337M0069N18BKShandog Air LLC · Ashland, KYS/N 310R0981N18CDDorman Richard E · Mesa, WABuilt 1964 · S/N 18051402N18CLAkro Attitudes Inc · Boynton Beach, FLS/N 52838N18DADye Paul C · Mcneal, AZBuilt 1977 · S/N 18503439N18DMRachal Randolph B · Taft, TXBuilt 1969 · S/N 18259374N18EBAll American Aviation LLC · East Helena, MTBuilt 1974 · S/N 17264188N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394N18FAFisher Russell D · Vacaville, CAS/N 15061212N18FGShapiro David Ely · Brookhaven, GABuilt 1974 · S/N 17264233N18HBBuermann Henry · Brookfield, VTS/N 30912N18HRJ & R Aviation LLC · Hamilton, OHBuilt 1967 · S/N 17256269N18HTTobler Niccolo Sunny · Anchorage, AKS/N 15282364N18JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1980 · S/N 17274513N18JLKlapmeier Alan · Iron River, WIBuilt 1974 · S/N P337-0165N18KKKhalil Kal Mohamed · Bedford, TXBuilt 1970 · S/N 15072224N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557N18NFR D Aviation LLC · Phoenixville, PABuilt 1967 · S/N 21058903N18NJTennessee Dept Of Saftey & Homeland Security · Nashville, TNBuilt 1978 · S/N R18200178N18NMRrcm Air LLC · Hialeah Gardens, FLBuilt 2016 · S/N 208B5303N18NRWonderful Pistachios & Almonds LLC · Lost Hills, CABuilt 2018 · S/N 20800610N18NSGilberto Alfonso · Washington, NCBuilt 1978 · S/N R1723066N18PBStogner Terry W · Lamesa, TXBuilt 1967 · S/N 18258216N18PWPhenix LLC · Dayton, WABuilt 1963 · S/N 21058192N18SBTroy Motz Construction Inc · Lincolnton, NCBuilt 1978 · S/N 18266338N18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeBuilt 1975 · S/N 310R0560N18STYoung Shawna Hodges · Turlock, CABuilt 1973 · S/N 17261795N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144N18TBCarlson Herb Trustee · Dana Point, CABuilt 1981 · S/N 18267978N18TCAviotti Inc · Henderson, NVBuilt 1978 · S/N 421C0503N18TKMcpherson Kathrynne Alexine Trustee · Twin Falls, IDBuilt 1961 · S/N 18253360N18TLCarey Nicolas J · Rosamond, CAS/N 18259225N18VUVincennes University · Vincennes, INBuilt 1977 · S/N 310R0928N18WLMiller Christopher M · Centreville, VABuilt 1981 · S/N 18053178N18YZHightower Ronny · Blanchard, OKBuilt 1975 · S/N 15076721N18ZKHappy Cat Cay LLC · Coral Gables, FLBuilt 2019 · S/N 208B5513N18ZPPierce Lestley R · Henderson, NVS/N 18263562N19004N19004 LLC · Bend, ORBuilt 1972 · S/N 15074084N19005Riddell Scott A · Winchester, KYBuilt 1972 · S/N 15074085N1900UBismarck Aero Center · Bismarck, NDBuilt 1979 · S/N 17273162
Back to AD 97-01-13