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.

N22716Rice Dwight D · Loma Linda, CABuilt 1968 · S/N 15068469N2271ESharmouj Raymond · St Croix, VIBuilt 1978 · S/N 17271215N2271XSantaska Inc · Palmer, AKBuilt 1965 · S/N 337-0171N22722Roshchepa Yuriy · West New York, NJS/N 15068475N22728Bero Patrick J · Pewaukee, WIBuilt 1968 · S/N 15068477N22729Gavriilidis Gavriil · Palm Harbor, FLFirst renewal noticeBuilt 1968 · S/N 15068478N2272GThompson Todd M · Manito, ILBuilt 1958 · S/N 51572N2272XSouthern Seaplane Inc · Belle Chasse, LABuilt 1970 · S/N U206-01556N2272YWilson Matthew C · Robinson, ILBuilt 1967 · S/N 17700072N22731Renehan Daniel G · Holly, MIBuilt 1968 · S/N 15068480N22738Barbaree Chan · Elba, ALBuilt 1968 · S/N 15068484N2273CCollins John J · Manitowoc, WIBuilt 1953 · S/N 30573N2273XAll Florida Recovery Corp · Palm Coast, FLS/N 337-0173N22741Wayne Brett M · Saint George, UTBuilt 1968 · S/N 15068486N2274JStone Kenneth R · Cedar Springs, MIBuilt 1966 · S/N 15065474N2274KSantee Cooper Aviation Inc · Saint Matthews, SCBuilt 1978 · S/N 18266454N2274PAvaero LLC · Worthington, OHBuilt 1973 · S/N 17261637N2274XDutko Adam M · Elyria, OHBuilt 1965 · S/N 337-0174N22752Flying Tigers Flight School Ltd · Houston, TXBuilt 1974 · S/N 17264075N22754Gomez Abigail S · Carlsbad, CABuilt 1974 · S/N 17264076N22758Clip Aire LLC · Mill Spring, MOBuilt 1968 · S/N 15068500N22759Park Forest South Aviation Group · Mount Prospect, ILBuilt 1968 · S/N 15068501N2275CCrusader Medical Consulting LLC · Boonville, INBuilt 1982 · S/N T30300085N2275KSutton Aircraft Salvage LLC · Palmer, AKS/N 51163N22765Registration Pending · Buckeye, AZRegistration pendingBuilt 1968 · S/N 15068503N2276GRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 1958 · S/N 51576N2276SBogaudo Robert J · Vulcan, MIBuilt 1979 · S/N R18201318N22771Whitney Walter F · Ham Lake, MNBuilt 1968 · S/N 15068508N2277SSimmons Matthew Steven · Port Orange, FLBuilt 1979 · S/N R18201319N2277YSheffield Richard Lee · Los Alamos, NMBuilt 1972 · S/N 18261225N22780Padgett Michael A · Ruffin, SCFirst renewal noticeS/N 15068510N22784Mayeko-Coklee Thomas · Lake Worth, FLS/N 15068512N22785Williams Jamar C · Louisville, KYBuilt 1968 · S/N 15068513N22788Jensen Rosemary · Quartz Hill, CABuilt 1968 · S/N 15068514N22792Belmar Aviation Inc · Lexington, KYBuilt 1968 · S/N 15068518N2279GParker Robert M · Hurst, TXBuilt 1958 · S/N 51579N2279JN2279j LLC · Burr Oak, MIBuilt 1966 · S/N 15065479N2279UChristenberry Paul O · Fayette, ALBuilt 1970 · S/N 18800659N2279XSander Farms Inc · Wilmington, DEBuilt 1965 · S/N 337-0179N227ANCalifornia In Nice Inc · San Jose, CAS/N 17274683N227CMMmkb Inc · Wilmington, DEBuilt 1976 · S/N 18264533N227DKirkland Daniel · Kingman, AZBuilt 1976 · S/N 21061540N227FBAtlantic Flying Club Inc · Fernandina Beach, FLBuilt 1979 · S/N 17272654N227GHCarlen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 20800688N227LLJ.R. Aero Ltd · Eldridge, IABuilt 1968 · S/N 15068479N227MSkyway Partners · Woodside, CABuilt 1964 · S/N 17251565N227SSRiver Front Akn LLC · Anchorage, AKBuilt 1970 · S/N U20601516N22802Ference Jeffrey J · Chandler, AZS/N 15068526N2280TRegistered aircraftBuilt 1977 · S/N R18200016N2281Guzman Javier A · Sammamish, WABuilt 1979 · S/N R1723129
Back to AD 97-01-13