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.

N2342EWolf John J · Mooresville, NCBuilt 1978 · S/N 17271245N2342GBrodie James W · Lind, WABuilt 1959 · S/N 51642N2342RFrisco Enterprises Inc · Califon, NJBuilt 1964 · S/N 18255442N2342XKinsella Joseph R · Jackson, WYBuilt 1965 · S/N 18256242N23435Depinet Thomas E · Mount Gilead, OHS/N 15068944N23437603 Flight LLC · Nashua, NHBuilt 1968 · S/N 15068945N2343CStedman Bernard Warren · Anchorage, AKS/N 30643N2343FRegistration Pending · Wickenburg, AZRegistration pendingBuilt 1964 · S/N 21058543N2343XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 208B2343N23440American Sky Aviation LLC · Anna, TXBuilt 1968 · S/N 15068947N23443Henson Joseph A · Jasper, ALBuilt 1968 · S/N 15068949N23444Garrett Scott E DBA · Owensville, INBuilt 1968 · S/N 15068950N2344GJones Alva L · Craig, COBuilt 1958 · S/N 51644N2344SAnderas Per R · Green Bay, WIBuilt 1967 · S/N 337-0644N2345Riotte Frederick · Suffield, CTS/N 17266419N23453Harrier Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N 15068957N23458Blue Skies Aircraft LLC · Kalispell, MTBuilt 1968 · S/N 15068961N2345AAeolus Gold LLC · Wilmington, DEBuilt 1974 · S/N 421B0636N2345SSummers Jeffrey L · Pekin, INBuilt 1967 · S/N 337-0645N2345URenkel Albert D · Las Vegas, NVBuilt 1962 · S/N 17249945N2345YJackson Shaun K · Tyler, TXBuilt 1967 · S/N 17700145N2345ZRegistered aircraftBuilt 1977 · S/N 17270190N23460Clark Johnathan W · Coventry, CTBuilt 1968 · S/N 15068963N23461Egipciaco Jeffrey · Hampstead, NCBuilt 1968 · S/N 15068964N23469N23469 LLC · Rehoboth Beach, DEBuilt 1968 · S/N 15068970N2346FNavion Holdings LLC · Boise, IDBuilt 1964 · S/N 21058546N23473G Force Advantage LLC · Lewes, DEBuilt 1968 · S/N 15068973N23476Horizon Flight Center LLC · Chesapeake, VABuilt 1968 · S/N 15068976N2347RDillon John C · Flagstaff, AZBuilt 1964 · S/N 18255447N2347XRegistered aircraftS/N 18256247N2347YProctor Keith E · Paint Lick, KYBuilt 1968 · S/N 17700147N23486Hite Michael B · Martinsburg, WVBuilt 1968 · S/N 15068983N23489Knebel Chris DBA · Boston, VABuilt 1968 · S/N 15068985N2348GWright Michael Lee · Isanti, MNBuilt 1959 · S/N 51648N2348RMiller Robert S · Laurel Springs, NCBuilt 1964 · S/N 18255448N2348UWojnar Ronald T · East Troy, WIBuilt 1962 · S/N 17249948N2348XChessman H Ross · Erie, COBuilt 1965 · S/N 18256248N23491Mcintosh Dyllon J · Anchorage, AKBuilt 1968 · S/N 15068987N23492Roller Michael J · Gassville, ARBuilt 1968 · S/N 15068988N2349CSchwend Brian · Forsyth, MTBuilt 1953 · S/N 30649N2349FMilutinovic Christain · Marengo, ILBuilt 1964 · S/N 21058549N2349GRegistration Pending · Buckley, WARegistration pendingBuilt 1958 · S/N 51649N2349SAjs Aviation LLC · Warroad, MNS/N 421C1209N234BWWaring Marvin Barton · Anacortes, WABuilt 1979 · S/N P21000290N234CMTallman Donald Depaul · Venice, FLBuilt 1966 · S/N 18257696N234DADestination Management LLC · Tulsa, OKBuilt 1971 · S/N 421B0122N234DWN234dw Aviation Inc · Okemos, MIBuilt 1974 · S/N 310R0008N234FNelson Graig M · Eastsound, WABuilt 1955 · S/N 32142N234GMCunningham Hal A · Standard, CABuilt 1976 · S/N 17266438N234GTAny Border LLC · Yankton, SDBuilt 1977 · S/N 21062155
Back to AD 97-01-13