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 SWAA2019102538227Battery Pack · no testR/H FORWARD EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.SDR SWAA2019102538226Battery Pack · no testL/H FORWARD EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.SDR SWAA2019102538223Battery Pack · inoperativeR1 DOOR EMERGENCY LIGHT INOP. / R&R BATTERY PACK PER AMM.SDR SWAA2019102538194Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. / R&R BATTERY PER MM.SDR SWAA2019102538192Light · inoperativeL/H AFT GALLEY FLOOR TRACK PHOTO LUMINESCENT LIGHTS INOP LAST FOOT. / R&R PHOTO LUMINESCENT LIGHT AMM.SDR SWAA2019102538191Light · brokenEMERGENCY EXIT SIGN CENTER AISLE BROKEN AT ROWS 11. / R&R LIGHT PER AMM.SDR REXA2019102541560Light · inoperativeSMALL STRIP OF EMERGENCY FLOOR TRACK LIGHTING INOP IN FRONT
REMOVED AND REPLACED INOP FLOOR TRACK LIGHTING PN 36262-4 IAW CRJ200 AMM 33-51-01SDR SIMA201910254002Charger · inoperativeFOUND FWD EMERGENCY BATT #2 LIGHTS INOP-C/A-REMOVED AND REPLACED #2 EMERGENCY LIGHT BATTERY AND CRADLE ASSY IAW WC 33-700-19 AND W/C 33-700-17 OPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 104519SDR HNAA2019102500321Light · inoperativeEMERGENCY CEILING LIGHT BY SEAT 12 WILL NOT TURN ON....FIX: REMOVED CEILING PNL AT ROW 12INSTALLED NEW LIGHT, REINSTALLED CEILING PNL IAW AMM33-50-15. OPS CHECK GOOD. OK FOR SERVICESDR HALA2019102500458Lamp · inoperative"AFT EMERGENCY EXIT LIGHT INOP'. // RELAMPED AFT EMERGENCY EXIT LIGHT AS REQUIRED. OPS CHECK GOOD. OK FOR SERVICE.SDR UIEA2019102405786Cover · crackedEMER LIGHTS GUARDED COVER CRACKED (<P>REPLACED LIGHT SWITCH GUARD IAW AMM 33-51-00 OPS CKS NORMAL</P>)SDR 2019FA0000349Battery Pack · dischargedDURING PS CHECK FOUND 3R EMERGENCY LIGHT INOP. DOESNT TEST.SDR AALA2019102879006Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DOOR 1R EMERGENCY LIGHT POWER SUPPLY M33094 FAILED TEST. REPLACED POWER SUPPLY M33094 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR DALA2019102836211Light · out of positionSHIP 6706 EMERGENCY LTS ON AFT RT LAV COLORS ARE IN WRONG LOCATIONS. CORRECTIVE ACTION: REPLACED LIGHT ASSEMBLIES ON AFT RT LAV AND TESTED PER BOEING 757 AMM 33-51. (6091297)SDR YENA2019102830616Lamp · inoperativeDURING HEAVY MAINTENANCE, EMERGENCY LIGHT 90WL1 INOP; REF LHT NR 5200000679-005000927603 RELAMPED EMERGENCY LIGHT 90WL1 IAW A321 AMM 33-51-13. OPS CHECK GOODSDR AALA201910259016Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DOOR 4R EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33401 FAILED TEST. REPLACED POWER SUPPLY ASSEMBLY PER B777 AMM 33-51-06-960-803.SDR AALA201910259015Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DOOR 3L EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33302 FAILED TEST. REPLACED POWER SUPPLY ASSEMBLY PER B777 AMM 33-51-06-960-803.SDR AALA201910259014Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DOOR EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33303 FAILED TEST. REPLACED POWER SUPPLY ASSEMBLY PER B777 AMM 33-51-06.SDR AALA201910259013Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DOOR 3R EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33305 FAILED TEST. REPLACED POWER SUPPLY ASSEMBLY PER B777 AMM 33-51-06-960-803.SDR AALA201910259012Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DOOR 5L EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33407 FAILED TEST. REPLACED POWER SUPPLY ASSEMBLY PER B777 AMM 33-51-06-960-803.SDR AALA201910259011Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DOOR 4R EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33404 FAILED TEST. REPLACED POWER SUPPLY ASSEMBLY PER B777 AMM 33-51-06-960-802.SDR AALA201910259010Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DOOR 3R EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33306 FAILED TEST. REPLACED POWER SUPPLY ASSEMBLY PER B777 AMM 33-51-06-960-803.SDR AALA201910259009Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: DOOR 5R EMERGENCY LIGHT POWER SUPPLY ASSEMBLY M33408 FAILED TEST. REPLACED POWER SUPPLY ASSEMBLY PER B777 AMM 33-51-06-960-803.SDR HNAA2019102500322Lamp · not seatedSERVICE DOOR EMERGENCY LIGHT INOP....FIX: RESEATED SERVICE DOOR EMERGENCY LIGHT LAMP INTO SOCKET IAW AMM 33-50-10-000/400-801-A. OK FOR SERVICESDR AALA201910249011Battery Pack · no testAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS AFTER EMERGENCY LIGHT TEST WE FOUND AN EMERGENCY BATTERY INOP AT DOOR R4. REMOVED AND REPLACED BATTERY PACK POWER SUPPLY AT DOOR R4 IAW AMM 33-51-06. EMERGENCY LIGHT TEST CHECKED OK.SDR SIMA201910243002Light · inoperativeLH #1 EMERGENCY LIGHT STRIP NOT WORKING.-C/A-REMOVED AND REPLACED LH #1 EMERGENCY LIGHT STRIP IAW EMB AMM 33-50-12. OPS CHECK GOOD.SDR SIMA201910243004Battery · inoperativeRIGHT HAND WING TO FUSELAGE FWD EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED RIGHT HAND WING TO FUSELAGE FWD EMERGENCY LIGHT ASSY IAW EMB AMM 33-50-10. OPC FAILED. REMOVED AND REPLACED BATTERY POWER SUPPLY IAW AMM 33-50-04. OPC GOODSDR SIMA201910243003Bulb · inoperativeCENTER AISLE MIDDLE EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LIGHT BULB IAW AMM 33-50-08 OPC GOOD. SEE NRWC 841-DFW-02609SDR DALA2019102436138Power Supply · inoperativeEMERGENCY LIGHTS AT SEATS 31AB-41AB ARE INOPERATIVE. REPLACED BATTERY PACK AND POWER SUPPLY M9010. SYSTEM OPERATION IS NORMAL.SDR DALA2019102436135Sign · inoperative(LOG 6610414) DURING INSPECTION FOUND EMERGENCY EXIT LIGHT AT RIGHT SIDE FWD DOOR FLOOR LEVEL IS INOPERATIVE. REPLACED EMERGENCY EXIT SIGN LIGHT ASSY. MFN BR9476G145-01 LIGHTS WORK GOOD.SDR DALA2019102406130Battery Pack · inoperativeEMERGENCY LIGHTS IN AFT TAIL INOP. REMOVED AND REPLACED OVER HEAD BATTERY PACK FOR REAR AFT TAIL. OPS CHECK GOOD. IAW B717-AMM 33-55. (LP6356548)SDR QXEA2019102400394Battery Pack · inoperativeFWD RH FUSELAGE EMERGENCY EGRESS LIGHT INOP. REMOVED FWD RH FUSELAGE EMERGENCY EGRESS LAMP REF Q400 AMM 33-51-11-000-801 INSTALLED SERVICEABLE LAMP REF AMM 33-51-11-400-801. OPS CHECK DID NOT PASS ON STEP 5C. REMOVED & REPLACE BOTH BATTERY PACKS REF Q400 AMM 3SDR QXEA2019102400393Battery Pack · inoperativeFWD PAX DOOR ENTRY WAY EMERG LIGHTS INOP. REMOVED LH 1 BATTERY PACK AND REPLACED WITH SERVICEABLE UNIT FROM STOCK IAW AMM TASK 33-51-00-820-801 OPS CHECK OK.SDR MASA2019102312105Bulb · inoperativeROW 11 OVERHEAD EMERG LIGHT INOP R&R LIGHT BULBSDR SIMA20191023001Lamp · inoperativeDURING PS-1 CHECK FOUND LH OVER-WING EMERGENCY LIGHT INOP.-C/A-REMOVED AND REPLACED LAMP IAW EMB 145 AMM 33-50-10. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR 2020F00082Sign · brokenDOOR R2L EXIT SIGN BROKENSDR I5EA201910231002Power Supply · inoperativeR/H EMERGENCY LIGHT INOP R2 DOOR.SDR SWAA2019111938962Lens · brokenPASSENGER CABIN SIDEWALL PANEL 231YJW EXIT SIGN BROKEN. / R&R LENS IAW AMM.SDR REXA2019102821562Bulb · burned outEMERGENCY EXIT SIGN BY SERVICE DOOR HAS A BURNT OUT BULB
PLACING LIGHTED EXIT SIGN ON DEFFERAL IAW MEL 33-51-1E, MMO2 UPDATED,PLACARD INSTALLED MOC#14332 NOTIFIED CAT(E)***** RELAMPED SERVICE DOOR EMERGENCY LIGHT REF CRJ900 AMM 33-51-05. OPS TEST GOOD. MM02 SDR REXA2019102821561Sign · inoperativeEMERGENCY EXIT SIGN BY MAIN CABIN DOOR HAS BURNT OUT LIGHT
PLACING LIGHTED EXIT SIGN ON DEFFERAL IAW MEL 33-51-1E, MMO2 UPDATED,PLACARD INSTALLED, MOC#14332 NOTIFIED CAT(E)***** RELAMPED CABIN FLOOR FLOODLIGHT REF CRJ900 AMM 33-51-11. OPS TEST GOOD. MM02 UPDASDR YENA2019102820615Battery Pack · failedFT # 391, BOS-TPA. EPSU BATT 11WL REQUIRES REPLACEMENT; R & R EPSU BATT 11WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR YENA2019102820614Battery Pack · failedFT # 225, JFK-TPA. EPSU BATT 12WL REQUIRES REPLACEMENT; R & R EPSU BATT 12WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR DALA2019102736186Light · inoperativeDURING SERVICE CHECK, FOUND LED FLOOR PATH MARKING AT SEAT 20C, 22C, 24C AND 30.C INOPERATIVE. DEFERRED PER MEL 33-50-07A- . LP 6137957SDR AALA2019102539011Cids · faultedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED EMERGENCY EXIT LIGHTS WERE ILLUMINATED AND WOULD NOT EXTINGUISH. MAINTENANCE RESET CIDS AND EMERGENCY LIGHT CIRCUIT BREAKER AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA2019102539009Light · inoperativeAIRCRAFT WAS NOT GROUNDED: R2 EMERGENCY SLIDE LIGHT INOPERATIVE. MAINTENANCE REPLACED SLIDE LIGHT PER AMM 33-51-06.SDR SWAA2019102538211Battery Pack · inoperativeEMERGENCY EXIT BATTERY M1675 LIGHTS DID NOT WORK. / R&R BATTERY PACK PER AMM.SDR SWAA2019102538210Battery Pack · inoperativeEMERGENCY EXIT BATTERY M1674 LIGHTS DID NOT WORK. / R&R BATTERY PACK PER AMM.SDR DALA2019102536165Battery Pack · inoperative(AIRCRAFT 685, L/P 6398528) WHILE WORKING SVC FOUND SEAT 38,39,40,41,42 RH EMERGENCY LIGHTS INOP. CORRECTIVE ACTION: REMOVED AND REPLACED BATT. PACK ASSY PER B757AMM 33-51.SDR R61A2019102521141Sign · missingEXIT SIGN OVER L1 DOOR MISSING. R&R L1 DOOR EXIT MARKING SIGN IAW AMM 33-50-17.SDR R61A2019102521139Light · wornPHOTOLUMINESCENT STRIP IN FRONT OF FWD WARDROBE WORN. R&R PHOTOLUMINESCENT STRIP PER AMM 33-50-05.
Back to JASC 3350