AD 96-09-13

Registered aircraft · 772

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-09-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-09-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.

N169GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-169N169RWJorgensen 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-1647N170GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-170N170JCWlgb200 LLC · Reno, NVBuilt 1998 · S/N BB-1606N171CJBering Air Inc · Nome, AKBuilt 1993 · S/N UE-71N172EEBemidji Aviation Services Inc · Bemidji, MNBuilt 1981 · S/N U-172N172GAAlpine Aviation Inc · Provo, UTS/N UB-11N173TX173 Tango X-Ray LLC · Houston, TXBuilt 1982 · S/N BB-1028N174AVUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-174N174JBAes Aviation LLC · Tuskegee, ALBuilt 1992 · S/N BB-1429N175EEBemidji Aviation Services Inc · Bemidji, MNBuilt 1981 · S/N U-175N176YVHill Air Executive Inc · Fort Pierce, FLBuilt 1995 · S/N UE-176N177LACabeza De Vaca Holdings LLC · Carrollton, TXBuilt 1985 · S/N BB1203N178YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-178N17EHSystem Packaging Co Inc · Bell, CABuilt 1986 · S/N BB1257N17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N BB-1602N184TXZms Aviation LLC · Wilmington, DEBuilt 1985 · S/N BB-1241N184UXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-184N185MVSouthwest Aviation Inc Div · Marshall, MNBuilt 1982 · S/N BB-1034N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76N18AFN220pb LLC · Mesa, AZBuilt 1994 · S/N BB-1497N1902DBoeing Co · Berkeley, MOBuilt 1998 · S/N UE327N190AWCsi 135 Division LLC · Albuquerque, NMBuilt 1999 · S/N UE-382N190BHJourney Aviation LLC · Brookland, ARBuilt 1981 · S/N BB-907N190EBKar King LLC · Huntington, WVBuilt 2005 · S/N BB-1905N190GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-1N190PMPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB66N190TTAcme Jet LLC · Dover, DEBuilt 1982 · S/N BB-1005N190WAAmeriflight LLC · Dallas, TXBuilt 1983 · S/N U-207N191AVUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-191N191AWCsi 135 Division LLC · Albuquerque, NMBuilt 1996 · S/N UE-251N191CSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N UE-392N191CZPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB-59N191WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U136N1924TUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-115N192GAAlpine Aviation Inc · Provo, UTS/N UB-17N192WAAmeriflight LLC · Dallas, TXBuilt 1973 · S/N U152N193CZPlanemasters Ltd · West Chicago, ILBuilt 1989 · S/N UC-73N193SUUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U193N194GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-8N194TRExecutive Air Taxi Corp · Bismarck, NDBuilt 1983 · S/N BB-1146N195AWCsi 135 Division LLC · Albuquerque, NMBuilt 1993 · S/N UE-128N195GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-195N196SCChickasaw Transport LLC · Santa Rosa Beach, FLBuilt 1996 · S/N BB-1525N196WAAmeriflight LLC · Dallas, TXBuilt 1981 · S/N U-179N197GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-16N197WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U-130N198AWCsi Aviation Inc · Albuquerque, NMBuilt 1997 · S/N UE293
Back to AD 96-09-13