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.

N2356RBledsoe Charles J · Jackson, GABuilt 1964 · S/N 18255456N2356UPanko Jeffrey A · Lusby, MDS/N 17249956N2357FBachand Kevin L · Leesburg, VABuilt 1964 · S/N 21058557N2357XScavera Kevin · Madras, ORBuilt 1965 · S/N 18256257N2358EAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 17250725N2358FEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 21058558N2358SBornhoft Jerome T · Riverton, WYBuilt 1979 · S/N R18201333N2358URegistration Pending · Cave Creek, AZRegistration pendingBuilt 1962 · S/N 17249958N2359FSheldon David E Trustee · Idaho Falls, IDBuilt 1964 · S/N 21058559N2359RTide City Air LLC · Germantown, TNBuilt 1964 · S/N 18255459N2359XHarker Charles R · Suwanee, GABuilt 1965 · S/N 18256259N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159N235AZSchlenker David D · Marine St Crx, MNBuilt 1980 · S/N R18201658N235HLBeach Norman G Jr · Newman, CABuilt 1978 · S/N 18266526N235NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274911N2360CCkt Aviation LLC · Anchorage, AKBuilt 1953 · S/N 30660N2360GVath Edward V · Acton, CABuilt 1958 · S/N 51660N2361GMcmanigle Jeffrey M · Osakis, MNBuilt 1958 · S/N 51661N2362RBarone Christian · Stratham, NHBuilt 1964 · S/N 18255462N2362SMclaren Institute Of Transporation Technologies · Goode, VABuilt 1967 · S/N 337-0662N2362XFort Scott Family Medicine Pa · Fort Scott, KSBuilt 1965 · S/N 18256262N2363FColumbus State Community College · Columbus, OHBuilt 1964 · S/N 21058563N2363GSawaya Mark C · Spring Valley, CABuilt 1958 · S/N 51663N2363RVertikle Enterprises LLC · Cheyenne, WYBuilt 1964 · S/N 18255463N2363XShort Joe · Clintwood, VABuilt 1965 · S/N 18256263N2363YPlane Pro Aviation LLC · Shelby, NCBuilt 1967 · S/N 17700163N2364CMeinershagen Charles I · Redding, CABuilt 1953 · S/N 30664N2364FCarlson David G Trustee · Cape Fair, MOBuilt 1964 · S/N 21058564N2364GTveitnes Svein T · Whitewright, TXBuilt 1958 · S/N 51664N2364RRegistered aircraftBuilt 1964 · S/N 18255464N2364XElkhorn Aviation LLC · Norfolk, NEBuilt 1965 · S/N 18256264N2365CStrolin LLC · Maple Valley, WABuilt 1978 · S/N R18200162N2366CKase Gayle L · Wasilla, AKBuilt 1953 · S/N 30666N2366EWerner Service & Trucking Inc · Saint Edward, NEBuilt 1982 · S/N 18268197N2366SDaughtrey Kevin E · Arcadia, FLS/N 337-0666N2367GSahagun Salvador G · Bothell, WAS/N 51667N2368UPlehn Thomas R · Las Vegas, NVBuilt 1962 · S/N 17249968N2368XD C T LLC · Wallace, IDBuilt 1965 · S/N 18256268N2369CBlackert Charles M · Delaware Water Gap, PABuilt 1954 · S/N 30669N2369GPeter Travis E · Casper, WYBuilt 1958 · S/N 51669N2369UMahoney Brandon M · Laurelville, OHS/N 17249969N2369YMischel John Patrick · Salyersville, KYBuilt 1967 · S/N 17700169N236AMyotis Ltd · Leesburg, VABuilt 1973 · S/N 18262695N236AFAero Fisheries Inc · Fort Pierce, FLBuilt 1976 · S/N 17267726N236AGTroposphere Ventures LLC · Fond Du Lac, WIBuilt 1978 · S/N R18200788N236ATN236at LLC · Miami, FLBuilt 1975 · S/N 414-0805N236DAFalany Curtis E · Tallahassee, FLBuilt 1966 · S/N 17254466N236KAKamaka Air LLC · Honolulu, HIBuilt 2008 · S/N 208B2034N236NYCivil Air Patrol Inc · Maxwell Afb, ALS/N 17268975N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116
Back to AD 97-01-13