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.

N2504RJht Aviation LLC · Longview, TXBuilt 1967 · S/N 18258204N25053Southwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15280517N25057Nino Jose · Kenilworth, NJBuilt 1977 · S/N 15280520N2505LCannon Jason P · La Verne, CABuilt 1966 · S/N 17255705N2505YGauges Green LLC · Euless, TXS/N 17249805N2506Cessna N2506 LLC · Doral, FLS/N 33701871N2506QJohnson Jason D · Doniphan, MOBuilt 1966 · S/N 18257706N2506SByers Roger G · Lake Elmo, MNS/N 21061309N2506USterling John A · Port Lavaca, TXBuilt 1963 · S/N 17250106N2506YTouching Clouds LLC · Bridgeview, ILBuilt 1962 · S/N 17249806N2507GBanks Gary M Jr Trustee · Scituate, MABuilt 1959 · S/N 51807N2507JDarter Lloyd R · Mountain Grove, MOBuilt 1979 · S/N T18803469TN2507RKandle Sherry A · Boise, IDBuilt 1967 · S/N 18258207N2507YGap Mountain Development LLC · Jaffrey, NHBuilt 1962 · S/N 17249807N2508GBig Well Flying Club Inc · Kinsley, KSBuilt 1959 · S/N 51808N2508RBrodt Gregory L · Chetek, WIBuilt 1967 · S/N 18258208N2508YWarren Jerry L · Medford, ORS/N 17249808N2509KHolcomb John R · Siloam Springs, ARBuilt 1978 · S/N 18052962N2509LSchufeldt Lawrence H · North Platte, NEBuilt 1966 · S/N 17255709N2509USnyder Mari A · Brighton, COBuilt 1963 · S/N 17250109N2509YAgha-Khan Sikander B · Carolina Shores, NCBuilt 1962 · S/N 17249809N250CW250 Charlie Whiskey LLC · Topeka, KSBuilt 1982 · S/N 18268273N250FBishop Thomas W · Decatur, TXBuilt 1959 · S/N 52184N250GCCarroll James E Trustee · Newington, NHBuilt 1977 · S/N 18266130N250LMenefee Scott A · Los Banos, CABuilt 1979 · S/N R18200936N250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266043N2511798x LLC · Caddo Mills, TXBuilt 1970 · S/N 17259514N2511DDfs2024 LLC · Edwards, COBuilt 1979 · S/N 18266873N2511LDmcflight LLC · Boynton Beach, FLS/N 17255711N2511RDickey Mark D · Pendleton, ORS/N 18258211N2512GSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 51812N2512JHaller David Henry Trustee · Grover Beach, CABuilt 1964 · S/N 15061012N2512QPeacock Jeffery D · Cleburne, TXS/N 18257712N2512SCorsentino Joseph · Temple, TXRegistration revokedBuilt 1967 · S/N 337-0812N2512UNative Sons Aviation LLC · Lake Placid, FLBuilt 1963 · S/N 17250112N2513GSedlickas Mark A · Graham, WABuilt 1959 · S/N 51813N2513JT3 Flight Time Building LLC · Richmond Hill, GAS/N 15061013N2513KCarlson Thomas G · Anchorage, AKBuilt 1978 · S/N 18052964N2513LDahlberg James C · Ogilvie, MNBuilt 1966 · S/N 17255713N2513YWilson Hubert Ernest · Gustavus, AKBuilt 1962 · S/N 17249813N2514LRegistration Pending · Macclenny, FLRegistration pendingS/N 17255714N2514RRichmond Patrick A · Glenmora, LABuilt 1967 · S/N 18258214N2514UHenson David C · Fort Worth, TXBuilt 1963 · S/N 17250114N2514YBargabos Julie A · Peterboro, NYBuilt 1962 · S/N 17249814N2515JStockweather Eric A · Normal, ILBuilt 1964 · S/N 15061015N2515LClear Air Aviation LLC · Talkeetna, AKBuilt 1966 · S/N 17255715N2516LFlores E Alex · Missouri City, TXBuilt 1966 · S/N 17255716N2516ULofton Johnathan V · Springer, OKBuilt 1963 · S/N 17250116N2516VGreat Adventure Sailing Vessell LLC · Greer, SCBuilt 1974 · S/N 177RG0601N2516YSchutjer Dennis · Clear Lake, IABuilt 1962 · S/N 17249816
Back to AD 97-01-13