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.

N389RAAirtrex Aircraft Xray Inc · Wichita, KSBuilt 1986 · S/N BL-56N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313N390PMPlanemasters Ltd · West Chicago, ILBuilt 1990 · S/N UC-110N390RHAlpine Aviation Inc · Provo, UTS/N U-39N390SPState Of Arkansas · Little Rock, ARS/N BB-1970N395AMHollan Air LLC · Amarillo, TXS/N BB-1101N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421N399ALBallard Aviation Inc · Newton, KSS/N BB-1623N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2N39UBAmeriflight LLC · Dallas, TXS/N UB-39N3MHN3mh LLC · Kalispell, MTBuilt 1985 · S/N BB-1228N3NCNorth Carolina Dept Transportation · Raleigh, NCBuilt 2007 · S/N BB-1976N3PXAirtime LLC · Mont Belvieu, TXBuilt 1984 · S/N BB-1173N400GWGpw LLC · Laurel Springs, NCBuilt 1997 · S/N BB-1583N400SCN400sc LLC · Walterboro, SCBuilt 1982 · S/N BB-1040N4053HCosmos Holdings Group LLC · Newark, DEBuilt 2001 · S/N BB-1774N405PTDodson International Parts Inc · Rantoul, KSS/N BB-930N408SNUS Department Of State · Melbourne, FLS/N UE-408N410RTStewart Aviation Services LLC · Birmingham, ALBuilt 2007 · S/N BB-1978N411CCSunshine Aviation LLC · Roseburg, ORS/N BB-1520N411KCPonderosa Aviation LLC · Safford, AZBuilt 1981 · S/N BB-901N411WAGuardian Flight LLC · Lewisville, TXBuilt 1988 · S/N BB-1294N415TMCrouch Aire LLC · Westcliffe, COS/N BB-1762N416MMTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1991 · S/N BB1416N418JCsk Aviation Partners LLC · Fort Smith, ARBuilt 2000 · S/N BB-1705N418LCAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-118N4222ATenax Air LLC · Ridgeland, MSBuilt 2001 · S/N UE-422N422AXAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC-95N423EMEaglemed LLC · Wichita, KSBuilt 1987 · S/N BB-1269N424TTTja Aviation LLC · Miami, FLS/N BB-1964N425BPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N BB-1773N426SDBering Strait School District · Unalakleet, AKS/N BL-141N427GCTouch And Go Aviation LLC · Jackson, MNBuilt 1982 · S/N BB-1088N428MCRfc Aviation LLC · Laurel, MSBuilt 1997 · S/N BB-1595N4299AUas Transervices Inc · Boca Raton, FLBuilt 1971 · S/N U-146N429EMEaglemed LLC · Wichita, KSBuilt 1985 · S/N BB-1226N42FCN42fc Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1553N430DDN430dd LLC · Athens, TXBuilt 1985 · S/N BB-1243N430SN430s LLC · Mesa, AZS/N BB1080N431SCJochl Sports Inc · Banner Elk, NCBuilt 1989 · S/N BB-1337N433HCKrabby Apple Trading LLC · Wilton, CTS/N BB-1807N433JMN433jm LLC · Dallas, TXBuilt 1983 · S/N BB-1174N436EAN436ea LLC · Sanford, FLBuilt 1997 · S/N BB-1576N437WFHewitson Enterprises Inc · Avenal, CABuilt 1981 · S/N BB-962N438FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N BB-1941N442PLBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N BB-1679N444KASky Hye Air LLC · Hye, TXBuilt 1989 · S/N BB1318N444LPTri Supply LLC · Beaumont, TXS/N BB-1816
Back to AD 96-09-13