OpenAirDocs.org
AD 97-24-06

Registered aircraft · 54

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-24-06')
    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-24-06')
  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.

N1055WMidwestern Soaring Association · Peculiar, MOBuilt 1971 · S/N 229N1059DRafferty Michael J · Santa Monica, CABuilt 1972 · S/N 334N105MAckley Richard F · Clearville, PABuilt 1970 · S/N 127N105SHolden Daniel N · Anacortes, WABuilt 1970 · S/N 118N1106BWillat Garret · Warner Springs, CAS/N 68N111CRCramer Warren C · Horseheads, NYBuilt 1971 · S/N 183N11RDHolmes Alonso P · Broomfield, COBuilt 1969 · S/N 74N123EWMadigan Gregory J · Fort Montgomery, NYBuilt 1972 · S/N 308N12RUAlbuquerque Soaring Club · Albuquerque, NMBuilt 1971 · S/N 208N1355Knerr Joshua D · Tehachapi, CABuilt 1968 · S/N 27N1599Willamett Valley Soaring Club · Cornelius, ORBuilt 1968 · S/N 24N1699Lowry Steven D · Waialua, HIBuilt 1969 · S/N 33N1894Reusch David C · Seattle, WAS/N 30N194PBauman Jennifer · Tehachapi, CABuilt 1971 · S/N 217N1971SAuburg George R · Midland, TXBuilt 1970 · S/N 105N1XEDiaz Allison Violette · Stephens City, VABuilt 1973 · S/N 409N21PTGary Oswald Lee · Post Falls, IDBuilt 1971 · S/N 190N221ERensel Daniel J · Ashville, NYBuilt 1970 · S/N 123N230GWahl John F · Edgewood, NMBuilt 1970 · S/N 132N2349Hite Douglas T · Frisco, TXBuilt 1969 · S/N 58N2509Bjork Richard J · Brackettville, TXBuilt 1971 · S/N 213N2578Davis Clinton B · Bakersfield, CABuilt 1970 · S/N 161N2677Tobin Scott R Jr · Port Orange, FLBuilt 1969 · S/N 32N2926Martucci Dennis J · Monroe, GAS/N 84N2972Macveigh John D · Thomasville, PABuilt 1972 · S/N 282N3019Davies Harry Francis · California, MDBuilt 1969 · S/N 44N3226Qt Solutions LLC · Wilmington, DEBuilt 1971 · S/N 212N3708FEklund Don C II · Yorba Linda, CABuilt 1970 · S/N 181N3841Williams Jon M · Oviedo, FLBuilt 1968 · S/N 29N3964Kenney Paul S · Winter Springs, FLS/N 187N3992Bird John J · El Paso, TXBuilt 1971 · S/N 219N41FLKuntz David W · Albuquerque, NMS/N 292N4362Sigler Robert E · Round Rock, TXBuilt 1971 · S/N 216N44AAProkes Michael C · Phoenix, AZBuilt 1970 · S/N 126N44BTWelsh Christopher R · Cresson, TXBuilt 1971 · S/N 200N4947Treasure Coast Soaring Club Inc · Port Saint Lucie, FLBuilt 1970 · S/N 170N5567Flesberg Allan J · Olathe, KSBuilt 1972 · S/N 317N6152Ashmore Paul A · Sioux Falls, SDBuilt 1970 · S/N 121N623NXWahl John F · Edgewood, NMBuilt 1970 · S/N 106N6512Badal Gerardo A · Eastsound, WABuilt 1969 · S/N 63N66WFWahl John F · Edgewood, NMBuilt 1970 · S/N 97N695Wilburn Michael R · Wagoner, OKBuilt 1971 · S/N 191N69HLRenwick John K · Minneapolis, MNBuilt 1970 · S/N 122N7213Faris Kenneth James · Ithaca, NYBuilt 1968 · S/N 25N727RAAndrew Ross · Woods Cross, UTBuilt 1970 · S/N 159N758WELeonard Steven E · Wichita, KSBuilt 1969 · S/N 81N761HSoaring Thunderbirds Inc · Canton, OHBuilt 1971 · S/N 249N8041DLozier Kurt T · Albany, NYS/N 440N810VEIngs Deborah Lynn · Centennial, COS/N 248N8990Hart Brian D · Washougal, WABuilt 1968 · S/N 9
Back to AD 97-24-06