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 SWAA2021061481443Battery Pack · no testAFT BATTERY PACK FAILED TEST (R) M1673 ; / R&R BATTERY PACK AT M 1673 PER AMM 33-51-06.SDR SWAA2021061481442Battery Pack · no testAFT BATTERY PACK FAILED (L) M1672 ; / R&R BATTERY PACK AT M 1672 PER AMM 33-51-06.SDR SWAA2021061481441Battery Pack · no testROW 16 BATTERY PACK FAILED TEST M1670 ; / R AND R'D BATTERY M1670 PER AMM33-51-06SDR SWAA2021061481278Light · missingEMERGENCY LIGHT COVER MISSING BETWEEN ROWS 6 AND 7 DEF (BULLNOSE LIGHT) ( NEF ITEMS LISTED IN MEL APPENDIX 25-10 NON-ESSENTIAL EQUIPMENT & FURNISHINGS (NEF) ) / R/R'D EAL ASSY IAW AMM 33-51-03. OPS CHECKS GOOD CLEARS DML CL #89695SDR SWAA2021061481585Lens · missingFORWARD SERVICE DOOR EMERGENCY LEFT HAND SIDE WAIST HIGH COVER MISSING / INSTALLED NEW EMERGENCY EXIT LIGHT LENS AT FWD SERVICE DOOR PER SIP. LT CHKS GOOD; A/C OKAY FOR SERVICECNTRCT AMT: 4299622SDR AALA202106099013Light · damagedAIRCRAFT WAS NOT GROUNDED: SIDEWALL GALLEY EMERGENCY LIGHT DAMAGED. SECURED SIDEWALL GALLEY LIGHT AT G3 GALLEY IAW AMM 33-51-05, OPS CHECK GOOD.SDR DALA2021061103190Battery Pack · dischargedSHIP 679 AIRPLANE WAS DEPOWERED + EMERGENCY LIGHTS WERE ARMED + ONE SECTION OF EMERGENCY LIGHTS WERE ILLUMINATED. ONCE PWR WAS SUPPLIED TO AIRPLANEWE CHECKED EMER LIGHTS THEY ILLUMINATED FOR NO MORE THAN 15 SEC. CORRECTIVE ACTION: CHARGED THE POWER SUPPLY BATTSDR DALA2021061103188Lens · damagedSHIP 5649 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS: 2R. CORRECTIVE ACTION: RE-SECURED EM. EXIT COVER AS REQ. OPS GOOD. (1835025)SDR JJBA20210609017Button · crackedFA CABIN EMERGENCY LIGHT BUTTON ON. RE-RERACKED FWD & AFT FA HANDSETS. OPS CHECK GOOD AT THIS TIME. NO DEFECTS NOTED.SDR AALA202106109004Lens · detachedAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY DOOR EMERGENCY EXIT SIGN FELL OFF ON LANDING. RE SECURED LENS AND PERFORMED OPERATIONS CHECK OF LIGHT PER AMM 33-51-00.SDR SIMA20210609001Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP-C/A-RAR SERVICE DOOR EMERGENCY LIGHT LAMP IN REFERENCE WITH EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. END.SDR DALA2021060903153Sign · detachedSHIP 687 EXIT SIGN ABOVE DOOR 2R FELL OFF. CORRECTIVE ACTION: RE INSTALLED OVER HEAD EXIT SIGN OK FOR SVC REF B757 AMM 52-13. (4268016)SDR AALA202106099003Power Supply · no testAIRCRAFT WAS NOT GROUNDED: 15WL EMERGENCY POWER SUPPLY UNIT FAILED TEST. REMOVED AND REPLACED 15WL EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38.SDR SWAA2021061881198Battery Pack · inoperativeAFT GALLEY RIGHT SIDE EMERGENCY EXIT SIGN INOP. ; / REMOVED AND REPLACED FUSE ON M1672 BATTERY PACK AND PERFORMED AFT GALLEY RIGHT SIDE EMERGENCY EXIT SIGN TEST.CHECKED NORMAL.PER B737 AMM 33-51-06; VERIFIED R/R OF FUSE AND OPS TESTSDR SWAA2021061881197Fuse · failedL2 EMERGENCY LIGHT EXIT SIGN INOP. ; / REMOVED AND REPLACED FUSE ON M1672 BATTERY PACK ON WORK CARD TTG8Q005D5WT AND PERFORMED L2 EMERGENCY LIGHT EXIT SIGN TEST.CHECKED NORMAL.PER B737 AMM 33-51-06; VERIFIED R/R OF FUSE AND OPS TESTSDR SWAA2021061781251Light · deterioratedPHOTO LUMINESCENT STRIPS AT L/H STA 342 -376 & R/H STA 328-346 ARE DETERIORATED AND UNSERVICEABLE. ; / THE PHOTO LUMINESCENT STRIPS TO BE REPLACED ON TASK CARD TTG8Q002RAAG.; CORRECTIVE ACTION IN LINE 1 IS WRITTEN IN ERROR. THE PHOTO LUMINESCENT STRIPS TO BE RSDR SWAA2021061681250Light · deterioratedPHOTO LUMINESCENT STRIPS BOTH L/H & R/H STA 520 -737B ARE DETERIORATED AND UNSERVICEABLE. INSTALLED PER TASK CARD 733-080-00-01. TTG8Q002RA7H;INSTALLED PER TASK CARD 733-080-00-01. TTG8Q002RA7H. C/W INSPECTION.SDR SWAA2021061581179Light · looseFDR DOOR; EMERGENCY EXIT LIGHT ASSEMBLY IS SECURED BY ONLY 1 FASTENER. ; / REMOVED AND REPLACED AFT EMERGENCY EXIT LIGHT IAW AMM 33-51-01-960-801; OPS CHECK GOOD; COMPLETED INSPECTION CARD STEPS 1. AND 2. CORRECT REF IS AMM 33-51-01-960-802.<BR>AUDIT C/WSDR IPXA2021060870293Battery Pack · inoperativeEMERGENCY LIGHTING IN COURIER AREA REMAINS PARTIALLY ILLUMINATED WITH EMERGENCY LIGHT. TEST PASSED ANE WITHOUT INDICATION EAD. DEFERRED EMERGENCY LIGHTS PER MEL 33-50-4 DMP C/W PLACARD INSTALLED.R/R'D EMERGENCY BATTERY PWR SUPPLY PER MM 33-51-01 PG BLK 401.SDR SWAA2021061481327Lens · looseR/H OVERWING EXIT EMERGENCY LIGHT LENS LOOSE. ; / SECURED LENS IAW AMM 33-51-01.SDR SWAA2021061481122Sign · missingFWD ENTRY DOOR LOWER EMERGENCY LIGHT LENS MISSING DIRECTIONAL ARROW / REMOVED AND REPLACED SIGN IAW AMM 33-51-01; INSPECTEDSDR AALA202106099009Lens · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER IS LOOSE AND HANGING DOWN NEAR SEAT 20C. REPLACED EXIT LIGHT COVER IAW CMM 25-23-67, OPS CHECK GOOD.SDR N6WA2021060801Lamp · inoperativeEMERGENCY LIGHT AFT CEILING INOP. RELAMPED EMERGENCY LIGHT AFT CEILING IAW CRJ 550 AMM 33-51-09 OPS CHECK GOOD AT THIS TIME.SDR DALA2021061003173Lamp · no testSHIP 3137 - DURING CHK, FAILED EMERG LIGHT TEST, EPSU EXT LOAD EMER R CORRECTIVE ACTION: RELAMPED RIGHT EXTERIOR EMERG EXIT LIGHT AT OVERWING SLIDE PER A319 AMM 33-50. CKS OK. (7317906)SDR ASAA2021060835057Lens · missingF/A REPORTED 16A EMERGENCY EXIT SIGN LENS MISSING. GROUNDED - YES. REPLACED W/NEW EMERGENCY EXIT SIGN LENS AND OK FOR SVC.SDR HALA2021060900066Lamp · inoperativeMAIN DOOR (1L) EXIT SIGN LIGHT INOP. RELAMPED DOOR 1L EXIT SIGN LIGHT. LIGHT OPS CHK OK.SDR AALA202106099012Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT PLACARD ABOVE SEAT 16C FELL OFF. REINSTALLED EMERGENCY EXIT LIGHT ASSEMBLY AT 16C, PER AMM 33-51-00.SDR AALA202106099002Battery · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT TEST FAILED 15WL BATTERY. REMOVED AND REPLACED MID LEFT EMERGENCY POWER SUPPLY UNIT TEST (15WL) BATTERY PER AMM 33-51-38.SDR AALA202106099010Light · detachedAIRCRAFT WAS NOT GROUNDED: OVER WING EMERGENCY EXIT LIGHT WAS KNOCKED OFF THE CEILING WHEN PASSENGER REMOVED BAG FROM OVERHEAD BIN. RESECURED EMERGENCY EXIT LIGHT TO CEILING PER AMM 33-51-00.SDR FDEA202106081474Battery Pack · warning messageEMER LT. BAT 1 LO ALERT ON. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY. ALL TEST PASSED AND ALERT WENT AWAYSDR DALA2021060903141Light · looseSHIP 3236 EMERG LIGHT TRACK LIGHT LOOSE AT SEAT 17D. CORRECTIVE ACTION: SECURED EMER LIGHT PER A320 AMM 33-52. OK FOR SERVICE. (7632693)SDR SIMA20210608001Charger · inoperativeBOTH OVERWING EMERGENCY LIGHTS INOP-C/A-RAR #4 BATTERY AND CHARGER ASSEMBLY IAW EMB 145 AMM 33-50-04. OPS CHECK GOOD.SDR AALA202106089002Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD EMERGENCY POWER SUPPLY UNIT INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT.SDR AALA202106089001Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWAD EMERGENCY LIGHTS INOPERATIVE. REPLACED FORWARD BATTERY PER AMM 33-51-38-400-002-A.SDR DXTA2021060843400Battery Pack · dischargedEMERGENCY LIGHTING: DURING PREFLIGHT, EMER LTS SWITCH TO ON, NO EMERGENCY LIGHTS INTERIOR OR EXTERIOR CAME ON. HOOKED UP POWER CART TO AC AND LET THE EMERGENCY BATTERIES CHARGE UP FOR AN EXTENDED PERIOD OF TIME. PREFORMED OPERATIONAL CHECK OF THE EMERGENCY LIGSDR 2021060743370Unknown · unknownEMERG LIGHT SWITCH: WITH EMER LTS SWITCH IN ARM POSITION NO EMER LIGHTS ILLUMINATE. EMER LIGHTS DO ILLUMINATE
IN THE ON POSITION.SDR SWAA2021072680658Lens · brokenBROKEN EMERGENCY LIGHT LENS ON BINES LH SIDE AT PASSENGER CABIN (9 EA) ; 2021-269500 / [01] REPLACED EMERGENCY LIGHT LENS ON BINES LH SIDE AT PASSENGER CABIN (9 EA) IAW B737-700 AMM 33-51-03-960-802; [02] REPLACED EMERGENCY LIGHT LENS ON BINES LH SIDE AT PASSESDR SWAA2021072680652Lens · brokenBROKEN EMERGENCY LIGHT LENS ON BINES RH SIDE AT PASSENGER CABIN (8 EA) ; 2021-269501 / [01] REPLACED EMERGENCY LIGHT LENS ON BINES RH SIDE AT PASSENGER CABIN (8 EA) IAW B737-700 AMM 33-51-03-960-801 STEP 2D(1)(C); [02] REPLACED EMERGENCY LIGHT LENS ON BINES RHSDR SWAA2021061680634Battery Pack · no testEMERGENCY BATTERY PACK M1674 FAILED OPERATIONAL TEST. ; / REMOVED AND REPLACED EMERGENCY BATTERY PACK (M1674) PER B737 AMM 33-51-06-960-805. PERFORMED INSTALLATION TEST PER B737 AMM 33-51-06-960-805 AND TESTED NORMAL.; VERIFIED 1.SDR IPXA2021060870276Power Supply · inoperativeEMERG LIGHT SYST INOP. DFRD PER MEL 33-50-4 M FUNCTION C/W DMP C/W.R/R'D POWER SUPPLY EMERGENCY LIGHT BATTERY IAW MM 33-51-01. OPS CHECK GOOD.SDR WX0A2021061173735Battery Pack · no testEPSU BATTERY FAILED MCDU TEST (FIN 10WL) / REMOVED AND REPLACED EPSU BATTERY(FIN 10WL) IAW AMM 33-51-38-000-002-A/33-51-38-400-002-A; OP'S CHECK GOOD"SDR SWAA2021061180926Sign · detachedMID CABIN EXIT SIGN FELL DOWN / REINSTALLED EXIT SIGN ASSY PER M/M 33-51-01SDR SWAA2021061180800Bracket · damagedAFT ENTERY AREA UPPER EMERGENCY LIGHT BRACKET DAMAGED ; / REMOVED AND REPLACED AFT ENTRY AREA UPPER EMERGENCY LIGHT ASPER B737-700 AMM 33-51-01; VERIFIED; STEP # 1SDR SWAA2021061180799Light · damagedFWD ENTERY AREA UPPER EMERGENCY LIGHT DAMAGED ; / REMOVED AND REPLACED FWD ENTERY AREA UPPER EMERGENCY LIGHT ASPER B737-700 AMM 33-51-01; VERIFIED; STEP # 1.SDR SWAA2021061180733Lamp · inoperativeAFT MOST EMERGENCY LIGHT ON R/H SIDE OF FUSELAGE INOP ; / RELAMPED AFT MOST EMERGENCY LIGHT ON RIGHT SIDE OF FUSELAGE. OPS CK GOOD. PER AMM 33-51-04SDR SWAA2021061180732Lens · brokenRIGHT WING EMERGENCY EXIT LIGHT LENS BROKE ; / REPLACED RIGHT WING EMERGENCY EXIT LENS PER AMM 33-51-01SDR SWAA2021061180643Lens · detachedAFT GALLEY CENTER EXIT SIGN FELL OFF. ; / RESECURED EXIT SIGN LENS IAW SIP.SDR SIMA20210607001Flashlight · inoperativeAFT FA EMERGENCY FLASHLIGHT INOP. R & R AFT FA'S FLASH LIGHT IAW EMB 145 AMM 33-50-16. OPERATIONAL CHECK GOOD.MEL RESTORED.SDR DALA2021061003178Light · inoperativeSHIP 1705 EMERGENCY CEILING LIGHTS AT 16N ARE INOPERATIVE. CORRECTIVE ACTION: REPLACED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL. (LP 7624643)SDR DALA2021061003175Lens · missingSHIP 197 (2) CLEAR EMERGENCY LIGHT LENSES ON THE AISLE ACROSS FROM SEAT 1B, 1C AND 1 RED LENS ON THE AISLE BY FORWARD RIGHT LAV ARE MISSING. CORRECTIVE ACTION: LENSES REPLACED. (LP 7347842)
Back to JASC 3350