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 SWAA2021090213404Lens · brokenR/H OVERWING EXIT INDICATOR LENS BOTTOM FWD BROKEN ; / [01] R/R OVERWING EXIT INDICATOR LENS BOTTOM FWD PER AMM 33-51-01. OPS CHK GOOD.SDR SWAA2021090213317Battery Pack · no testFWD GALLEY RH LOWER EMERGENCY LIGHT AND EXTERIOR EMERGENCY LIGHT JUST AFT OF FWD SERVICE DOOR WILL NOT ILLUMINATE DURING TEST. ; / [01] REMOVED AND REPLACED FAILED BATTERY PACK M1674 PER AMM 33-51-06. EMERGENCY LIGHTS NOW OPS CHECK GOOD.SDR ASAA2021083035837Cover · damagedEXIT/SALIDA LIGHT COVER IN FWD GALLEY BY R1 DOOR CAME OFF. GROUNDED - YES. REPLACED R1 E LIGHT COVER IN REF TO B737-800 AMM 33-51-01. OK FOR SERVICE.SDR AALA202109010855Shroud · looseAIRCRAFT WAS NOT GROUNDED: PASSENGER SEAT EMERGENCY LIGHT PATH LOOSE 33C. INSTALLED 33C SEAT EMERGENCY LIGHT SHROUD CORRECTLY PER CMM 25-23-67.SDR JJBA2021090130074Battery Pack · inoperativeEMERGENCY LIGHT BY 3C INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY #2. OPS CHECK SAT.SDR AALA202108318298Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT BATTERY INOPERATIVE AT 11WL. REPLACED EMERGENCY POWER SUPPLY BATTERY AT 11WL.SDR AALA202108315943Battery · faultedAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY POWER SUPPLY UNIT (14WL) FAULT DURING CABIN INTERCOMMUNICATION DATA SYSTEM TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT (14WL) BATTERY PER AMM 33-51-38.SDR AALA202108314524Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT 26C INOPERATIVE. REMOVED AND REPLACED LIGHT.SDR AALA202108312153Battery · faultedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERY FAULTS AT FORWARD LEFT (10WL). REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY AT 10WL PER AMM 33-51-38.SDR AALA202108315659Battery · faultedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERY FAULTS AT MID RIGHT (14WL). REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY AT 14WL PER AMM 33-51-38.SDR HALA2021083100124Lens · missingSHIP 389 DURING SVC CK FOUND CABIN EMERGENCY LIGHT ABOVE LAV 54 MISSING LIGHT LENS. CORRECTIVE ACTION: INSTALLED NEW SERVICEABLE LIGHT LENS. (7736331)SDR IPXA2021083173349Battery Pack · no testINSPECTION TYPE:N/AEMERGENCY LTS FAILED TESTR/R'D EMERGENCY LT BATT PACK IAW AMM 33-51-07-902-001 . TEST NORMALSDR MASA2021083000213Flashlight Assy · inoperativeFO'S FLASHLIGHT INDICATOR NOT FLASHING. REPLACED FLASHLIGHT.SDR CALA2021083001459Shroud · looseCOACH SEATS 20C AND 21D AISLE ENDCAP EPL SHROUDS ARE LOOSE. SECURED AISLE ENDCAPS ON SEATS 20C AND 21D, IAW CMM 25-22-69.SDR SWAA2021100512733Light · deterioratedDETERIORATED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN (8 EA) ; 2021-393044 / [01] REPLACED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN (8 EA) THE INSTALATION ARE DOCUMENT ON TTG8Q003FBV8; [02] CORRECTED STEP 1 : REMOVED ANDSDR REXA2021091000731Charger · inoperativeAFT EXTERIOR EMER LIGHTS STAY ON CONSTANTLY, RH ESCAPE HATCH DOOR EMER LIGHTS DO NOT ILLUMINATE. REMOVED AND REPLACED PS 43 BATTERY CHARGER ASSEMBLY. OP CHECKS GOOD ALL WORK DONE IAW CRJ900 AMM 33-51-17SDR AALA202109049520Lens · missingAIRCRAFT WAS NOT GROUNDED: CENTER AISLE OVER WING EXIT SIGN MISSING CLOSE OUT PANEL. **SUPPLEMENTAL REPORT FOR AALA202108319520: REPLACED MISSING COVER PER AMM 33-51-0** (CLOSED)SDR SWAA2021090213277Light · inoperative#1 EMERGENCY EXIT LIGHT INOP OVERWING SIDEWALL LIGHT. OK TO CONT PER MEL 33-2-03 SP1B. REMOVED AND REPLACED LH EMERG EXIT LIGHT FUSE ASSY IAW AMM 33-51-06 OPS CHECK GOOD.SDR DALA2021090105172Sign · detachedSHIP 6818 EXIT SIGN ABOVE THE 2R DOOR COMPLETELY FELL OFF. CORRECTIVE ACTION: SECURED EXIT SIGN. (7914027)SDR DXTA2021083047910Light · brokenLAV EMERG LIGHT: EVACUATION PATH LIGHTING STRIP UNDER SEAT 10 HAS COME LOSE AND IS BROKEN ON RIGHT SIDE. LEFT SIDE OF STRIP STILL HAS POWER AND LIGHTS. THE RIGHT SIDE IS INOP. VERIFIED THE WRITE-UP AND THAT THE WRITE-UP IS FOR SEAT #9, NOT SEAT #10. PERFORMSDR DALA2021090105155Housing · damagedSHIP 1605 EMERGENCY EXIT LGITH AT L1 DOOR HAS DAMAGE HOUSING. CORRECTIVE ACTION; REMOVED EMERGENCY SLIDE LIGHT HOLDER AT L1 DOOR AND STRAIGHTENED HOUSING THEN REINSTALLED. SYSTEM OPERATION IS NORMAL. (LP7327065)SDR AALA202108319520Sign · missingAIRCRAFT WAS NOT GROUNDED: CENTER AISLE OVER WING EXIT SIGN MISSING CLOSE OUT PANEL. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108314906Lens · looseAIRCRAFT WAS NOT GROUNDED: SEAT 32C EMERGENCY PATH WAY LIGHT LENS LOOSE, WILL NOT STAY SECURE IN POSITION. SECURED LIGHT HOUSING ASSEMBLY PER CMM 25-21-63.SDR REXA2021083000649Battery · inoperativeEMERGENCY LIGHTS (ALL) WILL NOT ILLUMINATE. REMOVED AND REPLACED ALL EMERGENCY BATTERY IAW CRJ200 AMM 33-51-04. OPS CHECKS GOOD.
"SDR AALA202108308403Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHT MISSING LENS AT 1L CLOSET DOOR JAMB. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-05-201-960-802, OPS CHECK GOOD.SDR AALA202108308442Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD LEFT CABIN EMERGENCY POWER SUPPLY INOPERATIVE. REMOVED AND REPLACED FORWARD CABIN EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38.SDR AALA202108301324Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT 10C FELL OFF SEAT. REINSTALLED LIGHT ASSEMBLY PER AMM 33-51-19-0401.SDR AALA202108305472Power Supply · failedAIRCRAFT WAS NOT GROUNDED: PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHTS PER JOB CARD 26L00005005, TEST FAILED, AFT LEFT EMERGENCY POWER SUPPLY UNIT FAULT. REMOVED FAULTY EMERGENCY POWER SUPPLY UNIT 13WL FROM AFT GALLEY CEILING AND INSTALLED NEW EMERGENCY POWSDR AALA202108305441Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT INOPERATIVE AT AFT RIGHT DOOR EXIT SIGN. REPLACED LIGHT BULBS PER AMM 33-50-00.SDR QXEA2021083000423Spacer · damagedFWD FA SEAT LOWER EXIT SIGN BRACKET S/N: N/A REQUIRES ROBBING. (SPACER ASSEMBLY) P/N: 171-41200-405. REMOVED FROM SERVICE. REMOVED EXIT SIGN SPACER ASSEMBLY P/N: 171-41200-405. INSTALLED EXIT SIGN SPACER ASSY P/N: 171-41200-405. AIRCRAFT RETURNED TO SERVICE.SDR SIMA20210829003Battery Pack · inoperativeLOWER FWD PAX DOOR EREMGENCY EXIT LIGHT WILL NOT ILLUMINATE.-C/A-RAR #2 EMERGENCY BATTERY IAW AMM 33-50-01. OPS CHECK GOOD.SDR MASA2021082900212Lamp · inoperativeROW 3 CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWAA2021090112919Light · intermittentEXIT LIGHT 14F FLICKERING /SDR R61A2021083100682Power Supply · inoperativeEMERGENCY LIGHT BATTERY FAULT. R&R FWD RH SIDE EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR AALA202108311669Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FOUND MAINTENANCE MESSAGE 33-11408, WELS CONTROL UNIT #8 BATTERY DEGRADED. REPLACED BATTERY PER AMM 33-51-07.SDR AALA202108307384Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 30C EMERGENCY LIGHT FELL OFF. RE SECURED EMERGENCY LIGHT LENS AT SEAT 30C.SDR AALA202108308888Slide · no testAIRCRAFT WAS GROUNDED: WHILE PERFORMING EMERGENCY POWER SUPPLY UNIT BATTERY TEST PER JOB CARD 26L00005005, ESCAPE SLIDE LIGHT 13WL AT DOOR 4L FOUND FAULTED VIA CLASS 1 MESSAGE. REMOVED AND REPLACED L4 DOOR ESCAPE SLIDE PER JOB CARD 26L00025010.SDR QXEA2021083000422Spacer · damagedEXIT SIGN NEXT TO BROKEN FWD FA SEAT BROKEN. REMOVED FROM SERVICE. R+R EXIT SIGN BRACKET NEXT TO FWD FA SEAT, AS NEEDED. NO FURTHER DEFECTS NOTED. OPS TEST NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR SIMA202108298001Inverter · inoperativeSEAT 12A EMERGENCY EXIT PLACARD INOP-C/A-T/S IAW FIM TASK 33-50-00-810-804-A. RAR EMERGENCY LIGHT DC/AC INVERTER 5 IAW EMB AMM 33-50-11-000-801-A AND 33-50-11-400-801-A OPS CHECK GOODSDR SIMA20210828002Power Supply · inoperativeEMERGENCY LIGHTS ON AFT LH PASSENGER DOOR INOP-C/A-RAR EMERGENCY- LIGHT POWER UNIT #3 IAW 33-50-01. OPC GOOD. NO DEFECTS NOTEDSDR 4TXA2021091000011Battery Pack · dischargedWHILE PERFORMING FUNCTIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM BATTERY PACKS, THE AFT RH EMERGENCY LIGHT BATTERY PACK FAILED. R & R BATTERY PACK.SDR SWAA2021090712630Lamp · missingR/H OVERWING EMERGENCY LIGHT MISSING BULBS. ; / [01] RE-LAMPED R/H OVERWING EMERGENCY LIGHT AND PERFORMED A GOOD OP CHECK ALL AS PER AMM 33-51-03-960-801.; [02] VERIFIED CORRECTIVE ACTION 1SDR FDEA2021083122113Bulb · inoperativeEXTERIOR EMERGENCY LIGHT DOOR 1R INOP. BULB REPLACED ACC AMM 33-51-06-2-1 REV 127.16. OPS TEST SATIS.SDR SWAA2021083112589Lens · brokenFWD ENTRY FLOOR EXIT COVER BROKEN. ; / [01] R&R LIGHT ASSY PER AMM 33-51-00SDR SWAA2021083112268Charger · failedAFT R/H GALLEY EMERGENCY LIGHTS AT SERVICE DOOR DO NOT COME ON DURING TEST. / R&R'D CHARGER BATTERY PACK IAW AMM 33-51-06 OPS CHECK GOODSDR SWAA2021083112272Battery · inoperativeRT OVERWING ESCAPE HATCHES EMERGENCY EXIT LIGHTS INOP / R&R RT OVERWING ESCAPE HATCHES EMERGENCY EXIT LIGHTS BATTERY PER AMM 33-51-06 SEE TSR #2021005350 FOR PART EFFECTIVITYSDR SWAA2021083112271Light · inoperativeEXTERIOR AFT ENTRY DOOR EMERGENCY LIGHT INOP. / RELAMPED EXTERIOR AFT ENTRY DOOR EMERGENCY LIGHT OPS CHECK GOOD REFERENCE AMM 33-51-04SDR AALA202108307324Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: CAPTAIN SIDEWALL MOUNTED FLASHLIGHT INOPERATIVE. REPLACED CAPTAINS FLASHLIGHT BATTERY PER AMM 33-51-19SDR AALA202108309590Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 9C EMERGENCY LIGHT DETACHED. REINSTALLED LIGHT PER AMM 33-50-00.SDR AALA202108303924Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT 13WL IN PASSENGER CABIN FAILED. REPLACED POWER SUPPLY PER AMM 33-51-38-000-001.
Back to JASC 3350