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 SWAA2020010740239Power Supply · inoperativeL/H AFTER WING EMERGENCY ESCAPE LIGHT INOP. / R&R POWER SUPPLY PER AMM.SDR SWAA2020010740238Battery Pack · dischargedR/H AFTER WING EMERGENCY ESCAPE LIGHT INOP. / R&R BATTERY PACK PER AMM.SDR SWAA2020010740237Light · inoperativeL2 DOOR EXTERIOR EMERGENCY ESCAPE SLIDE LIGHT INOP. / RELAMPED LIGHT IAW AMM.SDR SWAA2020010740201Battery Pack · dischargedL/H AFTER WING EMERGENCY ESCAPE LIGHT INOP. / R&R BATTERY PACK PER AMM.SDR SWAA2020010740200Light · inoperativeL1 DOOR EXTERIOR EMERGENCY ESCAPE SLIDE LIGHT INOP. / RELAMPED LIGHT IAW AMM.SDR CALA2020010600071Battery · discharged''B'' ZONE R/H AFT CEILING AREA EMERGENCY LT BATT LOW CAPACITY, RE FER NON-ROUTINE NO.9498135, ORIGINATED BY EMP, SPEC NO.B 777-33-3-7019. PERFORMED BY EMP, ''B'' ZONE R/H AFT CEILING AREA EMERGENC Y BATTERY (M334047) REPLACED & SYSTEM TEST CARRIED OUT FOUND 'SDR CALA2020010600070Battery · discharged''B'' ZONE L/H FWD CEILING AREA EMERGENCY LT BATT LOW CAPACITY, RE FER NON-ROUTINE NO.9497961, ORIGINATED, SPEC NO.B 777-33-3-7019. PERFORMED BY EMP, ''B'' ZONE L/H FWD CEILING AREA EMERGENC Y LT BATTERY (M33099) REPLACED, SYSTEM OPERATION TEST CARRIED OU T FOSDR REXA2020010321001Housing · damagedLH OVERWING EMERGENCY LIGHT UNDER SECOND EMERG DOOR INOP
DEFERED OVERWING LIGHT IAW MEL 33-51-2C CAT C OCN 3618410-2 PLACARDED IAW MEL UPDATED MM02 MXC NOTIFIED MXC 101589 --- RECLASSIFIED TO MEL 33-51-2A. PLACARD AND MMO2 UPDATED. (LT AFT EXTERIOR EMERGENSDR DALA2020010300031Light · inoperative(AIRCRAFT 5814, L/P 6697856) EXT EMERGENCY LT DAY OPS INOP. CORRECTIVE ACTION: RELAMPED RT AFT O/W LIGHT PER B757 AMM 33-51.SDR DALA2020010300030Cover · loose(AIRCRAFT 5803, L/P 1424850) EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS: 3R / INTERIOR. CORRECTIVE ACTION: RESECURED EXIT SIGN.SDR ASAA2020010231755Sign · brokenMID CABIN LEFT EMERGENCY EXIT AFT PORTION OF SIGN MISSING. GROUNDED - YES. RELPACED MID CABIN LEFT EMERGENCY EXIT SIGN.SDR IPXA2020010250535Light · inoperativeINSPECTION TYPE:N/AEMERGENCY LIGHT AUTO TEST FUNCTION IS INOP, WILL NOT COMPLETE TEST, ALL LIGHTS AND MANUAL AND AUTO CONTROLS FUNCTIONS NORMAL. DEFERRED COURIER KUPERNUMERARY AREA INTERIOR EMERGENCY LIGHT -TEST FUNCTION, IAW MEL 33-51-05-2 ACCOMPLISHED DMP 33SDR SIMA2020010231003Lamp · inoperativeLH AFT OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH AFT OVERWING EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD.SDR SIMA2020010231002Light · inoperative12B/C OVERHEAD EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED 12B/C OVERHEAD EMERGENCY LIGHT IAW EMB AMM 33-50-08-000-801-A AND 33-50-08-400-801-A. OPC GOOD.SDR SWAA2020010240122Battery Pack · dischargedFORWARD R/H STOWBIN EMERGENCY AISLE LIGHT INOP. / R&R BATTERY PACK IAW AMM.SDR SWAA2020010240104Lens · brokenAFT R/H EMERGENCY EXIT LENS BROKEN OFF. / R&R SIGN ASSEMBLY PER MM.SDR SWAA2020010240100Light · inoperativeL2 DOOR EXTERNAL EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR QXEA2019123100486Light · looseFLOOR LIGHT IN FRONT ON SEAT 1B CAME LOOSE. REMOVED FROM SERVICE. RE SECURED FLOOR LIGHT IN FRONT OF SEAT 1B AS REQUIRED. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR SWAA2019123140082Lens · missingMID CABIN OVERHEAD EXIT SIGN MISSING AFT PLASTIC PLATE. INSTALLED THE LENS IAW AMM.SDR XMXR20201118007Battery Pack · failedEMERGENCY LIGHTS FLICKERING. REPLACED EMERGENCY LIGHTS BATTERY PACKSDR XMXR20201118005Battery Pack · failedEMERGENCY LIGHTS FLICKERING. REPLACED EMERGENCY LIGHTS NR 2 AFT BATTERY PACK.SDR XMXR20201118004Battery Pack · failedEMERGENCY LIGHTS FLICKERING. REPLACED EMERGENCY LIGHTS NR 2 AFT BATTERY PACK.SDR JJBA202001310011Light · damaged253CLC FWD EMERGENCY EXIT LIGHT INCORRECTLY ATTACHED AND CRACKED. REMOVED AND REPLACED EXIT SIGN ON 253CLC.SDR R61A202001080026Sign · dim***WHILE A/C WAS OUT OF SERVICE FOR HEAVY CHECK***AT L1 DOOR EMERGENCY LIGHT EXIT IDENTIFIER DOESN'T ILUMINATE COMPLETELY. R&R EMERGENCY LIGHT EXIT IDENTIFIER IAW AMM 33-50-15-400-801-A. A/C REMAINS OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR AALA2020010329014Light · inoperativeAIRCRAFT WAS GROUNDED: R1 EXTERIOR EMERGENCY LIGHT WAS INOPERABLE. MAINTENANCE RELAMPED LIGHT PER AMM 33-51-00.SDR AALA2020010329012Light · inoperativeAIRCRAFT WAS NOT GROUNDED: L4 EXTERIOR SLIDE LIGHT INOPERABLE. MAINTENANCE RELAMPED SLIDE LIGHT PER MM 33-51-06.SDR AALA2020010319033Light · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED L2 DOOR EXTERIOR EMERGENCY LIGHT PER AMM 33-51-06.SDR AALA2020010319032Light · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED L1 DOOR EXTERIOR EMERGENCY LIGHT PER AMM 33-51-06.SDR P5CA2020010300002Sign · unsecureEXIT SIGN FELL OFF NEAR L1 DOOR.(<P>RESECURED EXIT SIGN NEAR L1 DOOR IAW AMM 33-51-01.<BR /></P>)SDR SWAA2020010340102Light · inoperativeCAPTAIN EMERGENCY EXIT LIGHT INOP. / RELAMPED LIGHT PER MM.SDR DALA2020010207675Socket · dirty(AIRCRAFT 696, L/P 6439630) $R EMERGENCY SLIDE ILLUMINATION LIGHT WILL NOT ILLUMINATE. CORRECTIVE ACTION: CLEANED SOCKET CONTACT AND INSTALLED NEW BULB.SDR SIMA2020010230004Lamp · inoperative12C OVERHEAD EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED 12C OVERHEAD EMERGENCY LIGHT LAMP IAW EMB AM AND 33-50-08-400-801-A. OPC GOOD.SDR MASA201912312212Bulb · inoperative14DF EMERGENCY EXIT SIGN 2 BULBS INOPERATIVE.SDR ASAA20191231734Lens · detachedCENTER AISLE EXIT SIGN AT 16 ROW FELL OFF. GROUNDED - YES. REINSTALLED PLASTIC EMERGENCY EXIT SIGN COVER - NO OTHER DEFECTS NOTED. LIGHT OPS NORMAL.SDR AALA201912319019Battery Pack · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS O/H BIN SEAT 33C AND 37C EMERGENCY BULLNOSE LIGHT INOP. DOOR 1R EXIT IDENTIFIER INOP. OVERHEAD BIN SEAT 1C EMERGENCY BULLNOSE LIGHT INOP. OVERHEAD BIN SEAT 3C EMERGENCY BULLNOSE LIGHT INOP. REMOVED AND REPLACED BATTESDR HALA2019123107653Light · unknownDOOR 1L AND R1 EMERGENCY EXIT LIGHTS ARE ON IN OFF POSITION. CYCLED EMERGENCY LIGHT SWITCH. OPERATIONAL CHECK OK. LP 7236993SDR DALA20200107705Bulb · inoperativeCREW REST EXIT SIGN AT LADDER AND COMMON AREA INOPERATIVE. FOUND ALL 24 BULBS BURNTOUT RELAMPED SAMESDR CALA2020010600060Battery Pack · dischargedB777-33-3-7019: R/H #4 DOOR EMER LT POWER SUPPLY(M33409) DEEP CYCLE CHECK FAIL.REF NR LP 9130215 L/H DOOR 3 EMER LT POWER SUPPLY BATTERY PACK REPLACED AND OP TEST CARRIED OUT WITH NORMAL RESULT IAW AMM 33-51-06SDR CALA2020010600059Battery Pack · dischargedB777-33-3-7019: L/H #1 DOOR EMER LT POWER SUPPLY(M33424) DEEP CYCLE CHECK FAIL.REF NR LP 9130210 L/H DOOR 1 DOOR EMER LT POWER SUPPLY M33424 BATTERY PACK REPLACE D AND OP TEST CARRIED OUT WITH NORMAL RESULT IAW AMM 33-51-06SDR SIMA2020010229001Light · inoperativeRH EXT UPPER (OVER WING) EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED EXT UPPER (OVER WING) EMERGENCY LIGHT ASSY IAW AMM 33-50-07. OPC GOOD.SDR SIMA2020010229002Flashlight · unsecureMEL 25-53 AUTH# 121051-C AFT FA FLASHLIGHT INOPREF LOG PAGE 4550081 ITEM 1 .-C/A-RESEATED FLASH LIGHT IN HOLDER AND LET CHARGE ALL NIGHT. OPC GOOD. MEL 25-53 RESTORED.SDR SIMA2020010229004Lamp · inoperativeAFT EMERG. CEILING LIGHT IS INOP-C/A-REMOVED AND REPLACED AFT EMERG. CEILING LIGHT LAMP, OPC GOOD, IAW AMM 33-50-08SDR SIMA2020010229003Power Supply · inoperativeOVERHEAD EMERG LIGHT OUT FURTHEST AFT LOCATION"TRANSFERRED TO NRWC 048-ORD-01255"-C/A-REMOVED AND REPLACED #4 EMERGENCY LIGHT POWER UNIT IAW AMM33-50-01. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR MASA201912312210Light · inoperativeROW 18 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR AALA201912319015Power Supply · faultedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS INTERIOR AND EXTERIOR EMERGENCY LIGHTS INOP AT 2L DOOR (AFT OF DOOR) RELAMPED BOTH, NO HELP. FOUND EMERGENCY POWER SUPPLY M33099 AT DOOR 2L FAULTY. REMOVED AND REPLACED EMERGENCY POWER SUPPLY PACT M33099 IAW AMM 33-5SDR AALA201912319016Battery · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EPSU BITE TEST FAULTED BATTERY (10WL) FWD L. REPLACED BATTERY PACK IAW AMM 33-51-38. OPS CHECK OKAY.SDR AALA201912319017Battery Pack · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EPSU BITE TEST FAULTED BATTERY (12WL) EMER R. REPLACED BATTERY PACK IAW AMM 33-51-38. OPS CHECK OK.SDR AALA201912319018Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS EPSU BITE TEST FAULTED BATTERY (13WL) AFT L. REPLACED BATTERY PACK IAW AMM 33-51-38. OPS CHECK OKAY.SDR DALA201912317637Battery Pack · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE AT SEATS 24 - 26DEF, BINS 34, 42 AND 44, OVERWING EXITS, AND EXIT. R & R TWO BATTERY PACKS FOR EMERGENCY LIGHTING IAW AMM 33-51. OPS CHECKED GOOD.SDR R61A2019123091440Power Supply · inoperativeCOCKPIT EMERGENCY LIGHT WILL NOT ILLUMINATE - REMOVED AND REPLACED FWD RH EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01, OPS CHECK GOOD. COCKPIT EMERGENCY LIGHT OPS CHECK GOOD
Back to JASC 3350