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 SWAA2019093037277Lens · brokenR/H OVERWING EXIT LENS, FORWARD LOWER, BROKEN. / R&R LIGHT LENS PER SIP & AMM.SDR CALA2019093001671Epsu · failedEPSU 10WL FAILS OPS TEST AND BATTERY FAILS DATE INSPECTION SPEC NO. A3NB-33-3-6016 GEN BY V901995 PER NR9296046 AT HAECO LCQ REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. OPS CK GOOD IAW AMM 33-51-38-710-052-A PER NR 9296SDR HNAA2019093000292Light · inoperativeNDIS 665 33-40 0020660 27SEP19 SBY CLOSE
OVER WING EMERGENCY LIGHT INOP ON RH SIDE
35717 00 BRA
FACT 27SEP19 13:31 SBY
R AND R OVER WING EMERGENCY LIGHT IAW AMM TASK 33-50
SDR HNAA2019093000291Sign · inoperativeNDIS 654 33-50 0010340 27SEP19 SBY CLOSE
EMERGENCY EXIT SIGN ABOVE FLIGHT ATTENDANT SEAT DOES
NOT ILLUMINATE
FACT 27SEP19 15:06 SBY
REMOVED AND REINSTALLED EMERGENCY EXIT SIGN CORRECTL
Y. LIGHT ILLUMINATES. SDR VNAA2019092711102Light · inoperativeSUPPLEMENTAL INFORMATION RH SIDE #4 EMERGENCY LIGHT ABOVE THE WING INOP RELAMPED RH SIDE #4 EMERGENCY LIGHT OPS CHECK GOOD.SDR SWAA2019102238110Lens · discoloredR1 DOOR EXIT LIGHT LENSES DISCOLORED. / R&R LENSES PER AMM.SDR SWAA2019102238108Lens · discoloredR/H OVER WING EXIT SIDEWALL LIGHT LENSES DISCOLORED. / R&R LENSES IAW AMM.SDR SWAA2019102238096Lens · discoloredFORWARD ENTRY CENTER EXIT LIGHT LENS DISCOLORED. / R&R LENS PER AMM.SDR SWAA2019102238095Lens · discoloredL/H OVER WING EXIT SIDEWALL LIGHT LENSES DISCOLORED. / R&R LENSES IAW AMM.SDR SWAA2019102238094Lens · discoloredL1 DOOR EXIT LIGHT LENSES DISCOLORED. / R&R LENSES PER AMM.SDR SWAA2019102138029Lens · discoloredR2 DOOR EXIT LIGHT LENSES DISCOLORED. / R&R LENSES IAW AMM.SDR SWAA2019102138016Lens · discoloredL2 DOOR EXIT LIGHT LENSES DISCOLORED. / R&R LENSES IAW AMM.SDR SWAA2019102138015Lens · discoloredAFT ENTRY CENTERLINE EMERGENCY EXIT LIGHT LENSES DISCOLORED. / R&R LENSES IAW AMM.SDR HALA2019093000389Cover · unsecureEXIT SIGN AT 3R DOOR FELL OFF.// RE-SECURED EXIT SIGN COVER AT 3R DOOR. OK FOR SERVICE.SDR YENA201909260554Battery · dischargedFT # 1914, CUN-MCO. WHILE WORKING EMERGENCY LIGHT TEST ON WKLY FOUND ALL FWD EMERGENCY LIGHTS INOP; FOUND 10WL ESPU BATTERY DEAD. R & R BATTERY AND OPS TEST NORMAL IAW AMM 33-51-38.SDR YENA201909260553Battery · dischargedFT # 1914, CUN-MCO. WHILE WORKING EMERGENCY LIGHT TEST ON WKLY FOUND EMERGENCY EXIT ROW LIGHTS BLINKING AND SOME OFF; FOUND 11WL ESPU BATTERY DEAD. R&R BATTERY AND OPS TEST NORMAL IAW AMM 33-51-38.SDR CALA2019092801651Light · inoperativeSEAT MOUNTED FLOOR PROX LIGHTS INOP AT SEATS 9,14, 22, AND 27ABC. RELAMPED REF 33-51-11 OPS CHECKED OK. ACCOMPLISHED INSPECTION OF SEAT MOUNTED FLOOR PROX LIGHTS AT SEATS 9,14, 22 AND 27ABC.SDR CALA2019092801650Charger · inoperativeSUPPORT TASK CABIN SEAT 22 TO 27 EMERGENCY PATH LIGHTING FOUND DIM.REFER NR L/P:9131288 M732 BATTERY CHARGER AND BATTERY REPLACED AND OP TEST NORMAL AS PER AMM 33-51-07 ADD EMP: IDT INSP APPROVEDSDR CALA2019092801649Battery · dischargedSUPPORT TASK G8 GALLEY EXIT SIGN & L4 DOOR LIGHT FOUND DIM.REFER NR L/P:9131287 M739 BATTERY AND CHARGER REPLACED, EMERGENCY LIGHT TEST C/OUT NORMAL AS PER AMM 33-51-07 ADD EMP: IDT INSP APPROVEDSDR AALA201909279013Power Supply · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS EMERGENCY POWER SUPPLY 15WL INOP. REMOVED AND REPLACED EMERGENCY POWER SUPPLY 15WL IAW AMM 33-51-30-400-001-A. OPS CHECKED GOOD.SDR AALA201909279012Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY POWER SUPPLY 14WL INOP. REMOVED AND REPLACED EMERGENCY POWER SUPPLY IAW AMM 33-51-38-00-002-A AND AMM 33-51-38-400-001-A. OPS CHECKED GOOD.SDR AALA201909279015Cover · missingAIRCRAFT NOT GROUNDED: EMERGENCY LIGHT SEAT 9R MISSING COVER. REPLACED LIGHT IAW AMM 33-51-19. OP CK GOOD.SDR AALA201909279016Cids · malfunctionedAIRCRAFT NOT GROUNDED: WHILE AIRBORNE EMERGENCY EXIT LIGHTS ABOVE DOORS/WINDOWS ILLUMINATED. EVEN TURNING EMERGENCY LIGHT SWITCH OFF LIGHTS REMAINED ON. RESET CIDS. IAW TSM 24-00-00. TEST EXIT SIGNS IAW AMM 33-51-17 OPS TEST GOOD.SDR AALA201909279017Switch · sticksAIRCRAFT NOT GROUNDED: EMERGENCY EXIT LIGHTS ILLUMINATED. SUSPECT FAULTY TEST BUTTON AT 1L PANEL. CLEANED AND RESEATED 1L PANEL EMERGENCY LIGHT TEST SWITCH. OPS CKS NML IAW AMM 33-51-00.SDR DALA2019092705557Battery Pack · dischargedFIRST CLASS EMERGENCY LIGHTS INOP. REPLACED B5-211 BATTERY PACK AND POWER SUPPLY AT STA 388R IAW AMM 33-53 - ALL CKS GOOD.SDR DALA2019092605517Light · inoperativeSEAT ROW 21 EMERG LIGHT INOP. RPLCD EMERGENCY LIGHT AT SEAT ROW 21. REF AMM 33-52. CKS GOOD. (LP6406723)SDR SIMA201909265001Light · inoperativeROW 15A FLOOR PROXIMITY STRIP INOP. REMOVED AND REPLACED 15A FLOOR PROX LIGHT IAW AMM 33-50-12 OPS CHECK GOOD.SDR I5EA201910110906Power Supply · inoperativeBULLNOSE EMERGENCY LIGHT INOP AT SEAT ROW 14DF, 16DF, AND 18DF.SDR VNAA2019100192102Battery Pack · inoperativeEMERGENCY LIGHTS POWERED BY #4 BATTERY PACK DO NOT ILLUMINATE. REMOVED AND REPLACED #4 EMERGENCY BATTERY PACK IAW CRJ 700 AMM 33-51-17-000/400-801(A01). OPS. CHECK GOOD AT THIS TIMESDR HNAA2019093000289Light · inoperativeNDIS 614 33-50 0013140 25SEP19 SBY CLOSE
SERVICE DOOR EXTERNAL LIGHT IS INOP (EMERGENCY LIGHT)
27863 00 SSM
FACT 25SEP19 10:34 SBY
R+R SERVICE DOOR EXTERNAL LIGHT ASSY IAW AMM 33-50SDR IPXA2019092547247Light · inoperativeINSPECTION TYPE:N/AEMERGENCY LIGHT HAS EIGHT INOP BULBSRELAMPED EIGHT BULBS IN THE EMERGENCY LIGHT PER AMM 33-51-01-2SDR AALA201909269004Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT PATH LIGHT BROKEN AT LAVATORY LEFT ISLE. MAINTENANCE REPLACED EMERGENCY PATH LIGHT PER AMM 33-51-04.SDR AALA201909269003Light · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY SEAT MOUNTED LIGHT WAS DAMAGED AT SEAT 16C. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-19.SDR AALA201909269002Light · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY SEAT MOUNTED LIGHT WAS DAMAGED AT SEAT 10C. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-19.SDR SWAA2019092637251Charger · inoperativeLT EMERGENCY OVERWING GROUND ILLUMINATION LIGHT L547S INOP. R&R CHARGER IAW AMM.SDR SWAA2019092637250Charger · inoperativeLT EMERGENCY AISLE LIGHTS INOP AT SEAT 9. R&R CHARGER IAW AMM.SDR SWAA2019092637249Battery Pack · dischargedLT EMERGENCY AISLE LIGHTS INOP AT SEAT 9. R&R BATTERY PACK IAW AMM.SDR SWAA2019092637231Light · inoperativeLT EMERGENCY LIGHT INOP AT ROW 14. FOUND CONNECT ON UNPLUG ABOVE CEILING AND LIGHT ASSEMBLY BROKEN. R&R LIGHT ASSEMBLY AND CONNECTED PLUG IAW MM.SDR SWAA2019092637229Light · inoperativeAFT L2 DOOR SLIDE EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019092637223Battery Pack · dischargedLT EMERGENCY OVERWING GROUND ILLUMINATION LIGHT L547S INOP. R&R BATTERY PACK IAW AMM.SDR DALA2019092605515Cover · missing(LOG 58896545) DURING INSPECTION FOUND 2L DOOR EXIT SIGN COVER MISSING. INSTALLED COVER. OK FOR SVC.SDR SIMA20190925002Battery · discharged#3 EMER LIGHT BATTERY IS INOP. C/A-RAR # 3 EMER LIGHT BATTERY AND CHARGER IAW AMM 33-50-04 OPC GOOD.SDR FDEA201909252338Lens · detachedPOST-FLT INSP, L-1 DOOR FWD EMERGENCY EXIT LIGHT LENS DETACHED. RE-INSTALLED EMERGENCY EXIT LIGHT LENS ASSY, REF AMM: 33-50-00-2. LIGHTS TEST SATIS, ITEM OK FOR SVC.SDR DALA2019092505588Power Supply · inoperativeSHIP 5654 ON SERVICE CHECK FOUND SEAT 27-32 EMERGENCY LIGHTS INOP. CORRECTIVE ACTION: REPLACED POWER SUPPLY M10568 IAW B757 AMM 33-51 OPS CHECKS GOOD. (6245908)SDR DALA2019092505581Power Supply · inoperative(AIRCRAFT 6700, L/P 6246020) DURING SVC CHK FOUND EMERGENCY PATH LIGHTS FROM PAX SEAT 27 TO 32 INOP. CORRECTIVE ACTION: REMOVED AND REPLACED POWER SUPPLY IN ACCORDANCE WITH B757 AMM 33-51. EMERGENCY PATH LIGHTS OPS CHECKS GOOD IAW B757 AMM 33-51.A/C OK FOR SERSDR CALA2019092701640Charger · failedEMERGENCY AREA LIGHT DOES NOT TURN ON DOOR 5R CONFIRMED POWER SUPPLY (M33409) IN FAULT. REPLACED POWER SUPPLY IAW AMM 33-51-06. EMERGENCY LIGHT TEST OK.SDR CALA2019092701637Light · looseEXIT ROW FLOOR LIGHTING STRIPS AT SEATS 21 DEF IS LOOSE AND OUT OF TRACKS. REPLACED CROSS ISLE LIGHT STRIP AND OPS CHECKED OK REF AMM 33-51-501.. ALSO BATTERY PACK REPLACED..SDR ASAA2019092430825Battery Pack · failedEMERGENCY LIGHT SYSTEM OPERATIONAL TEST WITH COCKPIT SWITCH FAILED FOR FORWARD RIGHT SIDE GROUNDED - YES. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1676 S/N 64177 AND PERFORMED SUCCESSFUL SYSTEM OP CHECK IAW B737-800 AMM 33-51-06-960-806.SDR SWAA2019092637248Light · inoperativeRT OVER WING LOCATOR EMERGENCY EXIT SIGN BULB INOP. RELAMPED SIGN PER AMM.SDR SWAA2019092637247Light · inoperativeRT OVER WING WINDOW EMERGENCY EXIT LIGHT HAD ONE BULB INOP. RELAMPED LIGHT PER AMM.
Back to JASC 3350