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.

N172WWStraight And Level Seaplanes LLC · Grand Island, FLBuilt 1976 · S/N 17267445N172XPTrapp Thomas A · Salem, CTBuilt 1979 · S/N R1723088N172XXRoberts Christopher B · Warner Robins, GAFirst renewal noticeS/N 47123N172YNewton Michael R · Creston, WABuilt 1974 · S/N 17263360N172YACf Images LLC · Fairfield, NJBuilt 1981 · S/N 17275080N172YHWild River Flying Club · Saint Croix Falls, WIBuilt 1979 · S/N 17271130N172YYApr Aviation · Fresno, CABuilt 1974 · S/N 17263986N172ZMoss Mark A · El Dorado, CABuilt 1969 · S/N 17258726N172ZGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 828N1730FSpragues Aerial Spraying Inc · Courtenay, NDBuilt 1966 · S/N 17255125N1730ZLoftis Kenneth L · Phoenix, AZBuilt 1963 · S/N 336-0030N1731FHostetler Robert J · Windyville, MOBuilt 1966 · S/N 17255126N1732FWicks Colton D · Cooper, TXBuilt 1966 · S/N 17255127N1732MCarey International Aviation Services LLC · Long Beach, NYBuilt 1970 · S/N 33701332N1732RHeath William D Jr · Bremen, GABuilt 1978 · S/N R18200539N1732VElk & Ram Aviation Group LLC · San Antonio, TXBuilt 1974 · S/N 17263729N1733FRegistered aircraftBuilt 1966 · S/N 17255128N1733RNorthstar Holdings LLC · Anchorage, AKBuilt 1973 · S/N U20602068N1734FWlb Farms LLC · Iota, LABuilt 1966 · S/N 17255129N1734XRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1975 · S/N 21060755N1735ERsc Ventures LLC · Phoenix, AZBuilt 1978 · S/N 310R1555N1735MG & M Aircraft Inc · Wheat Ridge, COBuilt 1975 · S/N 18264421N1735QMadden David · Bethlehem, NHBuilt 1971 · S/N 15073035N1736CThompson Frank L · Weiser, IDBuilt 1953 · S/N 30436N1737High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17265682N17371Lynch Kyle R · Palmetto, FLBuilt 1972 · S/N 15073714N17375Jts Aircraft LLC · Rock Hill, SCBuilt 1972 · S/N 15073718N1737CBristol Brian P · Webster, MNBuilt 1953 · S/N 30437N1737EKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1556N1737FVoltl Mike N · Coloma, WIS/N 17255132N1737MClinton Aviation Corp · Clinton, ARBuilt 1975 · S/N 18264423N1737QWilliams Kamille N · Juneau, AKS/N 15073037N1737RMorales Richard · Palm Springs, CABuilt 1978 · S/N R18200541N1737VWatson Patrick D · Kenyon, MNBuilt 1974 · S/N 17263732N17382Hagelstein Ele C · Sanderson, TXRegistration expired, pending cancellationBuilt 1972 · S/N 15073715N1738FWesley Emerson Holdings LLC · Clifton, TXBuilt 1966 · S/N 17255133N1739COpp Daniel · Anchorage, AKBuilt 1953 · S/N 30439N1739FSessions Jan · Kirbyville, TXBuilt 1966 · S/N 17255134N173BADunlap Jolene · Peoria, ILBuilt 1979 · S/N 17272370N173KADaigle Lawrence J · Cohasset, MNBuilt 1972 · S/N 17260939N173KMLd Enterprises Llp · Roswell, GABuilt 1968 · S/N 17257781N173LLRegistration Pending · Barrigada, GURegistration pendingBuilt 1982 · S/N 17275633N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960N173PKTrc-4k Investments LLC · Southlake, TXBuilt 1968 · S/N 17257364N173RGBuchert Christine W · SchweinfurtBuilt 1980 · S/N 172RG0218N173SKS Kamat Inc · Lexington, KYS/N 17272108N173VALegner Leasing LLC · Las Vegas, NVBuilt 1971 · S/N 172-60090N173VFCorlee Douglas K · Palm Coast, FLBuilt 1964 · S/N 17252157N173VRDauria William · Anna, TXBuilt 1971 · S/N 18260781N173YAHoekman Kenneth J · Sherwood, ARBuilt 1980 · S/N 17274191
Back to AD 97-01-13