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.

N1506YVaughn Jeffery Page · Shenandoah, VAS/N 17249206N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028N1507QSafety In Motion Flight Center Inc · Puyallup, WABuilt 1971 · S/N 15072807N1508CHutchings Alan J · Clewiston, FLBuilt 1953 · S/N 30208N1508FHaley Wayne C · Okeechobee, FLBuilt 1964 · S/N 1850816N1509CHammerquist Blake T · Benicia, CABuilt 1954 · S/N 30882N1509MChalk 2 Inc · Apple Valley, CABuilt 1975 · S/N 18264357N1509QBeavers David · Strasburg, COBuilt 1971 · S/N 15072809N150AJChristianson Alan J · Washougal, WAS/N 15076664N150AKCamp Ted A · Williamson, GAS/N 04940071N150ANBachman Aviation LLC · Independence, IABuilt 1995 · S/N 04940074N150ARBerry Norman R · Knoxville, TNS/N 15070693N150AWJohnson Seth · Gulfport, MSBuilt 1964 · S/N 15060572N150AYLegacy Aviation Foundation Inc · Staten Island, NYBuilt 1995 · S/N 04940073N150BGMbw Aviation LLC · Bay City, MIS/N 310R-0635N150BKTribec Inc · Medina, OHBuilt 1969 · S/N 15070857N150BNHernandez Ralph · San Antonio, TXS/N 15072767N150BPRiffle Christopher Thomas · Charleston, SCBuilt 1972 · S/N 15073931N150BWRollinson Mark H · South CanterburyS/N 15064521N150CPrincess North Inc · Lindstrom, MNS/N 15059959N150CEBrazier Glen A · Greenbush, MNBuilt 1973 · S/N 15073986N150CFDesutter S Bryan · Manito, ILBuilt 1980 · S/N 340A1215N150CGRomano Brian P · Terryville, CTBuilt 1967 · S/N 15066615N150CJMorrell John I · Seymour, TNBuilt 1994 · S/N 04940064N150CMDunn James W · Otis, MES/N 15066599N150CQCalarco Richard A · Hillsboro, ORBuilt 1965 · S/N 15061671N150CVMmdt Aero LLC · Worthington, OHBuilt 1966 · S/N 15065496N150DBEvans Thomas J · Little Elm, TXBuilt 1972 · S/N 15074052N150DDFuentes Daniel · Coral Springs, FLBuilt 1973 · S/N 15075327N150DECopaair Maintenance Services Inc · Indiantown, FLBuilt 1972 · S/N 15073849N150DFTaildragger Hq LLC · Melrose, FLBuilt 1964 · S/N 15060672N150DKShipe Jacqueline M · Louisville, TNBuilt 1968 · S/N 15069738N150DLLedford Joseph Daniel · Cedartown, GAS/N 15075555N150DPVendetti Michael J · Olney, MDBuilt 1970 · S/N 15072356N150DSShelbyville Central High School Cte · Shelbyville, TNBuilt 1964 · S/N 15060368N150DTWatson Matthew L · Liberty, UTBuilt 1962 · S/N 15059671N150ETjelta Peter A · Sheyenne, NDBuilt 1967 · S/N 15066502N150EBRegistered aircraftS/N 15072790N150EGGreene Harry L · Waipahu, HIBuilt 1969 · S/N 15071635N150EHPouya Hamid · San Jose, CABuilt 1969 · S/N 15070883N150EMArman Michael P · Oak Hill, FLBuilt 1967 · S/N 15066362N150EQSmart Aviation Solutions Inc · Lakeland, FLBuilt 1974 · S/N 15076259N150EWGlazier Matthew S · Presque Isle, MEBuilt 1968 · S/N 15068457N150FFKelly Paul M · Granite Bay, CABuilt 1975 · S/N 15076716N150FJSale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 15071001N150FLBerry Jeffrey Thomas · Clovis, CABuilt 1969 · S/N 15070938N150FMSanders Steven M · Powell, WYBuilt 1959 · S/N 17183N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554N150FTLevine Albert E · Bloomfield, CTS/N 15065352N150GNCarr Greg Wayne · Mccloud, CABuilt 1975 · S/N 15077043
Back to AD 97-01-13