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.

N3299JEdwards Wallace · Commerce, MIS/N 15065999N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199N3299SS V Aeronautics LLC · Afton, WYBuilt 1964 · S/N 18255799N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599N3299URichardson Ronnie L Jr · East Wenatchee, WAFirst renewal noticeBuilt 1963 · S/N 18254699N3299VChannel City Flyers Inc · Goleta, CABuilt 1974 · S/N 15076452N329DJBritt Matthew W · Trenton, SCBuilt 1976 · S/N 177RG0845N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835N32AKHummel Karl · Brooklyn, NYBuilt 1973 · S/N 18261935N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249N32CHHeckler Gary C · Carefree, AZBuilt 1966 · S/N 18257332N32CWMcdiarmid Jeffrey · Walla Walla, WABuilt 1977 · S/N 18265680N32DBCarpenter Forrest A · Berthoud, COBuilt 1966 · S/N 18051714N32EKTips Dan N · Plano, TXBuilt 1963 · S/N 18051264N32ELCoastal Air LLC · Naknek, AKBuilt 2002 · S/N 208B0960N32FCZimin Randolph · South Naknek, AKBuilt 1953 · S/N 30431N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019N32NHIsr Platforms LLC · Mclean, VABuilt 2017 · S/N 208B5360N32PLDiette Paul S · Middlebury, VTBuilt 1980 · S/N 18267595N32PXKustatan Leasing LLC · Kenai, AKBuilt 1976 · S/N U20603343N32RLVb Glass Company Inc · Jamestown, CAS/N U20605551N32TCarolina Blue Aviation LLC · Villanova, PABuilt 1978 · S/N 18266670N32TLJonesboro Cycle And Atv LLC · Bone, ARBuilt 1974 · S/N 310R0032N32VSpeer Aviation LLC · Evansville, INBuilt 1977 · S/N 340A0250N32VACommonwealth Of Virginia · Richmond, VABuilt 1974 · S/N 182-63322N32VSCraftline LLC · Delray Beach, FLS/N 340-0025N32WAWright Air Service Inc · Fairbanks, AKBuilt 1991 · S/N 208B0234N32YAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273862N32ZZJp Lemke Aviation LLC · Jenison, MIBuilt 1977 · S/N 18265469N3300AAdams Air & Sea Inc · Wilmington, DEBuilt 1969 · S/N 337-1094N3300JIngram Jay Wallis · El Paso, TXBuilt 1966 · S/N 15066000N3300YRaulston Electric LLC · Bagwell, TXBuilt 1962 · S/N 18254300N3301DJohnson Peter L · Chico, CAS/N 32099N3301RJuliet Zulu Holdings LLC · Dover, DEBuilt 1967 · S/N 18258601N3301VErhard Robert T · Granville, OHBuilt 1974 · S/N 15076453N3302JWignot Andrew R · Oceanside, CABuilt 1966 · S/N 15066002N3302YFoster James R · Mcpherson, KSBuilt 1962 · S/N 18254302N3303JWilliams Charles S · Pearland, TXBuilt 1967 · S/N 15066003N3303YWoolery David W Jr DBA · Lathrop, MOBuilt 1962 · S/N 18254303N3304FStephan Pamela K · Anchorage, AKBuilt 1966 · S/N 18257304N3305RLivingston Sonja L · Redding, CABuilt 1967 · S/N 18258605N3305YWolfe Randall S · Wasilla, AKBuilt 1962 · S/N 18254305N3306CSkylane Inc · Schaumburg, ILBuilt 1978 · S/N R18200269N3306DAlquist Kevin B · Edwardsville, KSBuilt 1955 · S/N 32104N3306EBlackwell Calvin C · Fort Worth, TXBuilt 1978 · S/N 17271498N3306JRound Engine Aero · Nashville, MIBuilt 1966 · S/N 15066006N3306UMartin Paul R Jr · Greensboro, GABuilt 1963 · S/N 18254706N3306YSaunders Craig · Spring Hill, FLBuilt 1962 · S/N 18254306
Back to AD 97-01-13