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 SWAA2018101425931Battery Pack · dischargedEMERGENCY LIGHT INOP AT LOCATION M1669. R&R BATTERY PACK PER AMM.SDR SWAA2018101425904Battery Pack · dischargedEMERGENCY LIGHT INOP AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR CALA2018101302086Power Supply · defectiveEPSU 11WL DEFECTIVE, MULTIPLE SEAT ROWS WILL NOT LIGHT. REMOVED EPSU 11WL IAW AMM 33-51-38-000-001-A, REMOVED BATTERY FORM EPSU 11WL IAW AMM 33-51-000-002-A, INSTALLED BATTERY ON REPLACEMENT ESPU 11WL IAW AMM 33-51-38-400-002-A AMD INSTALLED EPSU 11WL IAW AMM SDR SWAA2018101025870Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018101025853Battery Pack · failedAFT LT ENTRY EMERGENCY EXIT LIGHT FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018101025852Battery Pack · failedRT OVERWING EMERGENCY LIGHT FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018101025851Battery Pack · failedLT OVERWING EMERGENCY LIGHT FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018101025847Battery · failedR2 DOOR EMERGENCY LIGHT FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR AALA2018101109009Housing · brokenEMERGENCY LIGHT HOUSING AT ROW 14 WAS BROKEN. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR DALA2018101005962Epsu · failedDURING EPSU TEST DOOR 4 17WL FAILED. REPLACED 17WL EMERGENCY POWER SUPPLY UNIT.SDR AALA201810099014Power Supply · no testACCOMPLISHED AN EMERGENCY LIGHT TEST, TEST FAILED, ZONE 3 RIGHT SIDE UPPER AREA EMERGENCY LIGHTS ARE INOPERATIVE FROM ROW 26 TO 40. REPLACED THE POWER SUPPLY M33409 IAW MM 33-51-06. OP CHECKED NORMAL.SDR ASOA201810084063Light · inoperativeSBN - FLIGHT 2986 MAINTENANCE INSPECTIOON DISCOVERED THE NR 1 INTERIOR OVERHEAD EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED LIGHT BULB, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURNSDR UIEA2018101102244Battery Pack · dischargedEMERGENCY LIGHTS FAIL OPS CHECK. REMOVED AND REPLACED NEW BATTERY PACK IAW AMM 33-51-07. PERFORMED SATISFACTORY OPS CHECK IAW AMM 33-51-07 STEP E.SDR HNAA2018101100251Light · not seatedSERVICE DOOR EMERGENCY LIGHT WILL NOT ILLUMINATE. RESEATED BULB IN SOCKET IN REF TO AMM TASK 33-50-10-400-801-A.SDR HNAA2018101100250Light · not seatedLT WING UPPER EMERGENCY LIGHT WILL NOT ILLUMINATE. RESEATED BULB IN SOCKET IN REF TO AMM 33-50-10-400-801-A. OPS CHECK GOOD.SDR SWAA2018101025869Sign · missingCENTER AISLE OVERWING EMERGENCY EXIT SIGN MISSING. SECURED SIGN PER SIP.SDR SWAA2018101025846Light · inoperativeL2 DOOR OVERHEAD EMERGENCY LIGHT BULB INOP. R&R BULB PER AMM.SDR SWAA2018101025845Lens · faultyRT OVER WING ESCAPE HATCH THRESHOLD EMERGENCY EXIT LIGHT LENS FAULTY. R&R LENS PER AMM.SDR SWAA2018101025844Lens · faultyLT OVER WING ESCAPE HATCH THRESHOLD EMERGENCY EXIT LIGHT LENS FAULTY. R&R LENS PER AMM.SDR AALA201810109007Light · inoperativeR2 DOOR LOWER PORTION EXIT LIGHTS INOPERATIVE. REPLACED THE WALL-MOUNTED EMERGENCY LIGHT IAW AMM 33-51-19. TESTED OK.SDR MYWA2019F00084Battery Pack · dischargedFORWARD LEFT CABIN EMERGENCY EXIT LIGHTS INOPERATIVE. BATTERY PACK REPLACED. REF LP 260660-5.SDR AALA2018101099003Battery · inoperativeR2 AREA FLASHLIGHT NOT BLINKING. REPLACED THE BATTERY IAW 25-60-00.SDR AALA201810108001Battery Pack · no testDURING A PS CHECK, THE LEFT FORWARD AISLE EXIT LIGHT WILL NOT ILLUMINATE. REPLACED THE POWER SUPPLY BATTERY PACK M33093.SDR AALA201810099019Light · missingAIRCRAFT WAS NOT GROUNDED. LEFT AFT CABIN ENTRY DOOR EXIT LIGHT MISSING. MAINTENANCE REPLACED LIGHT ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01.SDR QXEA2018100800361Light · inoperativeF/A EMERGENCY LIGHT SWITCH DOES NOT ILLUMINATE. REMOVED FROM SERVICE. RELAMPED LIGHT SWITCH. CHECKS GOOD. RETURNED TO SERVICE.SDR IPXA2018100834795Power Supply · failedEMERGENCY LIGHT BATTERY LOW LEVEL ONE DURING AN EMERGENCY LIGHT TEST. PERFORMED FIM 33-51-00-810-801, FIG 104, BLK 1, 2, AND 6. REPLACED THE NR 1 EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-01,401. OPS TESTED NORMAL. OK FOR SERVICE.SDR SIMA20181008001Charger · failedAFT EMERGENCY LIGHT (EXIT) WILL NOT SHUT OFF. -C/A-REMOVED AND REPLACED NR 3 EMERGENCY LIGHT CHARGER/CRADLE ASSY IAW AMM 33-51-07; OPS CHECK GOOD.SDR CALA2018100802080Light · inoperativeRT WING OVER EXIT LIGHT INOP. REPLAMPED REF AMM 33-51-04-960-801. OPS CHECKED OK. CHECKED OPERATION REF AMM33-51-04SDR CALA2018100802079Light · inoperativeL2 DOOR, EXTERIOR EMERGENCY EGRESS LIGHT INOP. SDR RELAMPED, NO HELP. OK FOR DAYLIGHT OPS ONLY PER MEL 3314A DISPATCH DESK: 24 DATE: 02-OCT-18- NOC DESK: 900 DATE: 02-OCT-18- TOMC APPROVED LIGHT INOP AT L-2 DOOR ( NO NIGHT OPS ) DEFERED PER MEL 3314A RELAMPED SDR CALA2018100802078Light · inoperativeSEAT 15 ABC RED EPL INOP. RELAMPED REF AMM 33-51-11-960-801 OPS CHECKED OK. CHECKED OPERATION REF AMM 33-51-11SDR CALA2018100802077Light · inoperativeAT DOOR 1L EEL SIGN NEXT TO FLIGHT ATTEN SEAT LAMPS INOP. RELAMPED REF AMM 33-51-01-960-801 OPS CHECKED OK. CHECKED OPERATION REF AMM33-51-01SDR CALA2018100802075Sign · brokenREF NR L/P:9462280 - EA 3351-01180 OP01 REV A - DOOR RT NR 1 EXIT IDENTIFIER BASE FND BROKEN. DOOR RT NR 1 FWD EXIT IDENTIFIER REPLACED AND OPERATIONAL TEST FOUND NORMAL AS PER AMM 33-51-01-960-801 REV83.SDR CALA2018100802074Light · inoperativeCEILING EMERGENCY LIGHTS INOP AT POSITIONS: ROW 41L, 1R, AND FROM ROW 17R THRU 29R. REF. N/R:99823861 RELAMPED CEILING EMERGENCY LIGHTS AT POSITIONS ROW 41 L AND 1 R. SECURED CONNECTOR D1126 ON PWR SUPPLY M732. PERFORMED TEST CHECKED NORMAL AT POSITIONS ROW 41SDR CALA2018100802073Indicator · not reportedREF NR L/P:9459727 - DOOR LT NR 1 AFT, LT NR 4 AFT EXIT INDICATOR REPLACED AND OPERATIONAL TEST FOUND NORMAL AS PER AMM 33-51-01- 960-801 REV83. DOOR LT NR 1 AFT, LT NR 4 AFT EXIT INDICATOR REPLACED AND OPERATIONAL TEST FOUND NORMAL AS PER AMM 33-51-01-960-801SDR CALA2018100802071Fuse · blownREF NR L/P:9458096 - SPEC NR B777-33-7-7019 - C ZONE RT AFT CEILING AREA EMERGENCY LIGHT POWER PACK FOUND LOW CAPACITY. DOOR RT 4 BATTERY M33409 REPLACED AND F4 FUSE REPLACED, C/O EMERGENCY LT TEST, THE RESULT FOUND NORMAL AS PER AMM 33-51-06- 960-802 REV.83.SDR DALA2018100806009Battery Pack · dischargedEMERGENCY LIGHTS FORWARD OF R4 DOOR IS INOPERATIVE. REPLACED BATTERY PACK M734 SYSTEM OPERATION IS NORMAL.SDR DALA2018100905999Epsu · not reportedEPSU CENTER POSITION IN PASSENGER CABIN. REPLACED EMERGENCY POWER SUPPLY UNIT. OPERATION CHECKS GOOD.SDR DALA2018100905998Epsu · malfunctionedCIDS MESSAGE 33-51-38. REMOVED AND REPLACED EPSU AND DEU.SDR HNAA2018101100247Light · inoperativeMAIN ENTRY DOOR HINGE COVER EMERGENCY LIGHT DOES NOT ILLUMINATE. R&R BULB IAW AMM 33-50-10-000/400-801-A. OPS CHECK GOOD.SDR SWAA2018101025873Battery Pack · dischargedLT EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018101025872Battery Pack · dischargedLT BIN EMERGENCY EXIT LIGHT INOP AT ROW 6. R&R BATTERY PACK PER AMM.SDR SWAA2018101025868Battery Pack · dischargedLT OVERWING EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR AALA2018101099015Connector · looseFLOOR EMERGENCY LIGHTS INOPERATIVE. FOUND THE CONNECTOR D633P LOOSE. CONNECTED THE CONNECTOR AND ACCOMPLISHED AN EMERGENCY LIGHT TEST IAW AMM 33-51-00, FOUND OK.SDR SWAA2018100925781Lens · looseLT EMERGENCY EXIT HATCH SIGN LOOSE. SECURED LENS IAW AMM.SDR SIMA201810087006Charger · failedSUPPLEMENTAL BOTH AFT OVERWING EMERGENCY LIGHTS INOP. -C/A-DEFERRED PER MEL 33-29. REMOVED AND REPLACED BATTERY CHARGE ASSY PER W/C 33-700-19 NO FIX . REMOVED AND REPLACED NR 4 BATTERY CHARGER IAW AMM 33-50-04 OPS CHECK GOOD. MEL ITEM RESTORED. BATTERY CHARGERSDR DALA2018100805928Bracket · detectedEMERGENCY FLOOR LIGHTING 15C DETACHED FROM FRAME, SECURED LIGHT BRACKET TO SEAT.SDR SIMA201810087004Light · inoperativeFLOOR ILLUMINATION STRIP INOP 1A-C/A-REMOVED AND REPLACED FLOOR ILLUMINATION STRIP AT SEAT 1A IAW AMM 33-50-21.SDR AALA201810089016Light · detachedFLOOR EMERGENCY EXIT LIGHT AT SEAT 9D WAS DETACHED. SECURED THE LIGHT. OPS CHECKED GOOD.SDR CALA2018100802066Light · inoperativeSUPPORT TASK - EMERGENCY LIGHTS INOP ON BULLNOSE AT ROWS 3, 25, 31, 34 RT AND 17, 33 LT. REF NR 99824640. ITEM WAS ACCOMPLISHED ON 44.0008 SEE ATTACHED COPY. REF NR 9 9824640. INSPECTION PERFORMED.SDR CALA2018100802065Battery · dischargedREF NR L/P:9462408 - SPEC NR B777-33-7-7019 - ZONE C FWD RT EMER AREA LIGHT WAS NOT ON WHEN EMERGENCY LIGHT TESTED. DOOR RT 3 BATTERY M33401 REPLACED AND OPERAIONAL TEST FOUND NORMAL AS PER AMM 33-51-06-960-802 REV83.
Back to JASC 3350