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.

N2105YLulays Aviation LLC · Salem, ORBuilt 1962 · S/N 17249605N2105ZErickson Bernard R · Saint Cloud, MNS/N 18051205N21064Kelly John M · Gastonia, NCBuilt 1972 · S/N 18261391N21074Church Brian Lee · Del Mar, CABuilt 1972 · S/N 18261396N2107FRymski Daniel L · Colorado Springs, COBuilt 1965 · S/N U206-0307N2107RDickman Steve · Anchorage, AKBuilt 1964 · S/N 18255307N2107YOsborne Daniel M · Vero Beach, FLS/N 17249607N21082Bolder Services LLC · Broomfield, COBuilt 1972 · S/N 18261401N21085Cundiff Hugh A · Clinton, NCBuilt 1972 · S/N 18261402N21087Estes Marine LLC · Fort Lauderdale, FLBuilt 1972 · S/N 18261404N21088Sky Cardinal LLC · Rancho Santa Fe, CABuilt 1972 · S/N 18261405N2108ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271159N2108RWard Neal Cpas Pc · Scottsdale, AZBuilt 1964 · S/N 18255308N2108URoy Roland P · Lewiston, MEBuilt 1956 · S/N 29480N2108YNorthwest Wings LLC · Hillsboro, ORBuilt 1962 · S/N 17249608N21093Matson John R · Stoughton, WIBuilt 1972 · S/N 18261408N21096Ballard Gregg A · Cedar City, UTBuilt 1972 · S/N 18261411N21097Atb Aviation LLC · Wilmington, DEBuilt 1972 · S/N 18261412N21099Ricke Ryan · Hutchinson, MNBuilt 1972 · S/N 18261413N2109RVilt Jared J · Phelan, CABuilt 1964 · S/N 18255309N2109YSnyder Chris · Olean, NYBuilt 1963 · S/N 17249609N210ADUniplane Inc Trustee · Wilmington, DEBuilt 1967 · S/N 210-58835N210AKMaxinkuckee Aviation LLC · Columbus, INS/N 21061627N210ANCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17264678N210APRegistration Pending · Wilmington, DERegistration pendingBuilt 1965 · S/N 21058713N210ATTeeters David A · Salinas, CABuilt 1969 · S/N 21059186N210AWJohnson Matt R · Fox Island, WABuilt 1964 · S/N 21058492N210BBCherry Hill Aviation C182 LLC · Freetown, INBuilt 1979 · S/N R18201430N210BESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N P210-00088N210BGTurner Kenneth W · Arlington, WABuilt 1978 · S/N P21000025N210BJSummers Equipment Leasing Inc · Wilmington, DEBuilt 1974 · S/N 21060221N210BNBy Land Air And Sea LLC · Alto, MIBuilt 1974 · S/N 21060526N210BTGood Aviation LLC · Oshkosh, WIBuilt 1979 · S/N P21000555N210BVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 21061114N210BWSc & Dss LLC · Mckinney, TXBuilt 1976 · S/N 21061483N210BXNova Aircraft Holdings Inc · San Diego, CABuilt 1972 · S/N 21059583N210CJettech Holdings LLC · Broomfield, COBuilt 1979 · S/N P21000218N210CEMaas Aviation LLC · Pewaukee, WIBuilt 1980 · S/N P21000563N210CHOne Up LLC · Stuttgart, ARBuilt 1974 · S/N 21060142N210CPToeppen Chris P · Atherton, CABuilt 1979 · S/N P21000230N210CUTcl Fbo LLC · Tuscaloosa, ALBuilt 1981 · S/N 21064452N210CWBeach Partnership LLC · Myrtle Beach, SCBuilt 1979 · S/N 21063595N210DCRrr Land & Cattle Co LLC · Midland, TXBuilt 1973 · S/N 21060159N210DDDwoskin David F Trustee · San Pedro, CABuilt 1976 · S/N 21061464N210DGWashburn Stig K · Westminster, MABuilt 1972 · S/N 21059559N210DLDaneco LLC · Houma, LABuilt 1978 · S/N P21000114N210DNMartin John J · Honesdale, PAS/N 21059676N210DWBlomberg Nicholas R · Macon, MOBuilt 1967 · S/N 21058876N210EBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058365N210EAFollis Allen J · San Tan Valley, AZFirst renewal noticeBuilt 1962 · S/N 21057973
Back to AD 97-01-13