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 DALA2018112606787Light · inoperative(LOG 0840142) DURING INSPECTION FOUND EMERGENCY EXIT SIGNS INOPERATIVE. IN STALLED ROBBED LIGHT ASSY FROM A/C 3742 PER B737 AMM 33-51. OPS CHECK GOOD.SDR SIMA201811265001Lamp · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOP-C/A-RAR SVC DOOR HINGE EXTERNAL EMERGENCY LAMP IAW EMB AMM 33-50-10-000-801-A/33-50-10-400-801-A OPC GOODSDR DALA2018112606791Battery Pack · inoperativeLEFT AND RIGHT OVERWING EXIT LIGHTS WILL NOT TURN ON. REPLACED B5-49 OVERWING EMERGENCY EVACUATION LIGHTS BATTERY PACK REF MD88 AMM 33-53-00. (LP0840106)SDR MASA2018112511548Light · inoperativeROW 9 OVERHEAD EMER LT INOP. PLACED ON MEL.SDR DALA2018112966891Battery Pack · no test(AIRCRAFT 5816, L/P 5192380) DURING EMERGENCY LIGHT TEST, FWD CABIN, RT FIRST CLASS SEATS FLOOR PROXIMITY PATH LIGHTING INOP. REMOVED AND REPLACED BATTERY PACK IAW B757 MM 33-51.SDR DALA2018112986890Sign · broken(AIRCRAFT 684, L/P 5320708) RIGHT SIDE EXIT ROW SIGN BROKEN WHILE PASSENGER DEPLANING. R/R EPL HOUSING @ 39D.SDR SWAA2018112727087Light · inoperativeLT INTERIOR OVERWING EXIT DOOR FLOOD LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2018112727047Lens · unsecureCENTER AISLE EMERGENCY EXIT ROW EMERGENCY EXIT LIGHT SIGN FELL OFF. REINSTALLED LENS COVER IAW SIP.SDR AALA201811269033Power Supply · inoperativeMID CABIN LEFT AFT EMERGENCY POWER SUPPLY WAS INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED NORMAL.SDR AALA201811269025Power Supply · no testCID TEST FAILED FOR THE EMERGENCY POWER SUPPLY. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE POWER SUPPLY 15WL IAW AMM 33-51-38-000, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811269024Power Supply · no testCID TEST FAILED FOR THE EMERGENCY POWER SUPPLY UNIT. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE POWER SUPPLY 12WL IAW AMM 33-51-38-000, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811269017Power Supply · no testCID TEST FAILED FOR THE EMERGENCY POWER SUPPLY UNIT. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 11WL IAW AMM 33-51-38-000, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR HNAA2018112600291Bulb · inoperativeNDIS 624 33-51 0013850 24NOV18 SBY CLOSE
PAX DOOR EMERGENCY LIGHT INOP
70100 00 SPE
FACT 24NOV18 08:21 SBY
R & R'ED LIGHT BULB FOR PAX DOOR EMERGENCY LIGHT AND
RE-SECURSDR SIMA201811264001Charger · failedLH AND RH OVERWING EMERGENCY LIGHTS INOP-C/A-REMOVED AND REPLACED #4 EPSU BATTERY PACK AND CHARGER, OPS CHECK GOOD IAW EMB AMM 33-50-04. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 101787SDR DALA2018112506759Battery · dischargedDURING SERVICE CHECK, FOUND EPSU BATTERY DEAD AT DOOR 4L. REPLACED EPSU BATTERY AT DOOR 4L.SDR CALA2018112502432Battery Pack · dischargedDOOR L3 EMER LIGHT POWER SUPPLY M33405 BATTERY PACK LOW CAPACITY. BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018112502431Battery Pack · dischargedDOOR R2 EMER LIGHT POWER SUPPLY M33097 BATTERY PACK LOW CAPACITY. BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018112502430Charger · failedDOOR R1 EMER LIGHT POWER SUPPLY M33094 CHARGER DEEP CYCLE FAIL. CHARGER REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018112502429Charger · failedDOOR R4 EMER LIGHT POWER SUPPLY M33409 CHARGER DEEP CYCLE FAIL. CHARGER REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018112502428Battery Pack · dischargedDOOR R4 EMER LIGHT POWER SUPPLY M33409 BATTERY PACK LOW CAPACITY. BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018112502427Battery Pack · dischargedDOOR L1 EMER LIGHT POWER SUPPLY M33424 BATTERY PACK LOW CAPACITY. BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2018112502426Battery Pack · dischargedDOOR R1 EMER LIGHT POWER SUPPLY M33094 BATTERY PACK LOW CAPACITY. BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR DALA2018112406750Battery Pack · dischargedDURING TESTING FOUND ROWS 1 TO 40 EMERGENCY ESCAPE SEAT PATH LIGHTING NOT WORKING. R&R FWD POWER SUPPLY BATTERY PACK PER AMM 33-51. CABIN SEAT 1 - 4 ESCAPE PATH LIGHTS CK GOOD.SDR SWAA2019011627902Light · inoperativeRT OVERWING EXIT SIDEWALL LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2019011627901Light · inoperativeRT OVER WING EXIT LIGHT INOP. R&R BULBS IAW AMM.SDR SWAA2018112727086Light · inoperativeRT EMERGENCY BULLNOSE LIGHT INOP BETWEEN ROW 3 TO ROW 13. RELAMPED LIGHTS PER AMM.SDR SWAA2018112727068Light · inoperativeAFT CARGO DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2018112727146Cover · missingLT EMERGENCY EXIT BULLNOSE LENS COVER MISSING AT ROW 12. INSTALLED COVER PER SIP.SDR SWAA2018112727122Sign · missingRT OVERWING "EXIT" SIGN MISSING. INSTALLED SIGN PER AMM.SDR AALA201811276001Power Supply · inoperativePASSENGER B/C SEAT 1D, EMERGENCY LIGHT ALWAYS STAYS ON. REPLACED EMERGENCY POWER SUPPLY M33094 AND PERFORMED SUCCESSFUL TEST IAW AMM 33-51-00-720-801.SDR FDEA201811233359Light · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED R1 DOOR EMERGENCY EXIT LIGHT BULB (P/N GE767) REF AMM 33-51-01. OPERATIONAL CHECKS GOOD.SDR SIMA2018112603003Charger · failedDURING PS-1 FOUND RH AND LH OVER WING EMERGENCY LIGHT INOP-C/A-RAR #4 BATTERY POWER SUPPLY IAW EMB 140 AMM 33-50-04. OPC CK GOOD ON BOTH SIDE NO DEFECTS NOTED AT THIS TIMESDR SIMA201811263004Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOP-C/A-RAR LAMP IN COCKPIT EMERGENCY LIGHT ASSEMBLY IAW EMB AMM 33-50-05-000-801-A AND 33-50-05-400-801-A OPC GOODSDR AALA201811265003Battery · no testFOUND TRACK ASSEMBLY PLACARD AND HEADER SIGN AT THE L4 DOOR INOPERATIVE. MAINTENANCE REPLACED THE BATTERY UNIT WELS AND CONTROL IAW AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA201811263001Battery Pack · inoperativeLH OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH OVERWING EMERGENCY LIGHT LAMP IAW EMB AMM TASK 33-50-10-000-801-A AND 33-50-10-400-801-A. NO FIX. TROUBLE SHOT IN REFERANCE WITH WM 33-50-50 FOUND #4 POWER SUPPLY AND BATTERY TO BE BAD. RAR #4 POWER SDR DALA2018112406758Light · malfunctionedVARIOUS EMERGENCY EXIT LIGHTS ON IN CRUISE WITH EMERGENCY EXIT LIGHT SWITCH IN ARM POSITION. RESET CID, PERFORMED SYSTEM TEST OF EPSU, NO FAULT FOUND.SDR MASA2018112311544Light · inoperativeROW 18CD EMERGENCY SIGN BULB INOP. PLACED ON MEL.SDR CALA2018112302416Light · unknownFLOOR LEVEL EXIT SIGNS AT 22A TURNING OFF AND ON EMERGENCY ESCAPE PATH LIGHTING SYSTEM OPERATIONAL TEST CARRIED OUT IAW AMM 33-51-00-715-019-001. OPS CHECK GOOD. FLOOR LEVEL EXIT SIGN LIGHT ASSY ADJACENT TO SEAT 22A REMOVED AND THEN RE-INSTALLED POST LIGHT ASSDR DALA2018112906903Light · damagedDURING SAFA INSPECTION FOUND RED EMERGENCY LIGHT DAMAGED. REPLACED LIGHT ASSEMBLY SYSTEM OPERATION IS NORMAL.SDR REXA2018112201155Battery Pack · dischargedUPON INSPECTION FOUND EXTERIOR EMERGENCY LIGHTS 5 AND 6 INOP. FOUND BATTERY PACK 4 NOT WORKING FOR EXTERIOR EMERGENCY LIGHTS 5 AND 6, REMOVED AND REPLACED NR 4 BATTERY PACK (POSITION PS38) IAW JOBCARD 33-900-701 PART B. OPERATIONAL TEST GOOD NO DEFECTS NOTEDSDR SWAA2018112727158Battery Pack · dischargedFORWARD ENTRY EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018112727143Light · looseEMERGENCY PATH LIGHT LOOSE NEAR ROW 8. R&R STRIP IAW AMM.SDR SWAA2018112727142Light · inoperativeR2 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018112727141Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018112727129Cover · missingAFT LAV EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER IAW AMM.SDR SWAA2018112727110Battery Pack · dischargedFORWARD ENTRY EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR AALA201811279006Battery · failedEMERGENCY LIGHTS CIDS PANEL FLAGING, EMERGENCY EXIT SIGN OVER L1 DOOR INOPERATIVE AND 11WL BATTERY FAILED. THE AIRCRAFT WAS GROUNDED. REPLACED L1 EXIT SIGN OVER L1 DOOR IAW AMM 33-51-38 AND REPLACED 11WL BATTERY IAW 33-51-04. OPERATIONS CHECK GOOD.SDR AALA2018112769032Battery Pack · failedCIDS TEST FAILED FOR THE EPSU 11WL. REPLACED THE BATTERY IN THE POWER SUPPLY IAW AMM 25-23-41. OPS CHECKED OK.SDR AALA2018112769029Sign · inoperativeEMERGENCY LIGHTS CIDS PANEL FLAGING. THE EMERGENCY EXIT SIGN OVER THE L1 DOOR WAS INOPERATIVE AND 11WL BATTERY FAILED. THE AIRCRAFT WAS GROUNDED. REPLACED THE EXIT SIGN IAW AMM 33-51-38.SDR DALA20181126811Light · inoperativeSHIP 5816 EMERGENCY LIGHT LOCATED AT MID GALLEY FWD POSITION INOP. CORRECTIVE ACTION: R/R EMERG LIGHT ASSY. OPN GOOD. REF 757 CMM 25-30-12. (5192370)
Back to JASC 3350