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.

N30239Jones Gary E · Orange, CABuilt 1968 · S/N 17701143N3023FJones Clinton D · Santa Rosa Beach, FLBuilt 1966 · S/N 18257123N3023SSynnes Dale C · Santa Paula, CABuilt 1967 · S/N 15066923N3023YMorgan Lee Blanchard · Albuquerque, NMFirst renewal noticeS/N 18254023N3024FSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18257124N3024XDavis James M · Tuscaloosa, ALBuilt 1966 · S/N 15064424N3024YTemple Curtis Lee · Porcupine, SDBuilt 1962 · S/N 18254024N30250O'Connor Sean J · Newburyport, MABuilt 1968 · S/N 17701150N3025FWarner Daniel M · Fremont, OHBuilt 1966 · S/N 18257125N3025SHummer Bryant C · Garden Plain, KSBuilt 1967 · S/N 15066925N3025UEddy Bruce A · Winfield, ALBuilt 1963 · S/N 17250625N3026FMock1 LLC · Abingdon, VABuilt 1966 · S/N 18257126N3026JRoberts James D Trustee · Omaha, NEBuilt 1965 · S/N 15061126N3026QSuper D Group LLC · Hanoverton, OHBuilt 1967 · S/N 18258026N3026SSolewin Kimberly M · Christoval, TXBuilt 1967 · S/N 15066926N3026VNew Mexico Flying Eagle Inc DBA · Tucson, AZS/N 15076355N3026YEpss LLC · Tavernier, FLBuilt 1962 · S/N 18254026N30275Tomlinson Douglas F · Waunakee, WIBuilt 1968 · S/N 17701167N30278Barron Joseph M · Des Moines, IABuilt 1975 · S/N 17264133N3027FSale Reported · Watford City, NDSale reported, pending cancellationBuilt 1966 · S/N 18257127N3027XSchneider Benjamin J · Wheeling, WVBuilt 1966 · S/N 15064427N30285Galena City School District · Galena, AKBuilt 1974 · S/N 17264135N3028QAllenspach Timothy L · Stillwater, MNBuilt 1967 · S/N 18258028N3028VChildress Sam · Weatherford, TXBuilt 1974 · S/N 15076357N3028XFicken Jerome L · Cedar Hill, MOBuilt 1966 · S/N 15064428N3028YStanton Tod J · Naperville, ILBuilt 1962 · S/N 18254028N30293Advantage Aviation Services LLC · South Saint Paul, MNBuilt 1968 · S/N 17701177N30297Siers Richard · Ocean Shores, WABuilt 1968 · S/N 17701178N3029JSorrells Brandon L · Yuma, AZBuilt 1965 · S/N 15061129N3029QOzarks Auto Show Inc · Hollister, MOBuilt 1967 · S/N 18258029N3029SBlawusch Richard K · Waterloo, WIBuilt 1967 · S/N 15066929N3029VFlyt LLC · Madison, MSS/N 15076358N3029XRegistered aircraftS/N 15064429N302AZavoina Lawrence D Jr · Roanoke, TXBuilt 1969 · S/N 68-11055N302DBHouston Chet H · Beaufort, SCBuilt 1968 · S/N 17701132N302GPInternational Air Services Inc Trustee · Carson City, NVS/N 21058682N302JAAviate LLC · Green Bay, WIBuilt 1977 · S/N 17269488N302MJ425 Partners LLC · Guymon, OKBuilt 1980 · S/N 425-0120N302USolomon Mark Trustee · Wilmington, DEBuilt 1964 · S/N 18255529N30302Kamenar Service LLC · Mukwonago, WIBuilt 1968 · S/N 17701180N30303Registration Pending · Meeker, CORegistration pendingBuilt 1968 · S/N 17701181N30304Williams Rod · Atascadero, CABuilt 1968 · S/N 17701182N30307Johnston Phillip Jr · Pensacola, FLBuilt 1968 · S/N 17701184N30308Griffith Scot E · Glendale, AZBuilt 1968 · S/N 17701185N3030EElon Aviation LLC · Burlington, NCBuilt 1978 · S/N 17271408N3030FThirty Thirty Club · Lebanon, ORBuilt 1966 · S/N 18257130N3030UAll Around Inc · Ramseur, NCBuilt 1963 · S/N 17250630N3030VSanders Flight Training Center Inc · Jasper, ALBuilt 1974 · S/N 15076359N3030YSamaniego Alejandro · Tucson, AZBuilt 1962 · S/N 18254030N30311Parker Yates · Wellington, TXBuilt 1968 · S/N 17701188
Back to AD 97-01-13