OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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-01-R1')
    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-01-R1')
  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.

N7HURoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDBuilt 1968 · S/N 30-1710N7JESale Reported · Rogersville, MOSale reported, pending cancellationBuilt 1967 · S/N 30-1618N7JJKarmel Moshe · Aventura, FLBuilt 1974 · S/N 28R-7435287N7SKhashimkhodjaev Rustam · Parker, COBuilt 1977 · S/N 28R-7703050N7VBDeeb Inc · Port Richey, FLBuilt 1976 · S/N 28R-7635330N7WLKriner Andrew V · Orlando, FLBuilt 1969 · S/N 30-1914N7YMN7ym LLC · Rockford, MIBuilt 1969 · S/N 301900N8000Burns Christopher G · Hanover, PABuilt 1965 · S/N 30-682N8001PWainwright Daniel G · Clifton, ILBuilt 1963 · S/N 24-3241N8001YMyers Russell E · Pine, AZS/N 30-1107N8002PKoerner Aviation Inc · Kankakee, ILBuilt 1962 · S/N 24-3242N8005PAcklam David C · Yelm, WABuilt 1962 · S/N 24-3245N8006YBreeding Jarrard L · Sharpsburg, GABuilt 1966 · S/N 30-1112N8007PBec Solutions Inc · Dallas, TXBuilt 1962 · S/N 24-3248N8008YWillis Gary B · Willis, TXBuilt 1966 · S/N 30-1114N8009PWilson Paul W Jr · Hobbs, NMBuilt 1962 · S/N 24-3252N800BYVectored Coverage LLC · Stony Brook, NYS/N 24-3161N800KKaufman Charles · West Palm Beach, FLBuilt 1966 · S/N 30-1115N8011FAhmed Sharfaraz · Houston, TXBuilt 1976 · S/N 34-7770080N8011PPrecision Fab Inc · Greenville, OHBuilt 1962 · S/N 24-3254N8012PSchmidt Kyle P · Rapid City, SDBuilt 1962 · S/N 24-3255N8012YMarsh Geoffrey E · Old Lyme, CTBuilt 1966 · S/N 30-1119N8016PSteelera Aviation LLC · Wolfforth, TXBuilt 1962 · S/N 24-3260N8017PMorrison Matthew B · Tucson, AZBuilt 1962 · S/N 24-3261N8017YLoya Armando · Whittier, CABuilt 1966 · S/N 30-1125N8019YOptimus Aicraft Leasing LLC · Naples, FLBuilt 1966 · S/N 30-1128N801PCGrand Michael · Palacios, TXBuilt 1965 · S/N 24-4256N8020PLovingood Max H · Naples, FLBuilt 1962 · S/N 24-3264N8020YSnead State Community College · Boaz, ALS/N 30-1129N8021YSterling Investment Services Inc · Batavia, ILBuilt 1966 · S/N 30-1131N8022YDanis Paul A · Woodinville, WAS/N 30-1097N8023PShisier William · Tempe, AZBuilt 1962 · S/N 24-3267N8024PC Five Ranch Inc · Leoti, KSBuilt 1963 · S/N 24-3268N8026YCaillouet Andre E Jr · Houma, LABuilt 1966 · S/N 30-1135N8027CSeneca 8027c LLC · Spring Lake, MIBuilt 1976 · S/N 347670111N8027YGreek Housing Services Corp · Port Matilda, PABuilt 1966 · S/N 30-1084N8028PTrest Robert J · Pelzer, SCBuilt 1962 · S/N 24-3274N8029PLong Trevor J · Flower Mound, TXS/N 24-3275N802RCCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 28R-30299N8030YPaden Frank G · Lawrenceburg, KYBuilt 1966 · S/N 30-1139N8031POphus Larry N · Big Sandy, MTBuilt 1962 · S/N 24-3278N8031YBresin Sharon M · Kamas, UTS/N 30-1140N8032PMorrison Danny G · Louisburg, KSBuilt 1963 · S/N 24-3279N8034YBerry James V DBA · Hermosa Beach, CABuilt 1966 · S/N 30-1143N8035PKohler Richard L · Moriarty, NMBuilt 1962 · S/N 24-3282N8035YJakowiw Nicholas · Clifton Park, NYBuilt 1966 · S/N 30-1144N8037YTolleson Darrin L · North Liberty, INBuilt 1966 · S/N 30-1147N8038PWeaver Chris DBA · Hallam, NEBuilt 1962 · S/N 24-3158N8041PEnsign James P · N Richlnd Hls, TXBuilt 1962 · S/N 24-3285N8043PGray Motors Inc · Port Angeles, WABuilt 1962 · S/N 24-3289
Back to AD 97-01-01 R1