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.

N19DJLewis Landon Jon · Hope, NDBuilt 1977 · S/N 310R0868N19ECSerra Decca Company LLC · Seattle, WABuilt 1967 · S/N 185-1306N19EZAir Mobile Ministries · Sneedville, TNBuilt 1970 · S/N 33701315N19FABrown Brian T · Wilton, CABuilt 1961 · S/N 18253809N19GCarlton Steve W · Lewiston, IDBuilt 1963 · S/N 18254596N19GCKobaly Jason D · Yucca Valley, CABuilt 1972 · S/N 18261280N19HRJernigan Michael G · Toledo, ORBuilt 1966 · S/N 17255607N19JGImmeyer Daniel O · Redmond, WABuilt 1958 · S/N 55131N19JKA P Air LLC · Wilmington, NCBuilt 1973 · S/N 17701867N19JRKyle Agne · Greensboro, NCBuilt 1973 · S/N 177RG-0314N19LFN19lf Corp · Oak Lawn, ILBuilt 1972 · S/N 310Q0622N19LVLeon Ruben D · Oviedo, FLBuilt 1972 · S/N P3370012N19MJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N U20605372N19MUGarrett Jack H · Grandview, TXS/N 177RG0099N19NJN19nj LLC · Manassas, VABuilt 1985 · S/N 17276343N19PLively Gregory · Corinth, TXBuilt 1969 · S/N 337-1091N19PFTac'S Enterprise LLC · Ballston Lake, NYBuilt 1972 · S/N 17701711N19SBMcginnis Randall E · Redding, CABuilt 1972 · S/N P3370018N19STS&S Aviation Co · Ball Ground, GAS/N 414A0452N19TAFun Flyers LLC · Salem, ORBuilt 1973 · S/N 17701912N19TLHall Kurt D · Fort Lauderdale, FLBuilt 1975 · S/N U20602629N19TWDougherty Peter I · Orchard Park, NYBuilt 1953 · S/N 30119N19WBPacific Wildfire Enterprises LLC · Wilmington, DES/N P21000761N19WSHolcomb Nicholas A · Yakutat, AKS/N 29689N19ZBBruton Kevin L · Roseburg, ORBuilt 1959 · S/N 55732N1AXEdgerton Agency Inc · Galena, OHBuilt 1960 · S/N 47418N1BPPatton Ministries · Grand Rapids, MNBuilt 1961 · S/N 18253260N1CTTre Aviation Corp · Queen Creek, AZBuilt 1972 · S/N P3370001N1DZXtreme Flying Services LLC · Gansevoort, NYBuilt 1961 · S/N 18253742N1EHandschiegel Robert J · Hampshire, ILBuilt 1976 · S/N 17267046N1FHBuermann Henry · Brookfield, VTS/N 18052817N1GQAero Attack Systems (USA) Inc · Blaine, WANon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 421B0236N1GXOclair Carleton Brent · Saco, MEBuilt 1973 · S/N 17702009N1HUCaster-Way LLC · Sebring, FLBuilt 1968 · S/N 337-1008N1JHHolden James E · Las Vegas, NVBuilt 1975 · S/N 17265723N1JYRicks Electric Plus LLC · Middleton, IDBuilt 1958 · S/N 51474N1KBThibault Ryan D · Anchorage, AKBuilt 1967 · S/N 15067470N1KUUniversity Of Kansas Aerospace Engineering Dept · Lawrence, KSBuilt 1974 · S/N 17262270N1LQStrydom Cornelis F · Liberal, KSBuilt 1966 · S/N T210-0148N1NSEagle Equity Inc · Valparaiso, INBuilt 1973 · S/N 15074284N1QMAhlhorn Travis W · New Braunfels, TXBuilt 1979 · S/N 421C0701N1QPN667sr LLC · Richmond, KYBuilt 1972 · S/N 18261605N1QSUniversal Investment Group LLC Trustee · La Crescenta, CABuilt 1975 · S/N 17265177N1RMMeggers Roger D · Baker, MTBuilt 1975 · S/N 18502686N1SBHattan John A · Goddard, KSBuilt 1974 · S/N 18502377N1TAJustine Lorraine F · Newark, DEBuilt 1972 · S/N 17260453N1TLLewis Thomas A · Roanoke, VABuilt 1974 · S/N 15075710N1UFGrand Aviation Inc · Grove, OKBuilt 1973 · S/N P3370098N1XSaitto Jeffrey M · Media, PABuilt 1965 · S/N 17252958N1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 421B0580
Back to AD 97-01-13