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.

N2785UN2785u LLC · Hilton, NYBuilt 1963 · S/N 17250385N2786FChristoph Nicolas T · Okanogan, WABuilt 1966 · S/N 18256886N2786GAvery John W · Fergus Falls, MNFirst renewal noticeBuilt 1959 · S/N 52086N2786UBoos Daniel Paul · Jackson, WYBuilt 1963 · S/N 17250386N2786XRegistered aircraftBuilt 1965 · S/N 18051586N2787FWammen Gil V · Reva, SDBuilt 1966 · S/N 18256887N2787GGomez Bermudex Investments LLC · Lauderhill, FLS/N 52087N2787JLarson Jared E · Wasilla, AKBuilt 1969 · S/N 185-1537N2787KWhirlwind Aviation Inc · Fisher, ARBuilt 1979 · S/N 18053068N2787LGateway Flying Club Inc · Saint Louis, MOBuilt 1967 · S/N 17255987N2787QThorell Farms Inc · Loomis, NES/N 18257987N2787UNethery Autumn M · Shelbyville, KYBuilt 1963 · S/N 17250387N2788FShryock Patrick D · King Salmon, AKS/N 18256888N2788GCaldwell Gregg P · Desert Hot Springs, CABuilt 1959 · S/N 52088N2788QKahle Matthew N · Paw Paw, MIBuilt 1967 · S/N 18257988N2789FHouck Joshua B · Wa Ct House, OHS/N 18256889N2789JStephens Mark E Trustee · Morgan Hill, CABuilt 1975 · S/N A1500601N2789LChurch Sammy H · Statesville, NCBuilt 1967 · S/N 17255989N2789QCenterline LLC · Yankton, SDBuilt 1967 · S/N 18257989N2789UKruse Russell E Jr · Siren, WIBuilt 1963 · S/N 17250389N278BDStubbs J Phillip · Richmond, VABuilt 1967 · S/N 17255945N278CFInfinity Aviation LLC · Mandan, NDBuilt 1981 · S/N 18504228N278HJJohnson Joel P · Duluth, MNBuilt 1967 · S/N 185-1268N278PBP21000318 Inc Trustee · Wilmington, DEBuilt 1979 · S/N P21000318N278SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0571N2790GBryan Roger J · Spearfish, SDBuilt 1959 · S/N 52090N2790JLock Robert Allen · Grand Haven, MIBuilt 1975 · S/N A1500602N2790LWells Mark L · Eads, TNBuilt 1967 · S/N 17255990N2790QArthur Lloyd T · Greenfield, INS/N 18257990N2791GHoutte Edmund Michael DBA · Palmer, AKBuilt 1959 · S/N 52091N2791JPuget Sound Flyers Inc · Everett, WABuilt 1975 · S/N A1500603N2792FRoshong Loman · Leesville, LABuilt 1966 · S/N 18256892N2792GSpeedstar Aviation LLC · Kalispell, MTBuilt 1959 · S/N 52092N2792JAndresen Leonard W · Anchorage, AKBuilt 1969 · S/N 185-1542N2792QPalmer Paul F · Donnelly, IDBuilt 1967 · S/N 18257992N2793GMeyer Steven D · Snohomish, WABuilt 1959 · S/N 52093N2794GClark Jeremiah Jacob · Pleasant Plains, ARBuilt 1959 · S/N 52094N2794JRegistration Pending · Anchorage, AKRegistration pendingBuilt 1969 · S/N 185-1546N2794QVincer Way LLC · Centennial, COBuilt 1967 · S/N 18257994N2795FSmith Casey T · Marietta, GABuilt 1966 · S/N 18256895N2795JEndeavour Flight Training Inc · Miami, FLBuilt 1979 · S/N 17273650N2795LHarkness Paul E · Richmond Hill, GABuilt 1967 · S/N 17255995N2795URichardson Robert S · Austin, TXBuilt 1963 · S/N 17250395N2796FX-Ray Engineering Corp · Port Orange, FLS/N 18256896N2796GDouglas Cattle LLC · Douglas, AZBuilt 1959 · S/N 52096N2796LSmyth Michael L · Saint Charles, MOBuilt 1967 · S/N 17255996N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324N2797FWhatley Charles J · Goliad, TXBuilt 1965 · S/N 18256897N2797JAlaska Ultimate Safaris LLC · Homer, AKBuilt 1969 · S/N 185-1555N2798CStone Aviation LLC · Sacramento, CABuilt 1978 · S/N R18200228
Back to AD 97-01-13