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.

N2162GOdiorne Bruce Lamar II · Durango, COBuilt 1958 · S/N 51462N2162ZBaker Benjamin K · Anchorage, AKS/N 18051262N2163RRupp Michael David · Lunenburg, MABuilt 1964 · S/N 18255363N2163ZHennis Jesse J · Nampa, IDBuilt 1963 · S/N 18051263N21641Bunger William D · Upland, NEBuilt 1972 · S/N 18800927N21643A&E Flying Club Of Los Angeles · Hawthorne, CABuilt 1974 · S/N 17263982N21648Fox Victor Aviation LLC · Newnan, GAS/N 17263983N21651Syverson Ronn · Mcintosh, MNBuilt 1972 · S/N 18800934N2165EMaravel Richard N · Trinity, FLBuilt 1978 · S/N 17271174N2165GStanley Aviation LLC · Stanley, NDS/N 34887N2165RSproket Industries Inc · Fulton, CABuilt 1964 · S/N 18255365N2165ZRegistered aircraftBuilt 1963 · S/N 18051265N2166QLiberty Partners Inc · Okmulgee, OKBuilt 1974 · S/N 177RG0566N2166RKrom Raymond L · Brighton, MIBuilt 1964 · S/N 18255366N2166ZCherry William Wallace Jr · Muldoon, TXBuilt 1963 · S/N 18051266N2167CStarkys Equipment Leasing LLC · Manchester, MIBuilt 1978 · S/N 17702743N2167ESittler Charles A · Tulsa, OKS/N 17271176N2167GBtp Inc · Missoula, MTBuilt 1958 · S/N 51467N2167QAnderson Kevin W · Whitman, NES/N 18502483N2167RTake It Easy LLC · Durango, COBuilt 1964 · S/N 18255367N2167YKyriacou Nick · Detroit, MIBuilt 1962 · S/N 17249667N21686Sapp Creek Aviation LLC · Omega, GABuilt 1972 · S/N 18800958N2168RNd Aero Solutions LLC · Bismarck, NDBuilt 1964 · S/N 18255368N2168XOrtiz Stewart Flynn · San Diego, CABuilt 1965 · S/N 337-0068N2168YBarnes Charles R · Jacksonville, FLBuilt 1962 · S/N 17249668N21690Flight Center International LLC · Hollywood, FLBuilt 1974 · S/N 17263987N21699Ramirez Sam Ernest · Yelm, WABuilt 1974 · S/N 17263988N2169CAddison Jeffery A · Lafayette, LABuilt 1978 · S/N 17702744N2169QWhite Beth A · Keene, NHBuilt 1974 · S/N 177RG0569N2169YRudy Jonathan E · New Cumberland, PABuilt 1967 · S/N 17256395N216AFArmed Forces Aero Club Inc · San Diego, CABuilt 1980 · S/N 17274165N216BANordic Flyers II LLC · Plymouth, MNBuilt 1975 · S/N 18263882N216CLMisamore Steven Edward · Mount Juliet, TNS/N 15284706N216DVBusch-Joss Elizabeth M · Blue Point, NYBuilt 1977 · S/N 15280927N216JARuble Howard L Jr · Spartanburg, SCBuilt 1980 · S/N 172RG0467N216LBBail Air LLC · Port Saint Lucie, FLBuilt 1974 · S/N 414-0545N216LHHackbarth Lee A · Bend, ORBuilt 1981 · S/N U20606057N216RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0379N216RGChannel Islands Aviation Inc · Camarillo, CABuilt 1981 · S/N 17275183N216TSS&S Aircraft Inc · Bennington, VTBuilt 1968 · S/N 17256570N21709N 2 Alaska LLC · Talkeetna, AKBuilt 1976 · S/N 18503064N2170CMendez Gary · San Pedro, CAS/N 17702745N2170EChamberlain Flying Club Inc · Chamberlain, SDBuilt 1978 · S/N 17271178N2170GPrince Ben · Lincoln, MTBuilt 1958 · S/N 51470N2170MTucknott Robert A · Livermore, CABuilt 1976 · S/N 18265133N2170PGmr Leasing LLC · Lincoln, DES/N 34152N2170QSkowronski Steven · Demotte, INBuilt 1974 · S/N 177RG0570N2170SAboveallphoto.Com Inc · Indianapolis, INS/N 21061131N21711Williams Roger P III Trustee · Mount Shasta, CAS/N 17263992N2171FRegistration Pending · Eagle River, AKRegistration pendingBuilt 1981 · S/N 18504266
Back to AD 97-01-13