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.

N30316L & M Aviation LLC · Creston, IAS/N 17701189N30317Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17701190N3031FAlderson John M · Venice, CABuilt 1966 · S/N 18257131N3031USandstrom David E · Anchorage, AKBuilt 1963 · S/N 17250631N3031YAir Repair Inc · Cleveland, MSBuilt 1962 · S/N 18254031N30328Martin Paul T · Tacoma, WABuilt 1968 · S/N 17701196N3032QMitchell Michael A · Old Forge, NYBuilt 1967 · S/N 18258032N3032XMagaruh George M · Roscoe, ILBuilt 1966 · S/N 15064432N30331Cardinal Lima LLC · Minneapolis, MNBuilt 1968 · S/N 17701197N3033QFisher David E DBA · Bristow, OKBuilt 1967 · S/N 18258033N3033SWelch Cara · Concrete, WABuilt 1967 · S/N 15066933N30346Cooke Bradley J · Belmont, NCBuilt 1968 · S/N 17701203N30347Dennis Rick L · Poughkeepsie, NYBuilt 1968 · S/N 17701204N3034SMore Development LLC · Tucson, AZBuilt 1967 · S/N 15066934N3034URay David W · Albuquerque, NMBuilt 1963 · S/N 17250634N3034XChandler Jerry D · Pilot Mountain, NCBuilt 1966 · S/N 15064434N30353Stracuzzi Charles J · Ocala, FLBuilt 1968 · S/N 17701207N30357Cammack Brian W · Edgewood, NMBuilt 1968 · S/N 17701209N3035UFindley William R · Los Gatos, CABuilt 1963 · S/N 17250635N3035X29 Soaring Club Inc · Twentynine Palms, CABuilt 1966 · S/N 15064435N3035YWardlaw Consulting LLC · Truckee, CABuilt 1962 · S/N 18254035N30363Talbot Douglas J · Sandpoint, IDS/N 17701210N3036Q3 Rivers Airshare Llp · Sheridan, MTBuilt 1967 · S/N 18258036N3036YPeterson Zachary E · Fargo, NDBuilt 1962 · S/N 18254036N30370Fellow Ship Aviation LLC · Monticello, GABuilt 1974 · S/N 17264136N3037JMello Ben · Bainbridge Island, WAS/N 15061137N3037QState Of Arizona · Holbrook, AZBuilt 1967 · S/N 18258037N30384Knutson Wayne R · Thompson, NDS/N 15064473N30387Watkins Bruce K · Houston, TXBuilt 1968 · S/N 17701226N3038FTaylor Spencer H · Lake City, FLBuilt 1966 · S/N 18257138N3038JPauls Flying Service LLC · Dundee, MSBuilt 1965 · S/N 15061138N3038SAbove All Aviation · Goleta, CABuilt 1967 · S/N 15066938N30390Rimmer Nathan S · Seattle, WABuilt 1968 · S/N 17701229N30393Graden Timothy J · Polo, ILBuilt 1968 · S/N 17701231N30396Sill John A · Cable, WIBuilt 1968 · S/N 17701233N30399Schwanke Donald D · Springfield, ILBuilt 1968 · S/N 17701236N3039VMiller Zachary L · Roseau, MNBuilt 1974 · S/N 15076364N303ABMarc Inc · Bolton, MSBuilt 1981 · S/N T30300028N303BSLegacy Restoration Services Inc · Cumming, GABuilt 1980 · S/N 182-67622N303CCSpectrum Aviation Inc · Wilmington, DEBuilt 1982 · S/N T30300069N303CGSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N T30300022N303CMAdvantage Aviation Inc · Charlotte, NCBuilt 1984 · S/N T30300296N303CTFloyd Brian · Eatonton, GABuilt 1978 · S/N 21062591N303DBBas Part Sales LLC · Greeley, COBuilt 1981 · S/N T30300043N303DCRegistered aircraftBuilt 1973 · S/N 402B-0303N303DKTrading Planes Inc · Wilmington, DEBuilt 1982 · S/N T303-00068N303GVState Of Alaska · Palmer, AKBuilt 1996 · S/N 208B0581N303HLLao Che Airfreight LLC · North Weymouth, MABuilt 1982 · S/N T30300038N303JPJep Inc · Clarksville, TNBuilt 1982 · S/N T30300067N303KJBrother Michael Andrew · Bedford, TXBuilt 1984 · S/N T303-00301
Back to AD 97-01-13