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.

N2434CGoad Graham L · Mcminnville, ORBuilt 1954 · S/N 30734N2434FHanson Inc · Kalispell, MTS/N 18051634N2434JSkyhawk Aero LLC · Montevideo, MNS/N 15065534N2434LWeston Torey C · Unionville, MOBuilt 1966 · S/N 17255634N2434USkyhawk N2434u LLC · Wilmington, DEBuilt 1963 · S/N 17250034N2434XJensen Shaun V · Anchorage, AKBuilt 1965 · S/N 18256334N24351426th Aero Squadron LLC · Cropwell, ALBuilt 1977 · S/N 15280230N2435FBas Part Sales LLC · Greeley, COS/N 180-51635N2435GVoninski John R · Manlius, NYS/N 51735N2435JWitherspoon Jason C · Austin, ARBuilt 1966 · S/N 15065535N2435LAero Science International LLC · Augusta, GABuilt 1966 · S/N 17255635N2435QVolare Aviation LLC · Wylie, TXBuilt 1966 · S/N 18257635N2435UGalati Stephen E · Florissant, MOBuilt 1963 · S/N 17250035N24363Sale Reported · Crystal, MNSale reported, canceledBuilt 1977 · S/N 15280235N24364Monsalve Carlos M · Lewiston, NYBuilt 1977 · S/N 15280236N2436CHawk Unlimited LLC · Kalispell, MTS/N 30736N2436GDk Futures LLC · Reno, NVBuilt 1959 · S/N 51736N2436RSilva Gary · Yerington, NVBuilt 1964 · S/N 18255536N2436SCranney Dan Gordon · Sevier, UTBuilt 1967 · S/N 337-0736N24373Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280240N2437CFogleman Brian L · Stonewall, LAS/N 30737N2437FKuersten Robert S · Middleton, WIBuilt 1965 · S/N 18051637N2437RBlackwelder John W · Columbia, KYBuilt 1964 · S/N 18255537N2437XLudke Arnold · Oakland, NJBuilt 1965 · S/N 18256337N2437YRussell John D · Dana Point, CABuilt 1962 · S/N 17249737N24385Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1977 · S/N 15280248N2438GWk Aviation LLC · Buffalo, SDBuilt 1959 · S/N 51738N2438JVayner Anton · Shorewood, WIBuilt 1966 · S/N 15065538N2438UThweatt Greg K · Lodi, CABuilt 1963 · S/N 17250038N2438XRousser Cattle LLC · Amarillo, TXBuilt 1965 · S/N 18256338N2438YHoskins Aaron C · Cayuga, NYBuilt 1962 · S/N 17249738N24399Lcc North LLC · Freehold, NJBuilt 1977 · S/N 15280252N2439GJ+J Electric LLC · Seminole, TXBuilt 1959 · S/N 51739N2439JHenderickson Robert T · Galesburg, ILBuilt 1966 · S/N 15065539N2439LBetts William B · Big Lake, AKS/N 17255639N2439USmith Steven T · Charlottesville, VABuilt 1963 · S/N 17250039N2439XAlpha Aero LLC · Biddle, MTBuilt 1965 · S/N 18256339N2439YBluegate Engineering LLC · Richburg, SCBuilt 1962 · S/N 17249739N243MBSwanson Timothy J · Bannister, MIBuilt 1967 · S/N 337-0813N243PWTexas Parks And Wildlife Department · Austin, TXBuilt 2025 · S/N 208B5855N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205N244004 One Air LLC · Holland, MIBuilt 1977 · S/N 15280253N24403Somboonsap Patanapong · Oakland Park, FLBuilt 1977 · S/N 15280254N2440JOliver Tim J · San Luis Obispo, CABuilt 1966 · S/N 15065540N2440LEads Kevin C · Arley, ALBuilt 1966 · S/N 17255640N2440UMiller Patrick · Madison, MNBuilt 1963 · S/N 17250040N2440YMorristown Flying Service Inc · Talbott, TNBuilt 1962 · S/N 17249740N2441RBelly Acres Capital And Management LLC · Memphis, TNBuilt 1964 · S/N 18255541N2442CRoberts Calvin · Bluebell, UTBuilt 1954 · S/N 30742N2442EExecutive Flyers Inc · Sacramento, CABuilt 1978 · S/N 17271285
Back to AD 97-01-13