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 IPXA2019080545319Battery Pack · no testEMER LT BAT 1 LO MSG DURING PREFLIGHT TEST. R & R EMERGENCY LIGHTING BATTERY POWER SUPPLY IAW MM 33-51-01, OPS CHECKED GOOD.SDR VNAA2019100181103Battery Pack · inoperativeEXIT ROW BOTTOM EMERGENCY LIGHT ONLY COMES ON BREIFLY A/C RIGHT. R&R EMERGENCY BATTERY PACK & CHARGING ASSY IAW CRJ 700 AMM 33-51-17-000/400-802-A01 (CHARGING UNIT) / 33-51-000/400-801 CONFIG A01. OPS CHECK GOOD AT THIS TIME.SDR QXEA2019080900312Light · delaminatedFLOOR EMERGENCY LIGHT STRIP DELAMINATED. REMOVED AND REPLACED THE LIGHT STRIP IAW AMM 33-51-16-400-801.SDR REXA2019080631174Bulb · inoperativeLT FWD EXTERIOR E-LIGHT OUT. R/R LT FWD EXTERIOR EMERGENCY LIGHT BULB IAW AMM 33-51-15.SDR U2RA2019080630002Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT LEFT HAND AFT OVERWING EXIT DOOR - RELAMPED PER AIRCRAFT MAINTENANCE MANUAL 33-51-00, OPS NORMAL.SDR U2RA2019080630001Lamp · inoperativeEMERGENCY EGRESS LIGHT INOPERATIVE AT SEAT ROW 19 - RELAMPED PER AIRCRAFT MAINTENANCE MANUAL 33-51-11, OPS NORMAL.SDR SWAA2019080635633Lens · detachedEMERGENCY LIGHT LENS COVER FELL OFF. INSTALLED COVER PER AMM.SDR AALA201908059023Battery · no testAIRCRAFT WAS NOT GROUNDED: EPSU 15WL FAILED BITE TEST. MAINTENANCE REPLACED EPSU BATTERY PER AMM 33-51-38.SDR AALA201908059008Cover · missingAIRCRAFT WAS GROUNDED: AFT SERVICE, DOOR EMERGENCY EXIT LIGHT COVER MISSING. MAINTENANCE REPLACED LIGHT COVER PER AMM 33-51-01.SDR AALA2019080549004Lens · missingAIRCRAFT WAS NOT GROUNDED: LAVATORY D EMERGENCY LIGHT LENS WAS MISSING. MAINTENANCE REPLACED LIGHT LENS PER AMM 33-24-12.SDR AALA2019080549002Lens · damagedAIRCRAFT WAS NOT GROUNDED: DOOR 1R PATH LIGHT ABOVE DOOR LENS DAMAGED. MAINTENANCE REPLACED DOOR PATH LIGHT PER AMM 33-51-16-400-001-A PROCEDURE 4.B STEP (5).SDR SWAA2019080535566Cover · brokenOVERHEAD MID CABIN EMERGENCY EXIT LIGHT TRIM BROKEN. INSTALLED EXIT SIGN ACCESS COVER PER AMM.SDR VNAA201909301101Battery Pack · dischargedEMERGENCY LIGHTS WONT TURN ON. R&R AVIONICS COMP EMERGENCY LIGHT BATTERY PACKS IAW CRJ 200 AMM 33-51-04-000/400-801. OPS CHECK GOOD. ALSO REPLACED 3 CABIN EMERGENCY BATTERIES S/N 86001, 107519, 104548SDR AALA2019080539003Cover · brokenAIRCRAFT WAS NOT GROUNDED: LEFT AFT GALLEY EMERGENCY EXIT LIGHT COVER WAS BROKEN. REPLACED LENS COVER PER STANDARD PRACTICES.SDR ASOA2019080725083Battery Pack · inoperativeDURING MX THE MAIN DOOR AND COCKPIT EMERGENCY LIGHTS DID NOT WORK. MX R&R THE #1 EMERGENCY LIGHT BATTERY WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURNED TO SERVICE.SDR ASOA2019080725092Charger · inoperativeDURING MX THE OVERWING EMERGENCY LIGHTS WERE INOP. MX R&R #4 EMERGENCY BATTERY TRAY WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019080635665Battery Pack · inoperativeR1 DOOR EMERGENCY LIGHT INOPERATIVE. / R&R BATTERY PACK M1675 IAW AMM.SDR SWAA2019080635577Battery Pack · inoperativeAFT OF R1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019080635576Battery Pack · inoperativeDOORWAY EMERGENCY LIGHT MODULE INOPERATIVE. R&R BATTERY PACK M1675 IAW AMM.SDR ASAA2019080523295Lamp · inoperativeWHILE PERFORMING T/C 78233008, L1 DOOR EMERGENCY LIGHT INOP. GROUNDED - YES. REMOVED AND REPLACED SLIDE/OVERWING LAMP AT L1 DOOR. REF B737-900 AMM 33-51-04-960-801. OPS CHECKS GOOD.SDR AALA2019080549003Lens · brokenAIRCRAFT WAS NOT GROUNDED: LENS ON ROW 9CBA BROKEN. MAINTENANCE REPLACED LENS PER AMM 33-51-03.SDR AALA2019080539005Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHTS AT L2 (SEE AALA201908039004) FLIGHT ATTENDANT SEAT AND R2 FORWARD FLIGHT ATTENDANT SEAT WOULD NOT TEST. MAINTENANCE REPLACED FLASHLIGHT BATTERY AT R2 PER AMM 25-64-00.SDR AALA2019080539001Screw · looseAIRCRAFT WAS NOT GROUNDED, AFT GALLEY EXIT SIGN CELLING PANEL HAD 2 SCREWS LOOSE. MAINTENANCE SECURED SIGN PER STANDARD PRACTICES.SDR SWAA2019080535635Lamp · inoperativeLEFT EMERGENCY LIGHT ABOVE ROW 12 INOPERATIVE. RELAMPED THE LIGHT IAW AMM.SDR SWAA2019080535575Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SIMA201908052004Bulb · no testDURING PS-1 CHECK FOUND RH FOREWARD EXTERNAL LIGHT INOPERATIVE. R & R THE BULB IAW AMM 33-50-10. OPS CHECKED GOOD.SDR SIMA201908052002Lamp · inoperativeMAIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPAIRED MAIN DOOR EXTERNAL EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR SIMA201908052003Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHT INOPERATIVE. FOUND L1 DOOR EMERGENCY LIGHT INOPERATIVE. R & R EMERGENCY LIGHT PSU 2 IAW AMM 33-50-01. OPS CHECKED GOOD IAW AMM 33-50-00. NO FURTHER DEFECTS NOTED.SDR DALA2019080504563Light · damagedEMERGENCY EXIT SIGN COVER AND BULBS MISSING LOCATION 602. REPLACED EMER EXIT SIGN ASSY PER MD 88 AMM 33-51E.SDR DALA201908054561Battery Pack · inoperativeROWS 1-12, L1 AND R1 EMERGENCY LIGHTS INOP. R/R BATTERIES AT B5-23. REF MD88 AMM 33-53, CK GOOD.SDR CALA2019080401303Lamp · inoperativeAFT THRESHOLD LIGHT ON FWD RH EMERGENCY EXIT DOOR AT ROW 20 IS INOP RELAMPED, OP CHECKS GOOD REF AMM TASK 33-51-00-710-801SDR AALA201908029008Sign · missingAIRCRAFT WAS NOT GROUNDED: DOOR 3R AFT VERTICAL EMERGENCY EXIT SIGN MISSING. MAINTENANCE REPLACED EXIT LENS PER AMM 33-51-01.SDR DALA2019080624630Lens · damagedROW 27 IN AISLE EMERGENCY EXIT SIGN MISSING COVER. R & R THE DAMAGED EMERGENCY EXIT SIGN COVER ON OVERHEAD EXIT SIGN.SDR DALA2019080624613Light · damagedSHIP 3831 EMERGENCY LIGHT DAMAGED AT SEAT 20D .CORRECTIVE ACTION: SECURED EMERGENCY LIGHT OPS GOOD (6049934).SDR SWAA2019080635596Sign · brokenEXIT SIGN AT FORWARD LAV BROKEN AT LOWER SCREW. / INSTALLED SIGN PER SOPM.SDR ASAA2019080513297Battery Pack · dischargedEMERGENCY LIGHT FORWARD CABIN EMERGENCY LIGHTS AT CENTER AISLE EXIT SIGN, L-1 DOOR EXIT SIGN, L-1 DOOR EXIT LOCATOR SIGN, AND L-1 DOOR EXTERIOR SLIDE LIGHT ARE INOP. GROUNDED - YES. REFERENCE B737-800 SSM 33-51-12-106 - REMOVED, REPLACED, AND TESTED BATTERY PASDR ASAA2019080513296Sign · broken17F EXIT SIGN COVER BROKEN OFF. GROUNDED - YES. REMOVED AND REPLACED COVER ASSY. OK FOR SERVICE.SDR SWAA2019080535664Battery Pack · inoperativeFORWARD CABIN EMERGENCY LIGHTS INOP AT LOCATION M2816. R&R BATTERY PACK IAW AMM.SDR SWAA2019080535570Battery Pack · inoperativeFORWARD CABIN EMERGENCY LIGHTS INOP AT LOCATION M1475. R&R BATTERY PACK IAW AMM.SDR YENA2019080510432Lens · missingFT # 272, EMERGENCY FLOOR LIGHTING ROW 1 C LENS MISSING, HOUSING DETACHED FROM BASE. INSTALLED NEW CLEAR EMERGENCY LIGHT LENS IAW 36-50-00. OPS CHECKED OK.SDR YENA2019080510431Battery Pack · no testFT # 225, EMERGENCY LIGHT TEST FAILED FOR FIN# 13WL BATTERY. REMOVED AND REPLACED AFT EPSU BATTERY AT 13WL IAW AMM 33-51-38.SDR IPXA2019080215236Power Supply · inoperativeDURING PREFLIGHT, EMERGENCY LIGHT BATTERY 1 LOW ILLUMINATED DURING EMERGENCY LIGHTS TEST. R & R EMERGENCY LIGHTS POWER SUPPLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR CALA2019080431294Power Supply · no testREMOVE AND REPLACE THE CABIN EMERGENCY LIGHT POWE R SUPPLY. CHANGED DUE TO A FAILED BIT E TEST. REMOVED AND REPLACED THE CABIN EMERGENCY LIGHT POWER SUPPLY.SDR CALA2019080301293Battery · no testTHE EMERGENCY LIGHT TEST AT THE PTP FAILS WITH TH E MESSAGE EPSU BATTERY FWD. REMOVED AND REPLACED FWD LT BATTERY OF THE EPSU IAW AMM 33- 51-38-400-002-A.SDR CALA2019080431292Battery Pack · no test(SUPPORT TASK) THE EMERGENCY LIGHT TEST AT THE PTP FAILS WITH TH E MESSAGE ''EPSU BATTERY EMER R? ATA 33-51-38. REFER TO AAR N/R: 9620608. REMOVED AND REPLACED RH BATTERY OF THE EPSU IAW A319 AMM 33-51-3 8-000-002-A AND 31-51-38-400-002-A. OPS CHECK COMPLIED WSDR AALA201908029006Battery Pack · no testAIRCRAFT WAS GROUNDED: UPON PRE-FLIGHT, FOUND THAT EMERGENCY EXIT LIGHTS ON THE OVERHEAD PANEL WOULD NOT ILLUMINATE DURING POWER CHANGES OR WITH THE EMERGENCY LIGHT SWITCH IN THE ON POSITION. MAINTENANCE FOUND BATTERY PACK B5-103 BAD AND REPLACED BATTERY PACK SDR AALA201908029005Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN FELL OFF LEFT 2ND EXIT DOOR. MAINTENANCE REINSTALLED EXIT SIGN PER AMM 33-51-01.SDR AALA201908029003Power Supply · no testAIRCRAFT WAS NOT GROUNDED: DURING COMPLIANCE OF JOBCARD 26C00033004, FOUND EMERGENCY POWER SUPPLY UNIT AT L3 DOOR FAULT. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38.SDR IPXA2019080245243Lamp · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-169-62-001. OPS CHECKED GOOD.SDR SWAA2019080235559Battery Pack · inoperativeR/H EMERGENCY OVERWING ESCAPE GROUND LIGHT INOP. R&R BATTERY PACK IAW AMM.
Back to JASC 3350