OpenAirDocs.org
AD 96-03-13

Registered aircraft · 1,042

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:96-03-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:96-03-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.

N169RWJorgensen Air Service LLC · Puyallup, WABuilt 1982 · S/N BB-1030N16CMBartholow Rental Co Inc · Wylie, TXBuilt 1997 · S/N BB-1580N16HGBear Air LLC · Mount Vernon, INBuilt 1999 · S/N BB-1647N16WGSomers-Lawson Land & Cattle LLC · Midland, TXS/N LA-226N170JCWlgb200 LLC · Reno, NVBuilt 1998 · S/N BB-1606N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28N173TX173 Tango X-Ray LLC · Houston, TXBuilt 1982 · S/N BB-1028N174JBAes Aviation LLC · Tuskegee, ALBuilt 1992 · S/N BB-1429N175RCCbp Air Logistics LLC · Statham, GABuilt 1976 · S/N BE-3N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183N176LABallard Aviation Inc · Newton, KSBuilt 1983 · S/N LA-210N176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191N177LACabeza De Vaca Holdings LLC · Carrollton, TXBuilt 1985 · S/N BB1203N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236N178LAPonca International LLC · Bentonville, ARBuilt 1982 · S/N LA-178N17EHSystem Packaging Co Inc · Bell, CABuilt 1986 · S/N BB1257N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670N17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N BB-1602N182CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N LA-121N18471Chase Air LLC · Montgomery, ALBuilt 1981 · S/N LA-161N184TXZms Aviation LLC · Wilmington, DEBuilt 1985 · S/N BB-1241N1857F56 Express LLC · Willmar, MNBuilt 1981 · S/N LA-167N185MVSouthwest Aviation Inc Div · Marshall, MNBuilt 1982 · S/N BB-1034N187MRJcs Air LLC · Auburn, ALS/N BB-873N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111N188LLTriple Aviation LLC · San Leon, TXBuilt 1981 · S/N BE-119N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32N189APRegistered aircraftBuilt 1975 · S/N BB-59N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76N18AFN220pb LLC · Mesa, AZBuilt 1994 · S/N BB-1497N18CMEdgewater Aviation LLC · Guntersville, ALFirst renewal noticeBuilt 1984 · S/N LA-219N18KATreetoppers II LLC · Newark, DEBuilt 1978 · S/N BB-360N18SFD&D Maintenance LLC · Etna Green, INBuilt 1985 · S/N LA236N190BHJourney Aviation LLC · Brookland, ARBuilt 1981 · S/N BB-907N190EBKar King LLC · Huntington, WVBuilt 2005 · S/N BB-1905N190FDOreh Aircraft LLC · New Braunfels, TXBuilt 1980 · S/N LA-42N190JPClearwater Midstream LLC · Lubbock, TXBuilt 1981 · S/N LA-158N190NCCf Holdings LLC · Hernando, MSBuilt 1982 · S/N LA193N190TTAcme Jet LLC · Dover, DEBuilt 1982 · S/N BB-1005N191WAAmeriflight 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 U152N194TRExecutive Air Taxi Corp · Bismarck, NDBuilt 1983 · S/N BB-1146N196SCChickasaw Transport LLC · Santa Rosa Beach, FLBuilt 1996 · S/N BB-1525N197WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U-130N199BCAirco King LLC · Wichita Falls, TXBuilt 1980 · S/N LA-30N199CZN199cz LLC · Milwaukee, WIBuilt 1968 · S/N U-30N199MHGsg Aviation LLC · Fort Lauderdale, FLBuilt 1981 · S/N BB-855
Back to AD 96-03-13