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.

N193GSWeaver Family Farms LLC · Corpus Christi, TXBuilt 1970 · S/N 18260442N193JSRyan Moore LLC · Fayetteville, NCBuilt 1975 · S/N 17265118N193LBRiverway Capital LLC · Houston, TXBuilt 1976 · S/N 20700360N193RChase David C · Anchorage, AKBuilt 1969 · S/N 182-59879N193RJSale Reported · Henderson, NVSale reportedBuilt 1980 · S/N R1723315N193SPIndiana State Police · Greenwood, INS/N 172-76346N193TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N U20605946N19400Bailis David P · Bethlehem, PAS/N 15074395N19404Borden Kim L · Fair Haven, NYBuilt 1973 · S/N 15074399N19405Blenden Stephen R · Orlando, FLBuilt 1977 · S/N 17702569N19406Clark Caroline Ray · Anderson, SCS/N 15074401N19409Owen James A · Jud, NDBuilt 1973 · S/N 15074404N1940FAmerican Asset Leasing LLC · Livermore, CAS/N 17273030N19410Sather Evan A · Hayward, CABuilt 1973 · S/N 15074405N19413Ahlgren Jon E · Juneau, AKBuilt 1973 · S/N 15074406N19414Bailey Brian D · Bethesda, MDFirst renewal noticeBuilt 1973 · S/N 15074407N19419Dean Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 17702570N1941MEf Air Holdings LLC · Midkiff, TXBuilt 1976 · S/N 18264493N19422Bellefontaine Georges E · Shady Shores, TXBuilt 1973 · S/N 15074413N1942GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0842N1942MRegistration Pending · Linn, TXRegistration pendingBuilt 1976 · S/N 18264494N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296N19439Technical Education Services Inc · Virginia Beach, VABuilt 1973 · S/N 15074419N1943MBenbrook Robert A · Blairstown, NJBuilt 1977 · S/N 21061968N1943QLeonard Joseph · Bohemia, NYBuilt 1973 · S/N 177RG0343N1943ZBeauford Bryan Tyler · Anderson, MOBuilt 1962 · S/N 15059743N19445Scott Beau · Ashville, OHBuilt 1976 · S/N 17702572N1944EHans Construction LLC · Lititz, PAS/N 340A0675N1944GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0844N1944QHenry Peter S · Olympic Valley, CABuilt 1973 · S/N 177RG0344N1944ZHauser Linda L · Ulysses, KSBuilt 1962 · S/N 15059744N19451Allison Jeremy L · Chandler, AZBuilt 1973 · S/N 15074427N19453Top Flight LLC · Wilmington, DES/N 15074429N1945FLake Elmo Aero LLC · Lake Elmo, MNBuilt 1979 · S/N 17273035N1945MOchs Roland P · Brighton, COBuilt 1976 · S/N 18264496N1945QSmith Thomas E Jr · Chino Hills, CABuilt 1973 · S/N 177RG0345N1945XStepps Dana · Humboldt, TNBuilt 1965 · S/N 18256045N19463Aviation Trust Co LLC · Oklahoma City, OKBuilt 1973 · S/N 15074431N19469Registration Pending · Summerland Key, FLRegistration pendingS/N 15074433N1946GPartwin421 LLC · Greenwich, CTBuilt 1974 · S/N 421B0846N1946QMoore Garrie W · Georgetown, TXBuilt 1973 · S/N 177RG0346N1946VLeading Edge Aviation Inc · Doylestown, PABuilt 1976 · S/N R1722221N19476Havron Dana Houston · Huntsville, ALS/N 15074438N19477Rare Birds LLC · Yukon, OKBuilt 1973 · S/N 15074439N19479Kunkle Bryan S · Mount Morris, NYBuilt 1973 · S/N 15074441N1947FMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273037N1947QBailey Jr James E · Rittman, OHBuilt 1973 · S/N 177RG0347N19480Blair Mark · Kingman, AZBuilt 1973 · S/N 15074442N19481Majors Flying Club · Greenville, TXBuilt 1973 · S/N 15074443N19486Beavers David Allen · Strasburg, COS/N 15074444
Back to AD 97-01-13