JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '3350' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR DALA2020051802406Battery Pack · dischargedEMERGENCY SLIDE LIGHT RIGHT SIDE DIM. REPLACED M1671 BATTERY PACK AT ROW 23. SYSTEM OPERATION IS NORMAL.SDR SIMA202005185001Battery Pack · dischargedSERVICE DOOR OVERHEAD EMERGENCY EXIT SIGN INOP-C/A-TS IAW EMB AMM 33-50-00-810-804-A EMOVED AND REPLACED POSITION 2 BACK BATTERY PACK IAW EMB AMM 33-50-04-000-802-A AND 33-50-04-400-802-A AND CHARGER ASSY IAW EMB AMM 33-50-04-000-801-A AND 33-50-04-400-801-A OSDR N6WA20200518501Light · inoperative2 CEILING EMERGENCY EXIT LIGHTS NOT WORKING. PERFORMED TROUBLE SHOT WIRING AT ROW 3 AND 4. ROW 3 LIGHTS OPS CHK IS GOOD. IAW CRJ 550 AMM 33-51-00.DEFERRED EMERGENCY FLOODLIGHT AT ROW 4 ON OPEN CONTROL # 70069268 PER MEL 33-51-01B CAT X. AUTHORIZED BY MXCSDR AALA202005189002Battery · faultedAIRCRAFT NOT GROUNDED - EPSU SYSTEM TEST, FAULT ON BATTERY 11WL. REMOVED AND REPLACED EPSU BATTERY 11WL PER AMM 33-51-38, OPERATIONAL CHECK GOOD, NO FAULTS FOUND AT THIS TIME, AIRCRAFT OKAY FOR SERVICE.SDR AALA202005189001Battery · faultedAIRCRAFT NOT GROUNDED - EPSU SYSTEM TEST, FAULT ON BATTERY 12WL. REMOVED AND REPLACED EPSU BATTERY 12WL PER AMM 33-51-38, OPERATIONAL CHECK GOOD, NO FAULTS FOUND AT THIS TIME, AIRCRAFT OKAY FOR SERVICE.SDR R61A2020051800494Battery · dischargedAFT CEILING #6 EMERGENCY LIGHT INOPERATIVE. R/R #4 EMERGENCY LIGHT BATTERY, OPS CHECK GOOD.SDR I5EA2020051500001Light · inoperativeLH OVERWING EXIT LIGHT INOPSDR WX0A2020051573503Battery · dischargedEPSU BATTERY FIN# 13WL FAILED EPSU BAT CAP TEST / REPLACED EPSU BATTERY"SDR JJBA20200515003Inverter · inoperativeEMERGENCY EXIT IDENTIFIER LIGHT, LOCATED ON LH AFT IS INOPERATIVE. R&R LH FWD EMERGENCY HATCH IDENTIFIER EMERGENCY LIGHT. OPS CHECK FAILED. R&R #5 EMERGENCY LIGHT DC/AC INVERTER. OPS CHECK SAT.SDR DALA2020051502401Cover · looseSHIP 6717 EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:604. CORRECTIVE ACTION: REINSTALLED SIGN COVER. (1558357)SDR SWAA2020052078500Battery Pack · dischargedEMERGENCY LIGHTS COMMON TO M1675 DO NOT ILLUMINATE DURING TEST SWITCH OPERATION. / REMOVED; INSTALLED; & PERFORMED A GOOD INSTALLATION TEST OF M1675 BATTERY PACK PER AMM 33-51-06-960-805SDR SWAA2020051977778Battery Pack · dischargedPASSENGER CABIN EMERGENCY LIGHTS POWERED BY M2816 BATTERY PACK ARE INOP. / REPLACED EMERGENCY LIGHTS BATTERY PACK M2816; OPS TEST GOOD IAW AMM 33-51-06-960-805 DL3333SDR SWAA2020051978087Light · inoperativeFORWARD EMERGENCY EXIT LIGHT BULB ABOVE L/H OWE IS OUT. / REMOVED; REPLACED AND PERFORMED GOOD FUNCTIONAL TEST OF FORWARD EMERGENCY EXIT LIGHT BULB ABOVE L/H OWE IAW AMM 33-51-01-960-801 STEP 2.C.(1)(A) (3) AND (2);(4).SDR SWAA2020051978086Light · inoperativeLEFT AFT ESCAPE SLIDE EMERGENCY EXIT LIGHT L732 IS OUT. / REMOVED; REPLACED AND PERFORMED GOOD FUNCTIONAL TEST OF LEFT AFT ESCAPE SLIDE EMERGENCY EXIT LIGHT BULB (L732) IAW AMM 33-51-04-960-801 STEP 2.F.(1)(A) (B);(D);(2).SDR SWAA2020051878398Light · inoperativeEMERGENCY DOME LIGHT IN COCKPIT FAILED TO COME ON. / RELAMPED BULB PER M/M 33-14-00SDR SWAA2020051878160Power Supply · inoperativeCABIN INTERIOR L/H EMERGENCY EXIT LIGHTS INOP / R&R CABIN INTERIOR OVERWING L/H EMERGENCY EXIT LIGHT POWER SUPPLY BATT PER AMM 33-51-06. OPS CHECK GOODSDR SWAA2020051877945Battery Pack · dischargedEMERGENC EXTI LIGHT ABOVE L1 DOOR; INOP / REMOVED AND REPLACED FWD LEFT EMERGENCY BATTERY PACK AND CHARGER PER AMM 33-51-06INSP 44444SDR SWAA2020051877772Battery Pack · dischargedL/H FWD OVERWING (OUTSIDE) EMERGENCY LIGHT FAILS TO ILLUMINATE / REMOVED AND REPLACED A/C EMERGENCY LIGHT BATTERY PACK AND BATTERY PACK CHARGER PER AMM 33-51-06AMT 80317SDR SWAA2020051878211Battery Pack · dischargedAFT ENTRY DOOR (L-2) EMERG. EXIT LIGHT & ROW 27 ABC OVERHEAD EMERG. EXIT LIGHT INOP / R&RED AFT L/H EMERG. EXIT LIGHT CHARGER AND BATTERY PACK IAW MM 33-51-06 OPS CK GOODSDR AALA2020051549004Module · inoperativeAIRCRAFT NOT GROUNDED. 1L EXIT LIGHT-HALF IS BURNED OUT. REPLACED EXIT SIGN LIGHTING MODULE PER AMM 33-51-17.SDR QXEA2020051500165Battery · dischargedDURING OPS CHECK OF EMERGENCY LIGHTS NOTED THAT CABIN EMERGENCY EGRESS LIGHTS IN PANELS 235CZ, 235DZ AND FWD RH EMER. EXIT DOOR ARE INOP. R/R'ED EMERGENCY LIGHT BATTERY R2 FROM ABOVE PAX CEILING PANEL 235CZ IAW Q400 AMM TASKS 33-51-01-000-801, 33-51-01-400-801SDR DALA2020051402400Battery Pack · dischargedSHIP 5656 ON S/C FOUND EMER LIGHTS INOP SEAT ROWS 27-32DEF. CORRECTIVE ACTION: REMOVED & REPLACED BATTERY PACK & CHARGER ASSY REF B757 AMM 33-51 CKS GOOD. (4268888)SDR MASA2020051410065Battery · dischargedLH O/W AFT EMER EXIT SIGN LIGHT INOP- CHARGED BATTERIESSDR MASA2020051410064Sign · damagedSV DR EXIT SIGN DMGD/LOOSE- REPLACED SIGNSDR MASA2020051410063Battery · dischargedRH O/W AFT EMER EXIT SING LIGHT INOP- CHARGED BATTERIESSDR MASA2020051410062Battery · dischargedMID CABIN CIELING FWD EXIT SIGN LT INOP- CHARGED BATTERIESSDR DALA2020051402398Cover · missing(AIRCRAFT 3140, L/P 7060694) FWD RT CLOSET RED EMERGENCY LIGHT COVER MISSING. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT ASSY. OPS CKS NORMAL.SDR SWAA2020052677801Battery Pack · dischargedALL EMERGENCY LIGHTS POWERED BY M1675 BATTERY PACK ARE INOP. REPLACED EMERGENCY LIGHT BATTERY PACK M1675 AND OPS TEST GOOD IAW AMM 33-51-06-960-805.SDR SWAA2020052677800Battery Pack · dischargedALL EMERGENCY LIGHTS POWERED BY M1673 BATTERY PACK ARE INOP. REMOVED AND REPLACED EMERGENCY EXIT LIGHTS BATTERY PACK AND POWER SUPPLY M1673. INSTALLATION TEST CHECKS GOOD. IAW AMM 33-51-06-960-806 AND AMM 33-51-06-960-805.SDR SWAA2020052077356Battery Pack · dischargedALL EMERGENCY LIGHTS IN THE FWD GALLEY AREA DO NOT ILLUMINATE. / TROUBLESHOOTING; REMOVE AND REPLACE BATTERY PACK M2816; PERFORMED OPS CK FOR ALL EMERGENCY LIGHTS IN FWD. GALLEY AREA IAW AMM 33-51-06; AND WDM 33-51-12 OPS CK GOODSDR SWAA2020051877147Battery Pack · dischargedFOWARD ENTRY DOOR EMERGENCY EXIT SIGN AND TWO FWD CA CABIN EMERGENCY LIGHTS DO NOT ILLUMINATE DURING LIGHTS TEST. / REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACK AT M1674 POWER SUPPLY IAW AMM 33-51-06. OPS NORMAL. TRACKING LEVEL 1 PART. P/N ON D712-01SDR SWAA2020051877185Battery Pack · dischargedSEVERAL EMERGENY LIGHTS INOP ON THE INSIDE OF CABIN. / REMOVED AND REPLACED FWD RH EMERGENCY LIGHT BATTERY PACK PER AMM 33-51-06.SDR SWAA2020051877199Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1669 AND M 1675. / REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES AT LOCATIONS M1669 AND M 1675 PER AMM 33-51-06SDR SWAA2020051877766Charger · inoperativeFWD EMERGENCY LIGHTS FOR L1 AND R1 DOOR INOP. / R/R BATTERY CHARGERS FOR L1 AND R1 EMERGENCY LIGHTS IAW MM 33-51-06. OPS CHECK; NO HELP. PLEASE SEE LOG PAGE 0200445E FOR CORRECTIVE ACTIONSDR SWAA2020051878881Charger · inoperativeFWD EMERGENCY LIGHTS FOR L1 AND R1 DOOR INOP. / R/R BATTERY CHARGERS FOR L1 AND R1 EMERGENCY LIGHTS IAW MM 33-51-06. OPS CHECK; NO HELP. PLEASE SEE LOG PAGE 0200445E FOR CORRECTIVE ACTIONSDR HNAA2020051800150Inverter · inoperativeL/H EMERGENCY DOOR MAIN EXIT LIGHT INOP (EXIT IDENT SIGN). REMOVED AND REPLACED EXIT IDENT SIGN IAW AMM 33-50-13. NO FIX TROUBLE SHOOT PER FAULT ISOLATION MANUAL 33-50-0-810-804-A. REMOVED AND REPLACED INVERTER #4 IAW AMM 33-50-11 OPTS CHECK GOOD.SDR CALA2020051700967Battery Pack · dischargedAISLE PATH LIGHTS FROM ROW 8 AND SEVERAL ROWS BEHIND WOULD NOT TEST. REMOVED AND REPLACED BATTERY PACK AT SEAT 8A SIDEWALL. PERFORMED OPS TEST AND VERIFIED ALL EMERGENCY EXIT LIGHTS ARE OPERATIONAL. REF AMM 33-51-06.SDR I5EA2020051500004Light · inoperativeLH FUSELAGE O/W EXIT LIGHT AND AFT INOP.SDR I5EA2020051500003Power Supply · inoperativePOWER SUPPLY NOT CHARGING AT EMERGENCY LIGHT LOCATION M1134, D2960 STA 634L.SDR I5EA2020051500002Socket · defectiveL2 LIGHT SOCKET FOR EMERGENCY LIGHT BAD.SDR AALA202005159005Light · inoperativeAIRCRAFT NOT GROUNDED. LOO FWD ENTRY DOOR EMERGENCY LIGHT ON RT OVER WING EXIT EMERGENCY LIGHT HAS NUMEROUS LIGHTS INOP. REMOVED AND REPLACED LED BAR IAW AMM 33-51-16.SDR AALA202005159004Battery · defectiveAIRCRAFT GROUNDED - EMERGENCY PATH LIGHTING, ROWS 6-12, COMES ON INTERMITTENTLY. REPLACED WBU (WELS BATTERY UNIT) AT L1 DOOR PER AMM 33-51-07, ACCOMPLISHED WBU SYSTEM RE-KEY, ALL CHECKS NORMAL.SDR IPXA2020051355260Control Panel · failedINSPECTION TYPE:N/AWHEN SWITCH IS CLOSED FOR NORMAL POSITION OF FLIGHT THE SWITCH FUNCTION GOES TO "OFF" AND THE "DISARMED" LIGHT ILLUMINATES.REMOVED AND REPLACED THE EMERGENCY LIGHTS CONTROL PANEL IAW AMM 33-51-08 OPS CHECK GOOD AT THIS TIME ESR: IPC 33-51-08SDR IPXA2020051555278Light · inoperativeINSPECTION TYPE:N/AEMERGENCY LIGHT HAS FOUR INOP BULBSRELAMPED EMERGENCT LIGHT PER AMM 33-51-01-2 FOUR BULBSSDR WX0A2020051573505Battery · dischargedEPSU BATTERY FIN# 12WL FAILED EPSU BAT CAP TEST / REPLACED EPSU BATTERY"SDR WX0A2020051573504Battery · dischargedEPSU BATTERY FIN# 12WL FAILED EPSU BAT CAP TEST / REPLACED EPSU BATTERY"SDR DALA2020051402396Battery Pack · dischargedTHE EMERGENCY LIGHTS AT EXIT ROW 25A/E, UPPER SIGNS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK. OPERATIONAL CHECK WAS NORMAL REF MD88 AMM 32-52. (LP #6984121)SDR FDEA202005130925Light · no testEMERENCY LIGHTS TEST WAS INOPERATIVE DURING PREFLIGHT. PERFORMED ADJUSTMENT AND TEST IAW MM 33-50-00-5. OPS CHECKED GOOD. ACFT OK TO CONTINUE.SDR SWAA2020051377155Battery Pack · dischargedLEFT OVERWING EXIT EMERGENCY LITES INOPERATIVE / R&R'ED BATTERY PACK FOR EMERG LITE POS M1668 PER AMM 33-51-06 P/N OFF D717-01-100 P/N ON D717-01-100SWA S/N OFF 35991 S/N ON 15558SDR SROM2020051300000Battery Pack · dischargedEMERGENCY LIGHTS ROW 14 AND 16 AIRCRAFT LEFT INOP. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK AT ROW 14 AND 16 LH IAW B737-700 AMM 33-51-00. OPS CHECK OK.
Back to JASC 3350