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.

N3168VAirgo Inc · Cetralia, ILBuilt 1974 · S/N 15076407N3168YSkydive Central New York LLC · Weedsport, NYBuilt 1962 · S/N 18254168N3169TOwen James D · Fort Lauderdale, FLBuilt 1967 · S/N 17700469N3169XVirgilio Domenico · Rochester Hills, MIBuilt 1966 · S/N 15064569N316ACheng Williams W · North Potomac, MDBuilt 1979 · S/N 17273226N316CAChoice Aviation LLC · Hamilton, MTS/N 17265960N316EJPinpoint Logistics LLC · Cambridge, NEBuilt 1981 · S/N 425-0069N316HYLakeview Aviation Inc · Newport, VTBuilt 1977 · S/N 17702651N316LSC M & N D Inc · Wilmington, DEBuilt 1964 · S/N 18255604N316MLJump N316ml LLC · East Berlin, PABuilt 1969 · S/N P2060549N316PCRegistration Pending · Payson, AZRegistration pendingBuilt 1968 · S/N 15069440N316RALeading Edge Flight Services Inc · Hampshire, ILBuilt 1974 · S/N 310Q1100N316SFDoc Aviation LLC · Ponca City, OKBuilt 1964 · S/N 18255668N316WCEagle Aeronautics LLC · Chicago, ILS/N 421C1047N3170JDobrzynski Andrzej J · Chicago, ILBuilt 1966 · S/N 15065870N3170QRenfrow Denny · Kelseyville, CABuilt 1967 · S/N 18258170N3170UHarrison Brian C · New London, OHBuilt 1962 · S/N 18254570N3170XFlying L Aircraft Inc · Fort Denaud, FLBuilt 1966 · S/N 15064570N3170YStillson John L · Rock Rapids, IAS/N 18254170N3171CLand Sea & Air Inc · North Mankato, MNBuilt 1954 · S/N 30970N3171DJohnson Donald B · Lino Lakes, MNBuilt 1955 · S/N 31969N3171EJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271459N3171FRockin Rt LLC · Smithfield, UTS/N 18257271N3171JRay Charles B · Prosser, WAS/N 15065871N3171TVanlandingham Michael E · Oxnard, CABuilt 1967 · S/N 17700471N3171XJohnson Christopher A · San Diego, CABuilt 1966 · S/N 15064571N3171YDj Aviation LLC · Newburgh, INBuilt 1962 · S/N 18254171N3172EKruchten Larry A · Scottsdale, AZBuilt 1982 · S/N 18268237N3172FKuhn Joseph C · Manhattan Beach, CABuilt 1973 · S/N A1500407N3172SSterling Flyers LLC · Lehi, UTS/N 18255672N3172YPeters Barry S · Montague, CABuilt 1962 · S/N 18254172N3173CMcgaha Justin L · Hooker, OKS/N 30972N3173ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271461N3173FJames Pearl LLC · Norfolk, VABuilt 1966 · S/N 18257273N3173SCortese Farm And Ranch Inc · Fort Sumner, NMFirst renewal noticeBuilt 1964 · S/N 18255673N3173XRegistration Pending · Lutz, FLRegistration pendingBuilt 1966 · S/N 15064573N3174DRegistered aircraftBuilt 1955 · S/N 31972N3174FRozier Harold H Jr · Blackshear, GABuilt 1966 · S/N 18257274N3174QMclaughlin Daniel R · Xenia, OHBuilt 1967 · S/N 18258174N3174UMorris Debbie L · Columbus, GABuilt 1963 · S/N 18254574N3174XRenner Colton A · Easley, SCBuilt 1966 · S/N 15064574N3175CClay Jason I · Imperial Beach, CABuilt 1954 · S/N 30974N3175FEstes Bernard R · Bumpass, VABuilt 1966 · S/N 18257275N3175JJohnson David J Jr · Yucaipa, CABuilt 1966 · S/N 15065875N3175UKeller Richard J · Martinsburg, WVBuilt 1963 · S/N 18254575N3175VDunaire LLC · Mechanicsburg, PABuilt 1974 · S/N 15076408N3175YPittman Joel C · Apple Valley, CABuilt 1962 · S/N 18254175N3176CYoung Thomas O · Battle Ground, WABuilt 1954 · S/N 30975N3176JAquaero LLC · San Antonio, TXBuilt 1966 · S/N 15065876N3176XHarless Phillip M · Mcdonough, GAFirst renewal noticeBuilt 1966 · S/N 15064576
Back to AD 97-01-13