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.

N3388YMeeks Peris M · Gardena, CAS/N 18254388N3389DRegistered aircraftBuilt 1955 · S/N 32187N3389EBarnfather James D · Sequim, WABuilt 1978 · S/N 17271528N3389UThompson Anthony D Trustee · Rockwall, TXS/N 18254789N338BMMorton William · Darby, MTBuilt 1979 · S/N 18267111N338CALincoln Skyways Inc · Lincoln, CABuilt 1978 · S/N 17269465N338HCapital Holdings Fund IV LLC · Boca Raton, FLBuilt 1982 · S/N 18504343N338LMSisk Stephen A · Greenville, ILBuilt 1968 · S/N 18259244N338TLMargolis Michael · Ruskin, FLBuilt 1973 · S/N 33701563N3390FRodgers Christian Joseph · Ormond Beach, FLS/N 18257390N3390JVandyke Dennis C · Rose Hill, VABuilt 1967 · S/N 15066090N3390TTucker Lon R · East Peoria, ILBuilt 1967 · S/N 17700690N3390YHead John T Jr · Port St Joe, FLS/N 18254390N3391EOcala Aviation Services Inc · Ocala, FLBuilt 1978 · S/N 17271529N3391FKingston Terry D · Irving, TXBuilt 1966 · S/N 18257391N3391TCardinal Wings LLC · Middletown, DEBuilt 1968 · S/N 17700691N3392DHaszard John R · Ophelia, VABuilt 1955 · S/N 32190N3393TWilcox Russell J · Salinas, CABuilt 1967 · S/N 17700693N3394DCartledge Charles J · Orrville, OHBuilt 1955 · S/N 32192N3394RCurren Patrick V · Green Bay, WIBuilt 1967 · S/N 18258694N3394TPekrul Eric C · Frankfort, MIBuilt 1968 · S/N 17700694N3394YNolt Ivan M · Mount Solon, VABuilt 1962 · S/N 18254394N3395DFitzgerald John A Jr · Ester, AKBuilt 1955 · S/N 32193N3395JFly N Style · Parkland, FLBuilt 1967 · S/N 15066095N3395RJohnston Osceola Holdings LLC · Dallas Center, IABuilt 1968 · S/N 18258695N3395YTriple J Aviation · East Quogue, NYS/N 18254395N3396FThompson Patrick J · Evanston, WYBuilt 1966 · S/N 18257396N3396RSimmons Craig · Houston, TXBuilt 1967 · S/N 18258696N3396VHarvey Christopher J · Port Leyden, NYBuilt 1974 · S/N 15076488N3396YPlane Fun Inc · Lewes, DEBuilt 1962 · S/N 18254396N3397FKerns Aaron R · Sullivan, INBuilt 1966 · S/N 18257397N3397GPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1976 · S/N 310R0821N3397JZwerko Sherri · South Plainfield, NJBuilt 1967 · S/N 15066097N3397RKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1967 · S/N 18258697N3397SMcrae Richard · Kent, WABuilt 1969 · S/N 21059197N3397TMckinney Adrian R · Mineral Wells, TXBuilt 1967 · S/N 17700697N3398QRiebe Grover C Jr · Gwinner, NDBuilt 1969 · S/N 421A0108N3398YBobbitt Michael · Lamont, OKBuilt 1962 · S/N 18254398N3399FVetter T Kevin Trustee · Phoenix, AZBuilt 1966 · S/N 18257399N3399LMetz William · Laurel, MTS/N 185-1351N3399QBaron Aviation Corporation · Broad Run, VABuilt 1975 · S/N 310R0304N3399RGleason Joseph P · Knoxville, TNBuilt 1967 · S/N 18258699N3399UWorley Dan J · Perris, CABuilt 1963 · S/N 18254799N339CHPitch And Power LLC · Indianapolis, INBuilt 1977 · S/N 18265213N339CPHenley Mark L · Emelle, ALBuilt 1966 · S/N 18257470N339DGRegistered aircraftS/N P21000434N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119N339MSMile And A Half High LLC · Sarasota, FLS/N 21062036N339TAFloatsix Leasing LLC · Lubbock, TXBuilt 2015 · S/N 208B5179N33ADSouthern Turf Services LLC · West Palm Beach, FLBuilt 1973 · S/N 414-0412
Back to AD 97-01-13