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.

N2334CTallahassee Flying Club Inc · Tallahassee, FLBuilt 1978 · S/N R18200153N2334USimplifly LLC · Mesa, AZBuilt 1962 · S/N 17249934N23350Kimbrel Martin E · Oakville, WABuilt 1968 · S/N 15068892N23353Weems Widener E · San Antonio, TXBuilt 1974 · S/N 17264085N23357603 Flight LLC · Nashua, NHS/N 15068898N23359Moore Everett A · New Lexington, OHBuilt 1968 · S/N 15068900N2335EMindy Limited LLC · Muscatine, IABuilt 1978 · S/N 17271240N2335FGravitte Peter F · Napa, CAS/N 21058535N2335GRegistered aircraftBuilt 1958 · S/N 51635N23360Xc Aviation LLC · Wyckoff, NJBuilt 1968 · S/N 15068901N23364Ephraim Flyers Inc · Ephraim, WIBuilt 1968 · S/N 15068904N23365Del Rossa Erwin R · Sodus, NYBuilt 1968 · S/N 15068905N2336GLogue Elmer S · Derby, KSS/N 51636N2336UWilson Milledge L · Prosperity, SCBuilt 1962 · S/N 17249936N2337Boutique Air Inc · Denver, COBuilt 1969 · S/N 337-1102N23370Carruthers John H Jr · Berlin, NHBuilt 1968 · S/N 15068909N23372Dold Stephen E · Foresthill, CABuilt 1968 · S/N 15068911N23374Pannell Lucas J · Midland City, ALBuilt 1968 · S/N 15068913N2337SMoore John A · Ada, MIBuilt 1967 · S/N 337-0637N23382Galster Scott · Oneonta, NYBuilt 1968 · S/N 15068918N23386Perta Steven J · Rome, NYBuilt 1968 · S/N 15068920N23387Strickland Kim A · Bowling Green, OHBuilt 1968 · S/N 15068921N2338FDonnell James C · Crowville, LABuilt 1964 · S/N 21058538N2338GIberlin Ranch · Gillette, WYBuilt 1958 · S/N 51638N23390Smp LLC · Kenner, LAS/N 15068924N23391Porter Scott · Aguila, AZBuilt 1968 · S/N 15068925N23392Mullins Adrian · Cartersville, GABuilt 1968 · S/N 15068926N23398Murillo Anthony · Davis, CABuilt 1968 · S/N 15068928N2339CSullivan Nathan · Croton, OHS/N 30639N2339GWetzel William W · Carrizozo, NMBuilt 1958 · S/N 51639N2339RStephens Grant A · Palmer, AKBuilt 1964 · S/N 18255439N2339XPetet David G · Orofino, IDBuilt 1965 · S/N 18256239N2339YGross Barbara J · Timber Lake, SDS/N 17700139N233GSGreenville County Sheriffs Office · Greenville, SCBuilt 1972 · S/N 18261018N233JHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1977 · S/N 414A0009N233MGFly Safe LLC · Belle Isle, FLBuilt 1980 · S/N R18201541N233PCWright Air Service Inc · Fairbanks, AKBuilt 2006 · S/N 208B1179N233SHSieger Aviation Services Inc · Bismarck, NDBuilt 1979 · S/N 15283714N233TCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17257920N233WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 18257879N233WRVenture Alaska LLC · Homer, AKS/N U20603574N2340CWilliam J Davis · Bismarck, NDS/N R18200155N2340GConner Chris L · Boise, IDS/N 51640N2340RBrandt Phillip A · Boyd, TXBuilt 1964 · S/N 18255440N2340WPienkos Kaz · Haskell, OKS/N 51743N2341CBear Trap Enterprises Inc · Caldwell, IDBuilt 1953 · S/N 30641N2341XYale LLC · Watford City, NDS/N 18256241N23421High Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15068938N23422Air Logistics Group LLC · Winston Salem, NCS/N 15068939N2342CHite Donald L · Mc Kinney, TXBuilt 1953 · S/N 30642
Back to AD 97-01-13