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.

N245JKSpruce Hill Leasing LLC · Hadley, MAS/N 414A0613N245JSFe Caravan LLC · Kinston, NCBuilt 2014 · S/N 208B5154N245THigh Country Aero Ltd · Berthoud, COS/N 421C1104N2460FRead Colin L · Plattsburgh, NYBuilt 1966 · S/N 18051662N2460JSmith Harry N · Glendale, AZBuilt 1966 · S/N 15065560N2460XHardy Gareld L · Rimrock, AZS/N 18256360N2461GSeven Hi Flying Club · Saratoga, CABuilt 1959 · S/N 51761N2461JWeidemann Wendell S · Madison, WIBuilt 1966 · S/N 15065561N2461RFx Mining LLC · Haines, AKBuilt 1964 · S/N 18255561N2461UHansen Aviation LLC · Savannah, GABuilt 1963 · S/N 17250061N2461XBallard Devin J · Quail, TXBuilt 1965 · S/N 18256361N2461YIbx Living LLC · Wake Forest, NCBuilt 1962 · S/N 17249761N2462EFive Six Zero One LLC · Orange, CABuilt 1978 · S/N 17271291N2462JBercaw Vaughn L · Beach City, TXBuilt 1966 · S/N 15065562N2462LSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 17255662N2462SLyon Joseph K · Mccall, IDBuilt 1967 · S/N 337-0762N2462UBixler Timothy · Wildwood, FLS/N 17250062N2463CWofford Johnny A · Fort Davis, TXBuilt 1963 · S/N 17250569N2463JTony Noyes · Lewisville, TXS/N 15065563N2463ULively Matt E · Aledo, TXBuilt 1963 · S/N 17250063N2463YCaylin LLC · Wilmington, DEBuilt 1962 · S/N 17249763N2464RStoffers William · Samoa, CABuilt 1964 · S/N 18255564N2464UFly By Faith LLC · Laurel Springs, NCBuilt 1963 · S/N 17250064N2464YHogan Dale R · Monterey, CABuilt 1962 · S/N 17249764N2465CToal Timothy R · Milan, ILBuilt 1954 · S/N 30765N2465ELeal Felipe · Missouri City, TXBuilt 1978 · S/N 17271292N2465GMunson Darrel L · Ogallala, NEBuilt 1959 · S/N 51765N2465JWalther Nora P · Ocala, FLBuilt 1966 · S/N 15065565N2465XK4 Land And Grain Co · Lothair, MTBuilt 1965 · S/N 18256365N2466EMarkham Dean F Jr · Greenville, NCBuilt 1978 · S/N 17271293N2466QWentworth Douglas G · Simpsonville, KYBuilt 1966 · S/N 18257666N2466RToland Beldon T · Dodge City, KSBuilt 1964 · S/N 18255566N2466UHolloway Andrew · David City, NEBuilt 1963 · S/N 17250066N2467FTherkelsen Robert D · Burlington, WABuilt 1966 · S/N 18051669N2467GShort David J · Warrensburg, MOBuilt 1959 · S/N 51767N2467JHenderson Samuel · Wasilla, AKS/N 15065567N2467LPatton Michael D · Tygh Valley, ORBuilt 1966 · S/N 17255667N2467RSparks Eric D · Missouri Valley, IABuilt 1964 · S/N 18255567N2468BRegistered aircraftBuilt 1970 · S/N 18260274N2468CHatley Ralph A · Eagle Creek, ORBuilt 1954 · S/N 30768N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294N2468LCavender Kevin S · Tucson, AZBuilt 1966 · S/N 17255668N2468RCruson Dale E Trustee · Ontario, ORBuilt 1964 · S/N 18255568N2468URegistration Pending · Washington, WVRegistration pendingBuilt 1963 · S/N 17250068N2469MDillehay David Lynn · League City, TXBuilt 1973 · S/N 15075201N2469QKepler Jason M · Wasilla, AKBuilt 1966 · S/N 18257669N2469RKrehbiel Doug W · Moscow, IDBuilt 1964 · S/N 18255569N2469XFraulini Michael M · Franklin Furnace, OHBuilt 1965 · S/N 18256369N2469YStanphill David L · Stephenville, TXBuilt 1962 · S/N 17249769N246BCKeystone Solutions LLC · Higley, AZS/N 18259539
Back to AD 97-01-13