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.

N208SAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2000 · S/N 208B0831N208SMGrant Aviation Inc · Anchorage, AKBuilt 1999 · S/N 208B0749N208SNStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 2009 · S/N 208B2112N208SSSeldom Seen Aviation Northwest Inc · Stevensville, MTBuilt 1974 · S/N 18502452N208SVBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 208B1306N208TCKissee Zachary Robert · Chugiak, AKBuilt 1976 · S/N 18052749N208TFMartinaire Aviation LLC · Addison, TXBuilt 1997 · S/N 208B0592N208TMRedding Aero Enterprises Inc · Redding, CABuilt 1994 · S/N 208B0413N208TRSouth Aero Inc · Albuquerque, NMBuilt 2005 · S/N 208B1151N208TWCaravan Air LLC · Oxford, CTBuilt 1998 · S/N 208B0671N208UUSpeedstar Express LLC · Carson City, NVBuilt 1997 · S/N 208B0604N208VBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 421B0866N208WSilver Mountain LLC · Port Alsworth, AKBuilt 2015 · S/N 208B5224N208WBAlgot Bernhard Ltd · Anchorage, AKS/N 208B2230N208WFWipaire Inc · South Saint Paul, MNBuilt 2003 · S/N 208B1042N208WPCassidy Ryan H · Seattle, WABuilt 1980 · S/N U20605836N208WWWestwind Aero Group LLC · Phoenix, AZBuilt 1998 · S/N 208B0721N208YYAircraft Structures International Corp · Enid, OKBuilt 1995 · S/N 208B0453N208ZZSpeedstar Express LLC · Carson City, NVBuilt 1991 · S/N 208B0260N20907Ward Roger L · Ghent, WVBuilt 1972 · S/N 18261345N2090GLight Chop LLC · Lexington Park, MDBuilt 1958 · S/N 51390N2090QRawls Mike E · New Waverly, TXS/N 177RG0490N2090XTreeline Services LLC · Grimes, IAS/N 18256190N2090YKilbey Bryan E DBA · Defuniak Springs, FLS/N 177RG1106N2090ZRegistered aircraftRegistration pendingBuilt 1963 · S/N 15059890N20914Jackson George F Jr · Saint Leonard, MDBuilt 1972 · S/N 18261294N2091QJohnson Earl V · Andalusia, ALBuilt 1974 · S/N 177RG0491N2091XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256191N2091YCut And Snip Flyers LLC · South Weber, UTBuilt 1962 · S/N 17249591N20920Berry Danny · Rusk, TXBuilt 1972 · S/N 18261295N20921Brigham David F · Elliottsville Twp, MEBuilt 1974 · S/N 17263869N20923Langford Thomas R Jr · Mount Clare, WVBuilt 1972 · S/N 18261298N20929Heinl Christopher · Hickory, NCBuilt 1972 · S/N 18261301N2092GUllrich Sandy J · Haskell, OKBuilt 1958 · S/N 51392N2092YNiver Michael A · Plymouth, WIBuilt 1962 · S/N 17249592N20932Registration Pending · Hammond, LARegistration pendingBuilt 1974 · S/N 17263872N20934Fly Skyhawk Llp · Galena, OHBuilt 1974 · S/N 17263874N20935White Mark · Cadiz, KYBuilt 1972 · S/N 18261306N20936Nedbalek Brent · Brenham, TXS/N 18261307N2093GNew Herschel Dudley Jr · Savannah, GABuilt 1958 · S/N 51393N2093YSale Reported · Agar, SDSale reportedBuilt 1962 · S/N 17249593N20940Cirrus Flight Operations Inc · Minneapolis, MNBuilt 1974 · S/N 17263876N20944Moody Robert L · Ava, MOFirst renewal noticeBuilt 1972 · S/N 18261313N20946Local News LLC · Janesville, WIBuilt 1972 · S/N 18261315N20948Wallin Rolf B · Fayetteville, NCBuilt 1972 · S/N 18261316N2094YHill Karl A · Visalia, CABuilt 1963 · S/N 17249594N2094ZSpak Andrew T · Thousand Oaks, CABuilt 1963 · S/N 15059894N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879N20954Hardin John M · Terrell, TXS/N 17263881N20955Dimich Milan C · La Jolla, CABuilt 1972 · S/N 18261320
Back to AD 97-01-13