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 AALA201912069020Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTS INOPERATIVE FROM SEATS 37HGED TO 44HGED. REPLACED BATTERY PACK ON POWER SUPPLY M33409 PER AMM 33-51-06-760-802 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06-710-002.SDR AALA2019120659009Cover · missingAIRCRAFT WAS NOT GROUNDED: DOOR 4L EXIT SIGN COVER MISSING. MAINTENANCE FOUND SIGN COVER ON AN OVERHEAD BIN AND RESTORED IN CORRECT POSITION PER AMM 33-51-00.SDR AALA2019120659008Cover · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN IN R1 GALLEY WAS MISSING COVER. MAINTENANCE REPLACED EXIT SIGN COVER PER STANDARD PRACTICES.SDR R61A2019120641353Light · wornPHOTOLUMINESCENT STRIP WORN IN FRONT OF FWD WARDROBE. R&R PHOTOLUMINESCENT STRIPS PER AMM 33-50-21.SDR DALA2019120657111Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE, REPLACED THE EXIT SIGN IAW 33-51. OK FOR SERVICE.SDR WX0A2019120673445Battery Pack · no testCABIN EMERGENCY LIGHTING FAILED TESTING / R&R EPSU BATTERIES"SDR UIEA2019120656004Light · missing1" STRIP OF ESCAPE PATH LIGHTING AT DOOR R2 MISSING.(<P>REPLACED EMERGENCY LIGHT ASSEMBLIES AND SECURED FLOOR COVERING IAW AMM 33-51-12. </P>)SDR SWAA2019120659382Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675 IN CABIN. / R&R BATTERY PER AMM.SDR SWAA2019120659363Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673 IN CABIN. / R&R BATTERY PER AMM.SDR DALA2019120507096Lens · damagedRED EMERGENCY LIGHT AT DOOR 3L LENS DAMAGED. REPLACED LIGHT ASSEMBLY AT DOOR 3L. LP 6716373.SDR DALA2019120507095Connector · disconnectedEMERGENCY LIGHTS INOPERATIVE AT SEATS 3.J AND 41J. RE-CONNECTED CONNECTORS UNDER SEAT 30J AND 41J. LP 6453105SDR AALA201912059018Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: MID GALLEY EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK ON POWER SUPPLY M33400 PER AMM 33-51-06-960-802 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06-710-002.SDR AALA201912059017Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTS ON SEATS 5 TO 9 ON CEILING INOPERATIVE. REPLACED BATTERY PACK ON POWER SUPPLY M33651 PER AMM 33-51-06-960-802 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06-710-002.SDR AALA201912059016Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: LAVATORY 4F-LC EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK ON POWER SUPPLY M33400 PER AMM 33-51-06-960-802 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06-710-002.SDR AALA201912059015Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: DOOR 5L EMERGENCY EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK ON POWER SUPPLY M33407 PER AMM 33-51-06-960-802 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06-710-002.SDR DALA2019120547093Sign · detached(LOG 6635551) DURING INSPECTION FOUND OVERWING EXIT SIGN FELL OFF. REINSTALLED COVER, LIGHTS OPS NML.SDR DALA2019120547062Power Supply · inoperativeDURING SERVICE CHECK FOUND EMERGENCY PATH LIGHTS AT ROW 14-20 INOPERATIVE. REPLACED POWER SUPPLY AND BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR UIEA2019120545998Battery Pack · inoperativeEMERGENCY LIGHTS AT RIGHT AISLE CEILING INOP (ROW 22JL).(<P>REMOVED AND REPLACED BATTERY PACK ASSY IAW B767 AMM 33-51-07, OPS CHECK OK.</P>)SDR SIMA201912054004Bulb · inoperativeUPON COURTESY CHECK FOUND RH OVER WING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED EMERGENCY LIGHT BULB OVER WING ON RH SIDE IAW EMB 140 AMM 33-50-10 OPC GOOD NO FURTHER DEFECTS NOTED AT THIS TIMESDR SIMA201912054002Bulb · inoperativeRH OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED RH OVERWING EMERGENCY LIGHT BULB, OPC BAD, IAW EMB AMM 33-50-07SDR SIMA201912054003Charger · inoperativeBOTH EXTERNAL OVERWING AFT EMERGENCY LIGHTS INOP-C/A-T/S IAW EMB WIREING MANUAL 33-50-50, REMOVED AND REPLACED NUMBER 4 BATTERY AND CHARGER IAW W/C 33-700-19. OPC GOOD, NO FUTHER DEFECTS FOUND. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 103797SDR QXEA2019120500445Light · inoperativePHOTO-LUMINESCENT STRIP NOT ILLUMINATING BY ROW ONE C/D ( PHOTO-LUMINESCENT ESCAPE ROUTE MARKING SYSTEM ). REMOVED FROM SERVICE. R & R PHOTO-LUMINESCENT STRIPS BY ROW ONE C/D IAW E175 AMM TASK 33-50-21-000/400-801-A. OPS TEST GOOD. REAPPLIED SEALANT TO PASSENGSDR DALA2019120507064Charger · inoperativeSVC EMERGENCY LIGHTS INOP DOORS 4R/4L C/A R/R AFT DOOR EMERGENCY LIGHT CHARGER JPER B767 AMM 3351 OPS CKS GOOD (6708573)SDR UIEA2019120506001Sign · malfunctionedCOCKPIT "EXIT" EMERGENCY LIGHT FLASHING DURING TAKEOFF ROLL AND LANDING.(<P>RE-SECURED COCKPIT EXIT EMERGENCY LIGHT ASSEMBLY AS PER AMM 33-51-01 AND OPS CHECK OK.</P>)SDR SIMA20191204001Lamp · inoperativeLH OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED OVERWING EMERGENCY LAMP IAW AMM 33-50-10 OPC GOODSDR DALA2019112757112Lens · damaged(AIRCRAFT 5803, L/P 6560476) FOUND 3R AND 3L EXIT LENS DAMAGED. CORRECTIVE ACTION:REPLACED DAMAGED LENS.SDR SIMA2020022803003Light · damagedNUMBER 10L EMERGENCY FLOOR PATH LIGHT REQUIRES REPLACEMENT DUE TO DAMAGE.-C/A-COMPLETE:INSTALLED SERVICEABLE EMERGENCY LIGHT AT 10L POSITION IAW CRJ AMM 33-51-01.SDR SWAA2019121639614Sign · brokenAFT LOWERED CEILING PANEL EXIT SIGN BROKEN. / R&R SIGN IAW AMM.SDR AALA2019120649005Light · brokenAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT FORWARD OF MAIN CABIN DOOR BROKEN. MAINTENANCE REPLACED EXIT LIGHT COVER PER AMM 33-51-00.SDR AALA2019120649002Light · missingAIRCRAFT WAS NOT GROUNDED: SEAT 12D EMERGENCY PATH LIGHT LENS MISSING. MAINTENANCE REPLACED PATH LIGHT PER CMM 25-0-67-440-012-401.SDR AALA201912059006Battery · no testAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS CIDS 1 EPSU SYST. TEST MESSAGE BAT / EPSU (14 WLK ) MID R. REMOVED AND REPLACED BATTERY PACK OF 14WL MID R. BITE TEST AT 14WL AND CIDS 1 , SYSTEM TEST OK.SDR DALA2019120547057Battery Pack · inoperativeON SERVICE CHECK FOUND LEFT AFT OVERHEAD EMERGENCY EXIT LIGHTS SIGNS INOPERATIVE. REPLACED BATTERY PACK M739. SYSTEM OPERATION IS NORMAL.SDR DALA2019120647072Lens · missing(AIRCRAFT 5651, L/P 5373086) DURING SERVICE CHECK FOUND: AFT RIGHT OVER WING "EXIT" LENS COVER MISSING. CORRECTIVE ACTION: REPLACED "EXIT" LENS COVER AS REQUIRED.SDR SIMA201912043002Battery Pack · inoperativeLH FWD EXTERNAL EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH EXTERNAL EMERGENCY LIGHT IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A NO FIX T/S WITH WM 33-50-50 FOUND BATTERY #1 AND CHARGER INOPERATIVE REMOVED AND REPLACED BATTERY #1 AND CHARGSDR HALA2019120400503Battery Pack · inoperativeEMERGENCY LIGHTS AT EXIT HATCHES DONT TURN ON WHEN SWITCH IS ON//REMOVED AND REPLACED EMERGENCY POWER BATTERY AT LOCATION B-5-121. OPS CK GOOD PER AMM 33-51-00. OK FOR SERVICE.SDR SWAA2019120439352Battery Pack · no testCABIN EMERGENCY BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01674. / INSTALLED BATTERY PACK PER AMM.SDR SWAA2019120439351Battery Pack · no testCABIN EMERGENCY BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01673. INSTALLED BATTERY PACK PER AMM.SDR SWAA2019120439350Battery Pack · no testCABIN EMERGENCY BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01672. / INSTALLED BATTERY PACK PER AMM.SDR SWAA2019120439349Battery Pack · no testCABIN EMERGENCY BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01675. / INSTALLED BATTERY PACK PER AMM.SDR SWAA2019120439348Battery Pack · no testCABIN EMERGENCY BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01670. / INSTALLED BATTERY PACK PER AMM.SDR SWAA2019120439347Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. / R&R BATTERY PER AMM.SDR SWAA2019120439346Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. / R&R BATTERY PER AMM.SDR SWAA2019120439328Battery Pack · failedEMERGENCY LIGHT BATTERY PACK AT POSITION M1668 FAILED OPERATIONAL TEST. / R&R BATTERY PACK IAW AMM.SDR SWAA2019120439325Battery Pack · failedCABIN EMERGENCY BATTERY PACKS FAILED CAPACITY TEST AT LOCATION M01668. / INSTALLED BATTERY PACK PER AMM.SDR SWAA2019120439324Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. / R&R BATTERY PER AMM.SDR SWAA2019120439320Light · inoperativeL/H OVER WING EXIT SIGN HAD LAMPS INOP/ RELAMPED SIGN IAW AMM.SDR SWAA2019120439319Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP/ RELAMPED LIGHT PER AMM.SDR SWAA2019120439318Light · inoperativeL/H OVERWING EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR MASA2019120432166Battery Pack · inoperativeR2 DOOR EMER EXIT SIGN/LIGHT INOP. R&R AFT RIGHT EMER BATTERY AND CHARGED LIGHTSSDR DALA2019120307004Battery Pack · inoperativeTHE EMERGENCY LIGHTS ARE OUT IN THE FIRST CLASS & COMFORT PLUS SECTIONS OF THE CABIN. MAINTENANCE REPLACED THE BATTERY PACK, B5-227, IAW AMM 33-51-03. OPS CHECKED NORMAL. (LP #6626493)
Back to JASC 3350