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.

N319DDenimarck Vincent · Wildwood, FLBuilt 1969 · S/N 15070159N319JFRegistration Pending · Johns Island, SCRegistration pendingS/N 21063507N319JPElon Aviation LLC · Burlington, NCBuilt 1973 · S/N 17262752N319MTSimply Living LLC · Fort Myers, FLS/N 31438N319TATextron Aviation Inc · Wichita, KSS/N 208B5984N31ACTango Thirty Aero Clube Inc · Mckinney, TXS/N 17261643N31AJ1 Alpha Jadzia LLC · Fort Worth, TXBuilt 1975 · S/N 18264449N31AWRestoration Dental · Chesterfield, MOBuilt 1975 · S/N 414-0803N31AZDelgado Tony · Denair, CAS/N 18267911N31BBohon Todd R · Palmer, AKS/N 18052431N31BJAvco Patrol LLC · Lyndon, KSBuilt 1976 · S/N 17702489N31CLg & Gs Holdings LLC · Middletown, DES/N 421C0096N31CNSkyland Aviation LLC · Alpine, CABuilt 1976 · S/N 17267936N31CULovaas Jean H Trustee · Crescent City, CABuilt 1977 · S/N 421C0341N31DDDavis David C · Queen Creek, AZBuilt 1960 · S/N 52836N31EREmbry Riddle Aeronautical Univ Inc · Prescott, AZBuilt 1964 · S/N 15061072N31FCInternational Air Services Inc Trustee · Carson City, NVS/N 46140N31FR31fr LLC · Bigfork, MTBuilt 1985 · S/N R18202008N31GKMartin Richard B · Corona Del Mar, CAS/N 310Q0664N31JBLucian Aviation LLC · Modesto, CAS/N 17273002N31KCWashington State Community College · Spokane, WABuilt 1973 · S/N 421B0344N31KDChinook Fibre LLC · Wilmington, DEBuilt 1984 · S/N T30300310N31KEWilcox John B · South Charleston, WVBuilt 1965 · S/N 18256600N31KGMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 310R1533N31KSPaxton Jacob · Killeen, TXS/N 421B-0662N31KTSmith Kenneth L · Pomona, CABuilt 1970 · S/N 421B0011N31LDGustte Phil · North Fort Myers, FLBuilt 1973 · S/N 17262736N31MDKarmy Paul Edward · Burleson, TXBuilt 1980 · S/N P21000595N31MMPence Air LLC · Edinburg, VAS/N 421C0819N31MRAllred Don J · Wellington, TXBuilt 1974 · S/N 18262907N31PGPlacette Jim · Houston, TXBuilt 1977 · S/N 310Q0687N31RTPapuchin LLC · Highwood, ILBuilt 1970 · S/N 414-0158N31RWSpot Air LLC · Burlington, TXBuilt 1977 · S/N 17268693N31SASouthern Airways Pacific LLC · Addison, TXBuilt 2006 · S/N 208B1210N31SRIsaac Timothy S · Independence, ORBuilt 1962 · S/N 18051098N31VRGlaze Roy J · Smyrna, TNBuilt 1976 · S/N 33701731N31WDWestern Dakota Holding Co · Timber Lake, SDBuilt 1980 · S/N 425-0012N31WTThomas Norman W · Forest, VABuilt 1980 · S/N 172RG0291N31YBProgressive Air Inc · Janesville, WIBuilt 1979 · S/N 18266786N31YKJendair LLC · New York, NYBuilt 1973 · S/N 310Q0934N31ZWestern Skymasters LLC · Salt Lake City, UTBuilt 1973 · S/N P3370028N32009Ecliax LLC · Craig, AKBuilt 1987 · S/N 20800022N3200ERegistration Pending · Burlington, WIRegistration pendingBuilt 1978 · S/N 17271466N3200JOdell Steven P · Perrysburg, OHBuilt 1966 · S/N 15065900N3200SGreene James · Georgetown, TXBuilt 1964 · S/N 18255700N3200UAnderson & Assoc Attorneys At Law Pc · Virginia Beach, VABuilt 1962 · S/N 18254600N3200YCondo Gerardo B · Miami, FLBuilt 1962 · S/N 18254200N3201DMelnick Victor D · Mount Bethel, PABuilt 1955 · S/N 31999N3201SBoder Eric T · Knoxville, TNBuilt 1964 · S/N 18255701N3201XSale Reported · Glen Allen, VASale reportedBuilt 1966 · S/N 15064601
Back to AD 97-01-13