AD 97-01-12

Registered aircraft · 489

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-12')
    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-12')
  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.

N168WSPantechnicon Aviation Ltd · Minden, NVBuilt 1946 · S/N J-5N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183N175SWDenaina Air Taxi LLC · Anchorage, AKBuilt 1985 · S/N AC 621-BN176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670N17VVPro Field Services Inc · Hallettsville, TXBuilt 1985 · S/N TT536N181RK330 Am Holding Corp · Miami, FLBuilt 1991 · S/N 515N183AKRegistered aircraftBuilt 1981 · S/N TT471N184SWCbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-647N187MRJcs Air LLC · Auburn, ALS/N BB-873N1888TGood Aviation LLC · Oshkosh, WIBuilt 1947 · S/N J31N188ACTanglefoot Wing And Wheel Co · Coolin, IDBuilt 1951 · S/N J57N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32N189APRegistered aircraftBuilt 1975 · S/N BB-59N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76N18KATreetoppers II LLC · Newark, DEBuilt 1978 · S/N BB-360N191WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U136N1924TUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-115N1926A1926a LLC · Auburn, ALBuilt 1981 · S/N BB-922N192WAAmeriflight LLC · Dallas, TXBuilt 1973 · S/N U152N197WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U-130N199CZN199cz LLC · Milwaukee, WIBuilt 1968 · S/N U-30N1HXCentralav LLC · Lake Worth, FLBuilt 1978 · S/N BB-361N1MNDukes Garage LLC · Boulder, COBuilt 1981 · S/N TT-486AN200BTMid-South Regional Aviation LLC · Tunica, MSBuilt 1977 · S/N BB-293N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410N200SNAdvantage Jet Holdings LLC · Chino Hills, CABuilt 1980 · S/N T-354N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680N202WSCorsair Turbines LLC · Georgetown, TXBuilt 1975 · S/N AT037N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827N211RHMcneely Charter Service Inc · West Memphis, ARBuilt 1987 · S/N AC421BN213PHPyro Shows Equipment LLC · La Follette, TNBuilt 1979 · S/N BB-486N217CMKlas-Kcoe LLC · Las Vegas, NVBuilt 1980 · S/N BB-621N217MLDodson Intl Parts Inc · Rantoul, KSS/N BB739N21DELocke-Lane Aviation LLC · Statesville, NCBuilt 1976 · S/N BB-117N21FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N BB-839N21GPKolob Canyons Air Services Inc · Wilmington, DEBuilt 1989 · S/N AC754BN220TTShannair LLC · Saint Louis, MOS/N BB-462
Back to AD 97-01-12