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.

N16CJRoyale Air Service Inc · Fort Myers, FLS/N U20602501N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618N16EDSimply Living LLC · Fort Myers, FLBuilt 1985 · S/N 172RG1189N16EFAnything Aviation LLC · Fort Lauderdale, FLBuilt 1977 · S/N 15280441N16EKCenterline Holdings LLC · Belgrade, MTBuilt 1975 · S/N 17265927N16FHodge Justin Eugene · White Sands, NMBuilt 1956 · S/N 28327N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075N16GPDeckload Aviation LLC · Kodiak, AKS/N U20604467N16HTAviation Specialties Unlimited Inc · Boise, IDBuilt 1964 · S/N 2060134N16KFFournier Louis W · Fort Worth, TXBuilt 1965 · S/N 15061619N16KNIgwt Holding LLC · Richardson, TXBuilt 1965 · S/N 17253986N16MMGoff Bruce J · Williamstown, MABuilt 1981 · S/N 18268045N16MSEnergy Transfer Aviation LLC · Spring, TXBuilt 1979 · S/N 18267267N16PFTurbine Financial Group LLC · Ogden, UTS/N R1722771N16QCDawson Aircraft Inc · Clinton, ARS/N 421C0689N16RRAustin Donald E · Ripley, MSBuilt 1979 · S/N 15283120N16SBZabel Victor R · Albuquerque, NMBuilt 1956 · S/N 29272N16SHDickinson James C · Haslet, TXBuilt 1972 · S/N 15073404N16VCStallion Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267939N16VVLaughlin R C Jr · Boerne, TXBuilt 1967 · S/N R1720058N16WLLivingston Patricia R · Wasilla, AKS/N 17256545N17001Shields David A · Saylorsburg, PAS/N 15073572N17004Depietro Shelley Jo · Olympia, WABuilt 1972 · S/N 15073575N17009Wight John I · Anchorage, AKBuilt 1972 · S/N 15073578N1700CKrause Kade G · Jackson, MTBuilt 1953 · S/N 30400N1700MDeltahawk Engines Inc · Racine, WIBuilt 1970 · S/N 33701300N1700QAtkinson Jonathan E · Chapmansboro, TNBuilt 1971 · S/N 15073000N1701Rolston Charles W · Shoreview, MNBuilt 1964 · S/N 17252418N17014Alcorn Paul W · Bay City, MIS/N 15073581N17016Mika Brian D · Andover, MNBuilt 1972 · S/N 15073583N17019Reed James W · Boulder City, NVBuilt 1976 · S/N 17702496N1701RM R Planes LLC · Redmond, WABuilt 1974 · S/N 18502423N1701VBeach Chad T · Kilgore, TXBuilt 1974 · S/N 17262851N17021Fletcher John Guy · Diamondhead, MSS/N 15073587N1702CCork Dennis R · Soldotna, AKBuilt 1953 · S/N 30402N1702EExecutive Flight Institute LLC · Murrieta, CABuilt 1978 · S/N 17271101N1702QStrutzenberg Kent R · Manson, IABuilt 1971 · S/N 15073002N1702RDaniel Boone Flying Club Inc · Booneville, MOBuilt 1978 · S/N R18200523N1702VClassic Rotors Museum · Ramona, CABuilt 1974 · S/N 17263717N17033Browning Brad T · Lake Park, MNBuilt 1972 · S/N 150-73594N17039Davidson Luke H · Gilmer, TXS/N 15073597N1703MNesloney Thomas Jeffery · Hilltop Lakes, TXBuilt 1975 · S/N 18264417N1703QTroutman Noah M · Owensboro, KYBuilt 1971 · S/N 15073003N17043Coleman Sherod · Houston, TXBuilt 1972 · S/N 15073600N17045Streichenwein Scott F · Salisbury Mills, NYBuilt 1972 · S/N 15073602N17047Sickinger Alan W · New Philadelphia, OHBuilt 1972 · S/N 15073604N17048Myob Group LLC · Ocala, FLBuilt 1972 · S/N 15073605N17049101 Inc · Bejou, MNBuilt 1976 · S/N 17702497N1704QOlfert Ronald W Trustee · Frazer, MTS/N 18257248N1704UKuspuk School District · Aniak, AKBuilt 1975 · S/N 20700304
Back to AD 97-01-13