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.

N2667FVan Hooser Barry S · Pleasanton, CABuilt 1965 · S/N 18256767N2667GTundra Aviation Inc · Casselton, NDS/N 51967N2667RJorgensen Larry C · Randle, WABuilt 1967 · S/N 18258367N2667SMarcum Aviation Maintenance Services LLC · Galena, OHS/N 21061347N2668ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 421C1216N2668FBreaux Robert R · Chino Hills, CABuilt 1965 · S/N 18256768N2668GGospel Ministries International · Mc Donald, TNBuilt 1959 · S/N 51968N2668LEnnis Shannon E · Chesapeake, VABuilt 1967 · S/N 17255868N2668RCummings Robert S · Bowling Green, KYBuilt 1967 · S/N 18258368N2668UMid South Aircraft Inc · Gadsden, ALBuilt 1963 · S/N 17250268N26692Fields Douglas P Jr · Brooklyn, NYBuilt 1979 · S/N 310R1849N2669FMichelbrink Hunter J · Gardiner, MTS/N 18256769N2669LRotormate LLC · Royse City, TXBuilt 1967 · S/N 17255869N2669NWilliamson Benjamin J · Morgan Hill, CABuilt 1979 · S/N 340A0735N2669QBanks Ron E · Blanchard, OKBuilt 1966 · S/N 18257869N2669RStrubhar Wesley D · Foster, ORBuilt 1967 · S/N 18258369N2669SWilliams Kent A Jr · Kissimmee, FLBuilt 1968 · S/N 337-0969N2669XSkydive Ricks LLC · Petersburg, OHBuilt 1965 · S/N P206-0169N2669YHession Mark A · Arrington, TNBuilt 1962 · S/N 18051169N266VFox Stephen A · Wasilla, AKBuilt 1954 · S/N 31215N2670JMiw Airmen Inc · Marshalltown, IABuilt 1966 · S/N 15065670N2670LOns Bart · Kirkland, WABuilt 1967 · S/N 17255870N2670YErickson Wesley B · Littleton, COBuilt 1962 · S/N 18051170N2671JSherman Phillip A · Mansfield, OHBuilt 1966 · S/N 15065671N2671LNbl Aviation LLC · Woodway, TXBuilt 1967 · S/N 17255871N2671RCw Equipment Rentals Inc · Biggs, CABuilt 1967 · S/N 18258371N2671UMetz Thomas H · Mifflintown, PABuilt 1963 · S/N 17250271N2672FWright James F · Glenford, OHS/N 18256772N2672GPhillips Douglas S · Gloversville, NYBuilt 1959 · S/N 51972N2672MSchmoll Aviation LLC · Sterling, AKBuilt 1966 · S/N 18051729N2672SJja Transportation LLC · Springville, UTBuilt 1968 · S/N 337-0972N2672UBender John Lowell Trustee · N Richland Hills, TXBuilt 1963 · S/N 17250272N2672VWhite Robe · Castro Valley, CABuilt 1974 · S/N 177RG0649N2672YSchmieding Michael · Salem, ORBuilt 1962 · S/N 18051172N2673BM & N Of Alabama LLC · Magnolia Springs, ALBuilt 1980 · S/N 414A0630N2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A0755N2673GChapman Chad · San Antonio, TXBuilt 1959 · S/N 51973N2673JWest David V · Sandusky, OHBuilt 1966 · S/N 15065673N2673LBalcom Terry J · Shepherd, MIBuilt 1967 · S/N 17255873N2673RDouville Laura Deluea · Portland, ORBuilt 1967 · S/N 18258373N2673UBonin Patrick G · Blossvale, NYBuilt 1963 · S/N 17250273N2673VJackson R N · Southlake, TXBuilt 1974 · S/N 177RG0650N2673ZFiske James K · North Andover, MABuilt 1963 · S/N 185-0673N2674LValley Excavation And Grading Inc · Chatsworth, CABuilt 1967 · S/N 17255874N2674VMoroil Corp · Davidson, NCBuilt 1974 · S/N 177RG0651N2674XKaiser Eric J · Milford, INBuilt 1966 · S/N P206-0174N2675FVarnado Matthew G · Denham Springs, LABuilt 1965 · S/N 18256775N2675LFoster Jeffrey W · Lexington, NCBuilt 1967 · S/N 17255875N2675RDotzenroth David A · Watertown, MNS/N 185-02392N2675UAv Hawk Aviation LLC · Montclair, NJS/N 17250275
Back to AD 97-01-13