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.

N228TMMacs Seaplane Service LLC · Milan, INS/N 17270902N228WBSnell Jeffrey D · Inver Grove, MNBuilt 1974 · S/N 17263032N228ZFFandrich Edward I · Payson, AZS/N 18502461N22900Swanton Jed M · Shawnee, KSBuilt 1968 · S/N 15068601N22902Easterling William R · Pikeville, NCBuilt 1968 · S/N 15068603N22903Walther Newell A · Wasilla, AKBuilt 1968 · S/N 15068604N22905Yokota Flight Training Center · Apo, APBuilt 1974 · S/N 17264078N2290GHooker John L · Iowa Park, TXBuilt 1958 · S/N 51590N2290SElco Avion LLC · Eagle Lake, TXBuilt 1976 · S/N 21061233N2290XMatthews Roy E · Sparta, MIBuilt 1965 · S/N 337-0190N2290YHerren Roger L · Clayton, ILBuilt 1967 · S/N 17700090N22915Sprankle Gerard · Fairbanks, AKS/N 15068613N22919Brozzo Ralph · St Johns, FLBuilt 1968 · S/N 15068614N2291EDv Aviation Inc · Brainerd, MNBuilt 1978 · S/N 17271224N2291YWyatt Gary D · Sun City West, AZBuilt 1967 · S/N 17700091N22920Jackson Kenneth R · Stephenville, TXS/N 15068615N22921Sakry Robert J · Saint Joseph, MNBuilt 1968 · S/N 15068616N22924Hirkala Ronald R · Weirton, WVBuilt 1968 · S/N 15068618N22926Gossett Rita M · Granbury, TXBuilt 1968 · S/N 15068619N22927Hamilton Gregory J · Avon Lake, OHBuilt 1968 · S/N 15068620N2292CKlein John T · Austin, ARBuilt 1953 · S/N 30592N2292GNelson Erik · Exeter, NHBuilt 1958 · S/N 51592N2292YJess Lawrence A · Menomonie, WIBuilt 1967 · S/N 17700092N22935Tift Aviation LLC · Tifton, GABuilt 1968 · S/N 15068627N2293FTwo Mile High Mining LLC · Victor, COBuilt 1970 · S/N 414-0097N2293GEischen Kent A · Smoot, WYBuilt 1958 · S/N 51593N2293JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803449TN2294CHitch Dixon S · Malta, MTBuilt 1953 · S/N 30594N2294GHenderson Ramsey H · Pittsboro, NCBuilt 1958 · S/N 51594N2294RSeeliger Jeremy E · Pasco, WABuilt 1978 · S/N R18200584N2294XCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1965 · S/N 337-0194N2294YHeathfield William T · Plymouth, MIFirst renewal noticeS/N 17700094N22956Thyfault Raymond E · Mattawan, MIS/N 15068643N2295JPloyhart Edwin J · Harwood, NDBuilt 1966 · S/N 15065495N2295WBraswell Jerrold W · Dillingham, AKBuilt 1978 · S/N 20700448N2295YHutto Azel James III · Lexington, SCBuilt 1967 · S/N 17700095N22963Swift John S · Santa Barbara, CAS/N 15068646N22964Straight Flight Aviation LLC · Goliad, TXS/N 17264079N2296TRegistered aircraftS/N R18200021N22970Kingdom Air Corps · Sutton, AKBuilt 1968 · S/N 15068651N2297SRocketjet LLC · Incline Village, NVS/N R18201328N2297YKomulainen Daryl B · Clarksville, TNBuilt 1967 · S/N 17700097N22980Salt City Aviation LLC · Hutchinson, KSBuilt 1968 · S/N 15068656N22988Runyon James R · Entiat, WABuilt 1968 · S/N 15068664N2298GPerkins Larry L · Wildomar, CAS/N 51598N2298JRoth Mark E · Stevensville, MTBuilt 1966 · S/N 15065498N2298TT C Rocket LLC · Traverse City, MIBuilt 1977 · S/N R18200023N22990Peterson Curtis L · Smith Center, KSBuilt 1968 · S/N 15068665N22991Dan Munson Consulting Pllc · Seneca, SCBuilt 1968 · S/N 15068666N22998N22998 LLC · Middletown, DES/N 15068670
Back to AD 97-01-13