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.

N1499SSkylane Pictures LLC · Los Angeles, CABuilt 1976 · S/N 18265046N1499YHockenberry Randall L · Cape Coral, FLBuilt 1962 · S/N 17249199N149AFTitan Group Inc · Tucson, AZS/N 421C-0098N149ARB-Cat Aviation LLC · Tulsa, OKBuilt 1983 · S/N 414A1006N149GJAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2016 · S/N 208B5283N149JCCorrea Javier Rafael · Caguas, PRS/N 17276119N149TBonilla Jose · Pembroke Pines, FLBuilt 1981 · S/N 18267896N14AUBazzo Richard J · Broadview Heights, OHBuilt 1967 · S/N 15064814N14AZD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1975 · S/N 17263495N14BABurris & Macomber P L L C Trustee · Tucson, AZS/N 18261211N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735N14BMPeyton James L II · Granby, COBuilt 1981 · S/N 425-0076N14CWThornwall Gregory C · Boonsboro, MDBuilt 1969 · S/N 15070656N14GLMc Flying Club Inc · Lewistown, PABuilt 1966 · S/N 15063346N14HKTrolinger John D · Kerrville, TXBuilt 1971 · S/N 15072566N14JDC340-340 LLC · Pinckney, MIBuilt 1974 · S/N 340-0340N14JMMckinstry Aviation LLC · Parker, COBuilt 1974 · S/N 18052475N14KMRiver City Aero Club Inc · Columbus, GABuilt 1965 · S/N 17254062N14LVSmetana Louis V III · Blair, NEBuilt 1970 · S/N 21059259N14MDDaniel Development LLC · Durango, COBuilt 1962 · S/N 18254114N14MRMarlin Aviation Flying Service LLC · West Palm Beach, FLBuilt 1972 · S/N 33701459N14MTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N R18201227N14NFStiles Terry D · King Salmon, AKBuilt 1968 · S/N 17256844N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374N14PHHuman Lee · Mercer Island, WABuilt 1981 · S/N 18504323N14PLByers Steven · San Diego, CABuilt 1966 · S/N 18051711N14PNNefas Paul J · Sunland, CABuilt 1977 · S/N R1722602N14RTSierra Ae LLC · Wilmington, DEBuilt 1974 · S/N 421B0640N14SKHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283422N14SWTriple R Ministries Inc · Crestview, FLBuilt 1974 · S/N 15075931N14TXMcbride Robert W Jr · Mineola, TXBuilt 1963 · S/N 15060031N14UAMilam Equipment LLC · Trussville, ALS/N 414-0605N14VCG5 LLC · Gallup, NMS/N 18264127N14WAWright Brandon C · Cave City, KYBuilt 1966 · S/N 17254217N14YYNorthwoods Air LLC · Orono, MEBuilt 1972 · S/N 18261390N150Beam David · Sabina, OHBuilt 1969 · S/N 15071659N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075N1500G5 Lg LLC · Rome, GABuilt 1975 · S/N 414-0814N1500QShoaff Mark · Lehigh, FLBuilt 1971 · S/N 15072800N1500TAguilar Honorio · Anna, TXBuilt 1965 · S/N 15061784N1501MMeszler Christopher P · Spring Branch, TXBuilt 1975 · S/N 18264354N1501VChinook Flying Club LLC · Chinook, MTBuilt 1976 · S/N R1722197N1501YStreeter Christopher D · Vinita, OKBuilt 1962 · S/N 17249201N1503UAmerican Jet Center Inc · Chino, CABuilt 1973 · S/N U20602228N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633N1505QN1505q LLC · Brunswick, GAS/N 15072805N15060Palm View Aircraft Corp · Santa Rosa Beach, FLBuilt 1960 · S/N 17941N1506MBonn Steven · Hummelstown, PABuilt 1975 · S/N 18264356N1506QDonald A D · Plano, TXBuilt 1971 · S/N 15072806N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634
Back to AD 97-01-13