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 YENA2020032080250Battery · failedFLT 464, SEA- JFK. EPSU TEST REQUIRED PRIOR TO DOOR SLIDE REMOVAL BATTERIES REQUIRE REMOVAL ; R + R EPSU BATTERY IAW AMM 33-51-38SDR YENA2020032080249Battery · failedFLT 464, SEA- JFK. EPSU TEST REQUIRED PRIOR TO DOOR SLIDE REMOVAL BATTERIES REQUIRE REMOVAL ; R + R EPSU BATTERY IAW AMM 33-51-38SDR YENA2020032080248Battery · failedFLT 464, SEA- JFK. EPSU TEST REQUIRED PRIOR TO DOOR SLIDE REMOVAL BATTERIES REQUIRE REMOVAL ; R + R EPSU BATTERY IAW AMM 33-51-38SDR AALA202003209001Light · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AT ROW 15ABC INOPERATIVE. REMOVED AND REPLACED AISLE PATH LIGHT IAW AMM 33-51-19.SDR AALA202003209002Light · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AT ROW 14ABC INOPERATIVE. REMOVED AND REPLACED AISLE PATH LIGHT IAW AMM 33-51-19.SDR DALA2020032001948Light · unsecureSHIP 3869 EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:27D . CORRECTIVE ACTION: RESECURED, OK FOR SVC (1533962).SDR YENA2020032080247Unknown · malfunctionedFLT 66, ABQ-JFK. INFLIGHT CREW REPORTS THAT INFLIGHT WITH GEAR AND FLAPS UP AND ABOVE 10000, THE EMER EXIT LT ARE ILLUMINATED ; PERFORMED FULL CIDS RESET AND EMER LIGHT TEST.NO FAULTS PRESENT AT THE MOMENT.A/C OK FOR CONT SVC. REF AMM 33-51-00-710SDR SIMA202003198002Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP-C/A-RAR SERVICE DOOR EMERGENCY LIGHT LAMP IAW EMB 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. END.SDR FDEA2020031980593Light · inoperativeMDIS 842 33-50 3495 18MAR20 MEM POST-FLT INSP L-1 EXTERIOR EMERGENCY LT INOP. FACT 18MAR20 07:12 MEM RE-LAMPED, REF B777 AMM: 33-51-04-2. EMERGENCY LT'S TEST SATIS, ITEM OK FOR SVC.SDR SWAA2020031942611Guard · brokenEMERGENCY LIGHT SWITCH GUARD BROKEN AT P5 OVHD PANEL O.K TO CONTINUE PER MEL 25-10-02 SP 1BSDR SWAA2020031942602Battery Pack · dischargedEMERGENCY LIGHTS ASSOCIATED WITH M2335 ARE INOP REPLACED M2335 POWER SUPPLY-BATTERY PACK AND PERFORMED GOOD NEW BATTERY PACK TEST AND ALL ASSOCIATED LIGHTS ARE OPERATIONAL PER AMM 33-51-06-960-805. 92974U, 18MAR20.SDR SWAA2020031942588Light · unsecureFWD R/H SERVICE DOOR FLOOR EMERGENCY EXIT LIGHT WILL NOT SECURE. REMOVED AND REPLACED ASSEMBLY PER AMM 33-51-01.SDR SWAA2020031942583Light · looseFLOOR ILLUMINATION EGRESS STRIP NOT SECURED AT FWD GALLEY RESECURED FLOOR EGRESS STRIP REF SIPSDR SWAA2020031942577Light · inoperativeRH OVERWING EMERGENCY LIGHT INOP RELAMPED RIGHT OVERWING EMERGENCY LIGHT_ IAW AMM 33-51-04. OPS CHECK GOOD.SDR MASA2020031800124Light · inoperativeSV DR FLR LVL EXIT SIGN HAS 1 BULB INOP- PLACED ON MELSDR DALA2020031801918Light · inoperativeSEVERAL EMERGENCY LIGHTS IN CABIN CEILING ARE INOPERATIVE. MAINTENANCE RELAMPED THEM IAW B717 AMM 33-51. (LP #6674820)SDR DALA2020031801916Battery · dischargedOVERWING EMERGENCY EXIT LIGHTS INOP AT ROW 25. REPL BATTERIES PER MD88 AMM 33-53. OPS CHECK GOOD. (LP6104945)SDR SWAA2020032332187Light · inoperativeSIDEWALL LIGHT OUT AT 11 ABC (EMERGENCY EXIT). / RELAMPED PASSENGER CABIN SIDEWALL LIGHT AT 11ABC IAW AMM 33-51-11.SDR FDEA202003170579Battery · dischargedEMERGENCY LIGHTS IN CTR COURER AREA, ABOVE R1 DOOR, AND R1DOOR EXTERIOR LIGHTS ARE INOP. AMM: 33-51-07-2 REMOVED AND REPLACED EMERGENCY PACK HOLDER ASSY REF B757 AMM 33-51-07-2. OPS SDR AALA2020032099008Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT SYSTEM TEST SHOWED "EMERGENCY POWER SUPPLY UNIT 11WL" MESSAGE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 11WL BATTERY PER AMM 33-51-38.SDR DALA2020032001962Light · brokenSHIP 5645 LT FWD OVERWING EXIT EMERGENCY LIGHT BROKEN. CORRECTIVE ACTION: R/R EMERGENCY LIGHT REF B757 AMM 33-51. OPS CK GOOD. (6383613)SDR AALA2020032099005Light · inoperativeAIRCRAFT NOT GROUNDED - SEAT 27C AISLE EMERGENCY EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED SEAT 27C SEAT MOUNTED EMERGENCY LIGHT PER AMM 33-51-19. OPERATIONAL CHECK GOOD.SDR AALA2020031989003Light · inoperativeAIRCRAFT WAS GROUNDED: R2 EXTERNAL EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE REPLACED EXIT LIGHT PER AMM 33-51-06.SDR SWAA2020031942586Light · inoperativeSIDEWALL LIGHT OUT AT 11 ABC (EMERGENCY EXIT). RELAMPED PASSENGER CABIN SIDEWALL LIGHT AT 11ABC IAW AMM 33-51-11.SDR SWAA2020031842550Battery Pack · failedRH FWD EMERGENCY LIGHTING BATTERY PACK FAILS CAPACITY TEST R&R RH FWD EMERGENCY LIGHTING BATTERY PACK PER AMM 33-51-06SDR SWAA2020031842546Light · inoperativeAFT SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOP RELAMPED EXTERIOR AFT SERVICE DOOR LIGHT PER AMM 33-51-04SDR SIMA202003187001Light · inoperativeLH FUSELAGE AFT EMERGENCY LAMP INOP-C/A-REMOVED AND REPLACED LH FUSELAGE AFT EMERGENCY LAMP, OPC GOOD IAW EMB AMM 33-50-10.SDR QXEA2020031800141Strip · looseFWD FLOOR STRIP ON LEFT SIDE PEELING BACK. REMOVED FROM SERVICE. RE-SECURED STRIP WITH CARPET TAPE. AIRCRAFT RETURNED TO SERVICE.SDR DALA2020041602273Mount · unknown(LOG 1532076) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. REMOVED AND REPLACED MOUNT ASSY PER CMM 25-22-56. OPS CHK GOOD.SDR FDEA2020031760578Power Supply · inoperativeFOUND DURING PREFLIGHT, INTERIOR EMERGENCY LIGHT ABOVE L1 DR INOP. REMOVED AND REPLACED M731 POWER SUPPLY PER MM 33-51-07-2, OPS CK GOOD. CLEARED MEL. OK FOR SERVICE.SDR FDEA2020031760577Power Supply · inoperativeFOUND DURING PREFLIGHT, EXTERIOR EMERGENCY SLIDE LIGHT AFT OF L1 DR INOP REMOVED AND REPLACED M731 POWER SUPPLY PER MM 33-51-07-2, OPS CK GOOD. CLEARED MEL. OK FOR SERVICE.SDR SWAA2020031942601Battery Pack · dischargedEMERGENCY LIGHTS ATTACHED TO M1670 INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTER PACK AND PERFORMED GOOD INSTALLATION TEST PER AMM 33-51-06-960-801 AND AIR RETURN GRILLES PER AMM 21-23-03-000-801, AND AMM 21-23-03-400-802. 81136U, 17MAR20.SDR SWAA2020031942600Battery Pack · dischargedEMERGENCY LIGHTS ATTACHED TO M2335 INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK AND PERFORMED GOOD INSTALLATION TEST PER AMM 33-51-06-960-801 AND AIR RETURN GRILLE PER AMM 21-23-03-000-801, AND AMM 21-23-03-400-802 81136U 17MAR20SDR DALA2020031801928Light · unsecure(AIRCRAFT 3140, L/P 1530874) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:14D / INTERIOR.CORRECTIVE ACTION:SECURED LIGHT.SDR YENA2020031860243Battery · failedSUPPLEMENTAL INFORMATION (UNIQUE CONTROL NUMBER): FLT# 905, EWR-TPA. RH EMER EXIT EPSU FAILED BITE TEST; REPLACED EPSU BATTERY PER AMM 33-51-38.SDR YENA2020031840243Battery · dischargedFLT# 905, EWR-TPA. RH EMER EXIT EPSU FAILED BITE TEST; REPLACED EPSU BATTERY PER AMM 33-51-38SDR SWAA2020031742544Light · inoperativeBOTTOM TWO LAMPS ON AFT SERVICE DOOR THRESHOLD EMERGENCY EXIT LIGHT ASSEMBLY, AFT LAMP ON LEFT OVERWING DOOR EMERGENCY WINDOW LIGHT, AND SECOND BULB FROM TOP ON LEFT OVERWING EXIT DOOR INDICATOR LIGHT ASSEMBLY ARE INOP. RELAMPED AFT SERVICE DOOR THRESHSDR SWAA2020031742543Light · inoperativeBOTTOM TWO LAMPS ON AFT SERVICE DOOR THRESHOLD EMERGENCY EXIT LIGHT ASSEMBLY, AFT LAMP ON LEFT OVERWING DOOR EMERGENCY WINDOW LIGHT, AND SECOND BULB FROM TOP ON LEFT OVERWING EXIT DOOR INDICATOR LIGHT ASSEMBLY ARE INOP. RELAMPED AFT SERVICE DOOR THRESHSDR SWAA2020031742532Light · inoperativeBOTTOM TWO LAMPS ON AFT SERVICE DOOR THRESHOLD EMERGENCY EXIT LIGHT ASSEMBLY, AFT LAMP ON LEFT OVERWING DOOR EMERGENCY WINDOW LIGHT, AND SECOND BULB FROM TOP ON LEFT OVERWING EXIT DOOR INDICATOR LIGHT ASSEMBLY ARE INOP. RELAMPED AFT SERVICE DOOR THRESHSDR SWAA2020031742518Sign · missingEMERGENCY EXIT SIGN (MID CABIN) MISSING RE-INSTALLED EMERGENCY EXIT SIGN IAW AMM 33-51-03SDR SIMA202003176001Charger · failedSERVICE DOOR EMERGENCY EXIT LIGHT INOP-C/A- T/S FOUND EMERGENCY BATTERY NOT WORKING REMOVED AND REPLACED EMERGENCY BATTERY #2 AND CHARGER IAW ENVOY W/C 33-700-19 OPC GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 104854SDR AALA202003179010Battery · dischargedAIRCRAFT NOT GROUNDED: R3 DOOR EPSU BATTERY FLAGGED DURING EPSU TEST. REMOVED AND REPLACED R3 DOOR EPSU BATTERY IAW AMM 33-51-38.SDR DALA2020031701888Battery Pack · discharged(LOG 7129331) DURING INSPECTION FOUND EMERGENCY EXIT SIGNS AT FWD OVERWING EXIT LT AND RT INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK M1694 PER B737 AMM 33-51. OPS CKS GOOD.SDR MASA2020031600119Light · inoperativePAX DR FLR EMER FLOOR LT HAS 1 BULB INOP- PLACED ON MELSDR DALA2020031601857Battery · dischargedOVERHEAD EMER LIGHTS FROM SEAT 25 BACK INOP. RPLCD BATTERIES IN EMER LIGHT BATTERY PACK. OPS CK GOOD ALL WORK IAW MD88 AMM 33-53. (LP6639260)SDR SWAA2020032330919Light · inoperativeEMERGENCY LIGHT AT 6DEF INOP / REPLACED BULB ON EMERGENCY LIGHT AT SEAT 6DEF REF AMM 33-51-00SDR SWAA2020032330954Fuse · not reportedEMERGENCY LIGHTS CONNECTED TO M1670 ARE INOP / OPENED RETURN AIR GRILLE PER AMM 21-23-03-000-801 59391U 15MAR20 LEAD 820 19MAR20 UPON TROUBLESHOOTING BATTERY PACK M1670 DISCOVERED FUSE; REPLACED FUSE AND PERFORMED GOOD FUNCTIONAL TEST PER AMM 33-51-06-960-804 SDR ASAA2020031932461Power Supply · inoperativeSEVERAL CABIN EMERGENCY LIGHTS INOP. GROUNDED - YES. REMOVED AND REPLACED POWER SUPPLIES M2335, M1898, M1670, M1899, AND M1671 OPS CHECK GOOD IAW B737-900 AMM 33-51-00-710-801.SDR DALA2020031901943Lens · missingSHIP 654 EMERGENCY LIGHT LENS MISSING L/H SIDE AT APROX 10A,B. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT LENS PER B757 AMM 33-50. (6737550)SDR AALA2020031879005Light · disconnectedAIRCRAFT NOT GROUNDED - EMERGENCY AISLE EGRESS LIGHT, FORWARD MOUNTED, INOPERATIVE AT SEAT 4H. RECONNECTED 4H EGRESS LIGHT ASSEMBLY, OPERATIONAL CHECKS OKAY PER MM 33-51-05.
Back to JASC 3350