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.

N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306N20JNGana Trucking & Excavating Inc · Martell, NES/N 340A0050N20JSOyaski Michael F · Ebensburg, PABuilt 1975 · S/N 18263751N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496N20MWStriebel David J · Dayton, OHBuilt 1975 · S/N 421B0918N20NGTas Aviation Of Defiance Inc · Defiance, OHBuilt 1971 · S/N 310Q0276N20RHStoltzfus John F Jr · Strasburg, PAS/N 172-68331N20RSStendal Russell M · Hollywood, FLBuilt 1970 · S/N 18501826N20VKEvans Jeffrey L · Mansfield, LABuilt 1977 · S/N 310R0978N20WAOn Air Company LLC · Sewickley, PAS/N 414A0280N20WFLofton Christopher L · Harlingen, TXBuilt 1976 · S/N 310R0684N20WGBingham James H · Dillingham, AKS/N 33734N20WMMcdonald John P · Kennewick, WAFirst renewal noticeBuilt 1973 · S/N 17261658N21000Yunger John C · Newton, WIBuilt 1972 · S/N 18261346N21001Global Acquisitions Ltd · Davenport, IAS/N 18261347N21004M & J Aviation LLC · Clarkston, MIBuilt 1972 · S/N 18261349N21006Lerma Gilbert L Sr · Salome, AZBuilt 1972 · S/N 18261351N21009Law Jonathan · Davis, CABuilt 1972 · S/N 18261354N2100FDurocher David T · Fernley, NVBuilt 1965 · S/N U206-0301N2100GTpa Skylane LLC · Asheville, NCBuilt 1958 · S/N 51400N2100RAbresch Craig G · Idaho Falls, IDBuilt 1964 · S/N 18255300N2100ZGreenwood Stephen · Salt Lake City, UTBuilt 1962 · S/N 18051200N21010Mikiewicz Joseph · West Pittston, PABuilt 1972 · S/N 18261355N21013Thompson Jack M Jr · Ithaca, NYBuilt 1972 · S/N 18261357N21014C & G Aviation LLC · Hollandale, MSBuilt 1972 · S/N 18261358N21015Renfro Michael W · Bethel, AKBuilt 1974 · S/N 17263888N21017Eastern Idaho Flying Club LLC · Idaho Falls, IDBuilt 1972 · S/N 18261361N2101EV1 Aviation LLC · Englewood, COBuilt 1978 · S/N 17271155N2101XScofield Bruce W · Batavia, NYBuilt 1972 · S/N 17701785N21020Monteiro Armando D · Stratford, CTBuilt 1972 · S/N 18261364N21024Horlick Harlan C · Crossville, TNBuilt 1972 · S/N 18261366N21028Snflk Leasing LLC · Andrews, TXBuilt 1972 · S/N 18261367N2102EBrooks Terry A · Shelby, NCBuilt 1978 · S/N 17271156N2102FOlson Tim O · Saint Onge, SDBuilt 1964 · S/N U206-0302N2102GPool Lori A · Cody, WYBuilt 1958 · S/N 51402N21034Luxford Richard L · Los Angeles, CABuilt 1972 · S/N 18261370N21035Hayes Bradley M · Grove, OKBuilt 1974 · S/N 17263890N21036Nace Kris A · Glendale, ORBuilt 1972 · S/N 18261372N21037Registration Pending · Boulder City, NVRegistration pendingBuilt 1972 · S/N 18261369N21038Mindy Limited LLC · Muscatine, IABuilt 1972 · S/N 18261374N2103SSan Diego Flight Corp · San Diego, CABuilt 1975 · S/N 21061067N21043Registration Pending · Hemet, CARegistration pendingBuilt 1972 · S/N 18261376N21047Sessoms Marcus · Key West, FLBuilt 1972 · S/N 18261380N2104FBrown Steven R · Soldotna, AKBuilt 1964 · S/N U206-0304N2104RRegistration Pending · Palm Beach Gardens, FLRegistration pendingS/N 18255304N21055Harty Timothy L · New Richmond, WIBuilt 1972 · S/N 18261385N21059Poe David P · Rockville, MDBuilt 1972 · S/N 18261388N2105FClik Services LLC · Forestdale, MABuilt 1964 · S/N U206-0305N2105QBarreto Daniel · Enterprise, ALBuilt 1974 · S/N 177RG0505N2105SSouthport Aviation LLC · Cape Coral, FLBuilt 1976 · S/N 21061069
Back to AD 97-01-13