OpenAirDocs.org
AD 97-26-14

Registered aircraft · 57

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-26-14')
    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-26-14')
  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.

N107AKLazzaro Chris C · Solvang, CABuilt 1988 · S/N 4055CN141WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 4036CN159JDDorrance John Charles Jr · Randle, WABuilt 1987 · S/N 4042CN166LMFlight Rt LLC · Thonotosassa, FLS/N 4063CN1RWMcmahon Jeffrey C · Iraan, TXBuilt 1989 · S/N 4094CN202GTRenfro Michael W · Bethel, AKS/N 4111CN235FSOehmke Adam A · Camarillo, CABuilt 1988 · S/N 4052CN235GCMcdonough Joseph · Livingston, MTBuilt 2026 · S/N 24003CN245LGKnight Air LLC · Anchorage, AKBuilt 1991 · S/N 4096CN30075Prop & Paddle Aviation LLC · Brainerd, MNBuilt 1994 · S/N 4125CN3075CAinsworth Jeremy Trustee · Calistoga, CAS/N 24001CN30AGAlaskan Outdoors LLC · Soldotna, AKBuilt 1994 · S/N 4131CN355CBM S T S LLC · Moses Lake, WABuilt 1991 · S/N 4091CN359FSJohnson Air LLC · Anselmo, NEBuilt 1990 · S/N 4100CN362FSFlorida Seaplanes LLC · Altamonte Springs, FLBuilt 1989 · S/N 4071CN3952VParker Venable · Malad City, IDBuilt 1987 · S/N 4038CN4027Wiley Calvin B · Summer Shade, KYS/N 4027CN44KGSpanogle Michael M · Chugiak, AKBuilt 1989 · S/N 4074CN49MWRaviation LLC · Elk Mound, WIBuilt 1992 · S/N 4112CN56475Moertl Harald A · Anchorage, AKBuilt 1982 · S/N 7423CN5656BBryant David L · Glendale, ORBuilt 1983 · S/N 4002CN5656SAnderson Nathan A · Soldotna, AKBuilt 1984 · S/N 4006CN5657ADaily John F · Chugiak, AKBuilt 1984 · S/N 4013CN5659DBush Pilot Holdings LLC · Wasilla, AKS/N 4020CN5660YP2 Aviation LLC · Madison, MSS/N 10016CN5664YFurlong Kelly L · Athens, ALS/N 4033CN5670DWare Justin L · Texico, NMBuilt 1987 · S/N 4043CN574HBIngram Grant Leigh · Hurricane, UTBuilt 2021 · S/N 4134CN574RBGod'S Country Aviation LLC · Trapper Creek, AKBuilt 2018 · S/N 4133CN6060FKeller Matthew Charles · Wasilla, AKBuilt 1985 · S/N 4023CN6106YJanssen Jerry D · Barnesville, MNBuilt 1987 · S/N 4046CN6110CLueck Taylor W · Wasilla, AKBuilt 1987 · S/N 4049CN6128PTango Alpha Sierra LLC · Berthoud, COS/N 4057CN61294Mau Andrew R · Kenmare, NDS/N 4083CN6129TTaf Aerial Services LLC · Beeville, TXBuilt 1988 · S/N 4053CN61385Grady Will M · Gallatin, MOBuilt 1992 · S/N 4107CN61399Coody Jefferson · Burkburnett, TXS/N 4082CN700AWTailwheel LLC · Logan, UTS/N 4032-CN7235AValiair Limited Co Trustee · Casper, WYBuilt 2026 · S/N 24002CN730MWWardlaw Mack · Sonora, TXBuilt 1990 · S/N 4092CN770ASTyrrells Trails LLC · Fairbanks, AKBuilt 1984 · S/N 4017CN7UELowery Land Company LLC · Amagon, ARBuilt 1988 · S/N 4061CN86MDLol Splash LLC · Helena, MTBuilt 1988 · S/N 4050CN886ZJohn Galt LLC · Fairbanks, AKBuilt 2022 · S/N 4135CN89CWEagle Air LLC · Wasilla, AKBuilt 1989 · S/N 4087CN9176ETyrrells Trails LLC · Fairbanks, AKBuilt 1977 · S/N 7127CN9202ZRitz Mark A · Anchorage, AKBuilt 1990 · S/N 4084CN92038M7235c LLC · Boulder, COS/N 4085CN92078Goat Mountain Air LLC · Girdwood, AKS/N 4088CN9209FAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1990 · S/N 4102C
Back to AD 97-26-14