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.

N2911UNight Sky LLC · Canton, SDBuilt 1963 · S/N 17250511N2911XRobbins Donald V · Anchorage, AKBuilt 1967 · S/N 17700311N2911YBennett John M · Cameron, NCBuilt 1962 · S/N 18253911N29127Shivers William L Jr · Friday Harbor, WABuilt 1968 · S/N U206-1097N2912CMarshalee Arizona LLC · Tempe, AZBuilt 1954 · S/N 30812N2912SWard Ascher · Oxnard, CAS/N 15066812N29130Ernst Gregory R · Eagle Creek, ORS/N U206-1100N2913CUnable Direct LLC · Kalispell, MTBuilt 1954 · S/N 30813N2913EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271371N2913JMulti Engine Training Co Inc · Tuttle, OKS/N 15065713N2913SMartin Richard E · Palmyra, WIBuilt 1967 · S/N 15066813N29142Hall Darryl Wayne II · Wasilla, AKS/N U206-1112N2914CSterkel Jared · Anchorage, AKBuilt 1954 · S/N 30814N2914FHarris Zadok · Upland, CABuilt 1965 · S/N 18257014N2914JMaverick Aviation Holdings LLC · Sheridan, WYS/N 15065714N2914KWildness Aviation Limited · Morrison, COS/N 18053127N2914USethi Inderdeep S · Tracy, CABuilt 1963 · S/N 17250514N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121N29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeBuilt 1974 · S/N 17264103N2915CField Jeff H · Simi Valley, CAFirst renewal noticeBuilt 1954 · S/N 30815N2915FStoffregen Thomas S · Milton, WVBuilt 1966 · S/N 18257015N2915SKoch Kenneth Scott · Coolidge, AZS/N 15066815N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133N29168Galer Michael J Jr · Lockwood, MOBuilt 1974 · S/N 17264105N2916AMetro Service Air Inc · Fairbanks, AKBuilt 1953 · S/N 30116N2916FAndros Marketing LLC · Fort Lauderdale, FLBuilt 1966 · S/N 18257016N2916UJohnson Mark D · Camano Island, WABuilt 1963 · S/N 17250516N29173Aerial Transport LLC · Wilmington, DEBuilt 1968 · S/N U206-1140N2917CParks Joseph S · Wilmington, NCBuilt 1954 · S/N 30817N2917FBennett David D · Clinton, WABuilt 1966 · S/N 18257017N2917JRegistration Pending · Noblesville, INRegistration pendingBuilt 1966 · S/N 15065717N2917SItz LLC · Lusby, MDBuilt 1967 · S/N 15066817N2917UCelebrate Freedom Foundation · West Columbia, SCS/N 17250517N29181Wings Of Faith · Stevensville, MTBuilt 1968 · S/N U206-1147N29186Thoroughbred LLC · Kalispell, MTBuilt 1968 · S/N U206-1151N29188Rugger Investment Group LLC · Tustin, CABuilt 1968 · S/N U206-1153N2918EDelpenn Flyers Inc · Dover, DEBuilt 1978 · S/N 17271372N2918JNiemann Benjamin W · Welton, IAS/N 15065718N2918KHolmes Ronald W · Kent, ORS/N 18053128N2918SAbove All Aviation Inc · Goleta, CABuilt 1967 · S/N 15066818N2919CRudolph Darren M · Wasilla, AKBuilt 1954 · S/N 30819N2919FPerez Adolfo · Conroe, TXBuilt 1966 · S/N 18257019N2919KWoodaire Ltd · Coeur D Alene, IDBuilt 1979 · S/N 18053129N2919SJust Plane Corp · Kokomo, INS/N 15066819N291ANKb Flies LLC · Amarillo, TXS/N 421C0242N291DCT G Dunn Plumbing Inc · Hulls Cove, MEBuilt 1953 · S/N 30110N291KFTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1972 · S/N 17260482N291RBAbbott Air Inc · Hydro, OKBuilt 1982 · S/N 414A0836N291RPGtr Aero LLC · Moultonborough, NHBuilt 1981 · S/N 17274327
Back to AD 97-01-13