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.

N2517JRegistered aircraftBuilt 1964 · S/N 15061017N2517LCarroll Mark E · Nicholasville, KYBuilt 1966 · S/N 17255717N2517YEbnet Joel · Holdingford, MNBuilt 1962 · S/N 17249817N2517ZGerrety Loren P · Anchorage, AKBuilt 1962 · S/N 185-0517N2518QSwaldi Thomas · Marion Heights, PABuilt 1966 · S/N 18257718N2518YTracy Michael S · Homer, AKBuilt 1962 · S/N 17249818N2519L2 G Group LLC · Honolulu, HIBuilt 1966 · S/N 17255719N2519RPentzien Inc · Omaha, NEBuilt 1967 · S/N 18258219N2519UBradford Murvin L · Hensley, ARS/N 17250119N251HPKoch & Koch Inc · Grass Valley, CABuilt 1982 · S/N 172RG1124N251JLGolden Eagle 421 LLC · Alsip, ILBuilt 1977 · S/N 421C0311N251RDidier Christopher W · Fay, OKBuilt 1972 · S/N 61139N251RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266249N251WWEbbert Thomas E DBA · Gary, INRegistration revokedBuilt 1967 · S/N 411-0251N2520GGrinch Aviation LLC · Madera, CABuilt 1959 · S/N 51820N2520LPeck M Hayden II · Bells, TXBuilt 1966 · S/N 17255720N2520QRcmt Properties LLC · Havre, MTBuilt 1966 · S/N 18257720N2520RWinston Douglas S · Star, IDBuilt 1967 · S/N 18258220N25216Mcfarlane Claude L III · Fitchburg, WIBuilt 1977 · S/N 15280534N2521GMountain Aviator LLC · Edwards, COBuilt 1959 · S/N 51821N2521LExpert Construction Services LLC · Mclean, VAFirst renewal noticeBuilt 1966 · S/N 17255721N2521YClanin James Robert · Vandalia, OHBuilt 1962 · S/N 17249821N25221Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280538N25225Howard Jeff S · Anderson, SCBuilt 1977 · S/N 15280541N25228Laguna Verde Leasing Inc · Wilmington, DES/N 15280543N2522GMull Morgan · Greensburg, PAS/N 51822N2522JGrowden David C · Bedford, PABuilt 1964 · S/N 15061022N2522QJohnson Sales & Service Inc · Ong, NEBuilt 1966 · S/N 18257722N2522RPechanec Brent L · Wichita, KSBuilt 1967 · S/N 18258222N2522WHollenbeck William M · Montrose, COS/N 17250128N25233Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280545N2523GDannebrog Air LLC · Grand Island, NEBuilt 1959 · S/N 51823N2523QLusk T Quizy · Springfield, COBuilt 1966 · S/N 18257723N2523RBergamaschi Brian A Trustee · Davis, CABuilt 1967 · S/N 18258223N2523YLawson Matt E · Gobles, MIBuilt 1962 · S/N 17249823N2524KGanz Brian L · Carlsbad, CABuilt 1978 · S/N 18052969N2524LGraham Jacob W · Rose Hill, KSBuilt 1966 · S/N 17255724N2524QBellamy Flying LLC · Elwood, NEBuilt 1966 · S/N 18257724N2524YPaul Danny W · Locust Grove, GABuilt 1962 · S/N 17249824N25255Flm Aviation LLC · Vernal, UTBuilt 1977 · S/N 15280556N2525GWoods Dana · Mountain View, ARBuilt 1959 · S/N 51825N2525JHector Lionel · Paisley, FLBuilt 1964 · S/N 15061025N2525QHohman Cory A · Lometa, TXBuilt 1966 · S/N 18257725N2525RBrandt Jimmie L · Elbert, COBuilt 1967 · S/N 18258225N2525ZMansfield Scott J · Wasilla, AKBuilt 1962 · S/N 185-0525N25265My Toys Inc · Spartanburg, SCS/N 15280561N25269Yankaskas Kurt D · Ijamsville, MDBuilt 1977 · S/N 15280563N2526RTalkeetna Denali View Lodge LLC · Talkeetna, AKBuilt 1967 · S/N 18258226N2526SPlane Nutz LLC · Sugar City, IDBuilt 1979 · S/N R18201347N2526YJahnke Ryan M · Grafton, WIBuilt 1962 · S/N 17249826
Back to AD 97-01-13