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.

N1679MVaughns Flying Service Inc · Reese, MIBuilt 1971 · S/N 18501870N1679QRegistration Pending · Fulton, MSRegistration pendingBuilt 1971 · S/N 15072979N1679ZRiemer Emil F · Brush Prairie, WABuilt 1962 · S/N 185-0479N167AWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 340A0537N167BHHolliday Robert R · Andover, KSBuilt 1966 · S/N 17255345N167LHIntercontinental Commercial Aircraft Inc · Morriston, FLNon-citizen corporation, flight hours not reportedS/N 208B1162N167WAGrid Aero Inc · San Leandro, CABuilt 1976 · S/N 402B1044N1680CRogers Terrence W · Almond, WIBuilt 1953 · S/N 30380N1680FBoyette Robert Wayne · Ashford, ALBuilt 1966 · S/N 17255075N1680QHanke Kenneth O · Clio, SCBuilt 1971 · S/N 15072980N1680RSchulze Roger F · Hanford, CABuilt 1978 · S/N R18200512N1681CClark Eddie · Naknek, AKBuilt 1953 · S/N 30381N1681FRegistered aircraftBuilt 1966 · S/N 17255076N1682CFly & Fish LLC · Kalispell, MTBuilt 1953 · S/N 30382N1682FBravo Zak Air LLC · Lake Wales, FLBuilt 1966 · S/N 17255077N1682RDelcamp Don D · Troy, OHBuilt 1978 · S/N R18200513N1682YStorby Steven R · Osceola, WIBuilt 1962 · S/N 17249382N1683YKnutson Daniel T · Lodi, WIBuilt 1962 · S/N 17249383N1683ZSchmitz David K · Spooner, WIBuilt 1962 · S/N 185-0483N1684CBredin William B · Anchorage, AKS/N 30384N1684FRedmon Robert J · Gallatin, TNBuilt 1966 · S/N 17255079N1684YKoenig William J · Benedict, MDS/N 17249384N1685CBallard Heather A · Pleasant Prairie, WIS/N 30385N1685QMore Right Rudder LLC · Newnan, GABuilt 1971 · S/N 15072985N1686CButts Michael D · Carson City, NVBuilt 1953 · S/N 30386N1686ELiddick Terry S · Spearfish, SDBuilt 1978 · S/N 17271093N1686FAdams Claude T Jr · Palmer, AKBuilt 1966 · S/N 17255081N1686MTerrastar LLC · Kalispell, MTBuilt 1971 · S/N 18501873N1686QJ3 Jets LLC · Bellaire, TXBuilt 1971 · S/N 15072986N1686YBrissel John M · El Paso, TXBuilt 1962 · S/N 17249386N1686ZBruegger Shannon B · Lance Creek, WYBuilt 1963 · S/N 1850486N1687FTigerair 2020 LLC · Newark, DES/N 17255082N1688ERegistered aircraftFirst renewal noticeBuilt 1978 · S/N 17271095N1688FSkydive Spi LLC · South Padre Island, TXBuilt 1966 · S/N 17255083N1688VAvstem Incorporated · Mc Grath, AKBuilt 1974 · S/N 17263714N1688ZMock David J · Mesa, AZS/N 1850488N1689MR D Offutt Co · Fargo, NDS/N 18264414N1689QDolphin Aviation Flyers LLC · Stuart, FLBuilt 1971 · S/N 15072989N1689ZT&R Airplane LLC · Big Lake, AKBuilt 1962 · S/N 1850489N168AERobinson Kevin B · Texarkana, TXBuilt 1963 · S/N 18255158N168EDTsg Aviation LLC · Wyandotte, MIBuilt 1975 · S/N 310R0134N168GGWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 414A0304N168MARunway Vineyards LLC · Santa Maria, CAS/N 4250155N168MSDahlen S Timothy Jr · Westhampton, NYBuilt 1963 · S/N 17250564N168RFRandigo LLC · Wilmington, DEBuilt 1989 · S/N 20800158N168SABruchid Snodgrass LLC · Reno, NVBuilt 1981 · S/N U20606073N168SDCometenterprises.Net LLC · Kalispell, MTBuilt 1979 · S/N P21000460N168WACharles Michel · St Thomas, VIBuilt 1984 · S/N 402C0808N1690FN1690f LLC · Bluffton, INBuilt 1966 · S/N 17255085N1690QAviation Visions · Fernandina Beach, FLBuilt 1971 · S/N 15072990
Back to AD 97-01-13