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.

N3HBSunset Aviation LLC · Port Angeles, WABuilt 1979 · S/N BB-453N3MEAero F90 LLC · Oxnard, CABuilt 1980 · S/N LA-101N3MFJ & K Aviation Inc · Conway, ARBuilt 1983 · S/N LA209N3MHN3mh 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-1040N400SLTurbo Air Charter LLC · Boise, IDBuilt 1980 · S/N BB-697N4047CInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N BB202N404DPValie Air LLC · Statesboro, GABuilt 1981 · S/N BB-819N4053HCosmos Holdings Group LLC · Newark, DEBuilt 2001 · S/N BB-1774N405PTDodson International Parts Inc · Rantoul, KSS/N BB-930N409RATurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N BB-429N40RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BC-7N40SBSan Bernadino County Sheriffs Office · San Bernardino, CABuilt 1976 · S/N BD-09N40YDynamic Avlease Inc · Bridgewater, VABuilt 1982 · S/N BP-30N410RTStewart 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-901N411MHObair 26 LLC · Memphis, TNBuilt 1979 · S/N BB-566N411WAGuardian Flight LLC · Lewisville, TXBuilt 1988 · S/N BB-1294N414RTPremier Aviation LLC · Philadelphia, MSBuilt 1981 · S/N LA-110N415TMCrouch Aire LLC · Westcliffe, COS/N BB-1762N416DFUsda Forest Service · Mcclellan, CABuilt 1985 · S/N BL-124N416MMTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1991 · S/N BB1416N416PMetro Aviation Inc · Shreveport, LABuilt 1980 · S/N LA-67N418JCsk Aviation Partners LLC · Fort Smith, ARBuilt 2000 · S/N BB-1705N419MNSouthern Justice Aviation LLC · Houston, TXBuilt 1980 · S/N BB-785N41AKSubstation Air LLC · Midvale, UTBuilt 1982 · S/N LA-188N420TAElectronic Caregiver Inc · Las Cruces, NMBuilt 1978 · S/N BB-420N423EMEaglemed LLC · Wichita, KSBuilt 1987 · S/N BB-1269N424CPDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N LA-182N424TTTja 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-146N429DMPayne Mark · Spring, TXBuilt 1981 · S/N LA-102N429EMEaglemed LLC · Wichita, KSBuilt 1985 · S/N BB-1226N42FCN42fc Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1553N42JCrania Holdings LLC · Peoria, ILBuilt 1977 · S/N BC-29N42ZDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1976 · S/N BC28N430DDN430dd LLC · Athens, TXBuilt 1985 · S/N BB-1243N430MCDenault John B III · Fullerton, CABuilt 1981 · S/N BB-904N430SN430s LLC · Mesa, AZS/N BB1080N431RCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B-71N431SCJochl Sports Inc · Banner Elk, NCBuilt 1989 · S/N BB-1337N431ZTZimin Transportation LLC · South Naknek, AKBuilt 1976 · S/N BC-18
Back to AD 96-03-13