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 R61A202002142186Light · wornPHOTOLUMINESCENT INDICATOR STRIPS WORN AT ROW 1 AND IN FRONT OF WARDROBE. R&R PHOTOLUMINESCENT STRIPS PER AMM 33-50-21.SDR DALA2020021431156Sign · detachedSHIP 676 OVER WING EXIT SIGN KNOCKED OFF. SIGN OVER AISLE. CORRECTIVE ACTION: RE-INSTALLED EXIT SIGN COVERS. (6490119)SDR DALA2020021431155Lens · missingSHIP 6815 L2 EMERGENCY LT LENS MISSING. CORRECTIVE ACTION: INSTALLED L2 EMERGENCY LT LENS. (6225660)SDR AALA202002139007Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: INOPERABLE EMERGENCY POWER SUUPLY UNIT 11WL IN PASSENGER CABIN. REPLACED EMERGENCY POWER SUPPLY UNIT 11WL PER AMM 33-51-00-710-001-A.SDR AALA202002139004Sign · detachedAIRCRAFT WAS GROUNDED: 4A EXIT SIGN WAS FALLING. MAINTENANCE FOUND IT TO BE 2A ISLE EXIT SIGN LIGHT AND REPLACED LIGHT ASSEMBLY AT 2A PER AMM 33-51-1.SDR AALA202002139013Light · brokenAIRCRAFT NOT GROUNDED: EXIT SIGN AT 2L DOOR LENS BROKEN. REPLACED EXIT SIGN AT 2L DOOR IAW AMM 33-51-01.SDR SWAA2020021341375Light · unsecureFORWARD R/H SIDE AISLE PHOTOLUMINESCENT STRIP NOT SECURED. / SECURED PHOTOLUMINESCENT STRIP PER SIP.SDR MASA2020021200062Bulb · inoperativeROW 18 CEILING LEVEL FLOOD LIGHT INOP. RELAMPED.SDR SWAA2020030342018Lens · brokenFORWARD GALLEY AREA BASE EMERGENCY LENS BROKEN. / R&R BASE EMERGENCY LENS IAW AMM.SDR SWAA2020022841981Lens · brokenBROKEN LAVATORY B BASE EMERGENCY EXIT LIGHT LENS AT AFT GALLEY AREA. / R&R LENS IAW AMM.SDR SWAA2020021941518Housing · brokenAFT ENTRY EMERGENCY EXIT LIGHT HOUSING WAS BROKEN. / R&R LIGHT HOUSING IAW AMM.SDR SWAA2020021741411Lens · looseEXIT ROW EMERGENCY COVER FELL OFF. / REINSTALLED EMERGENCY EXIT CEILING LIGHT COVERS REF M/M 33-51-03.SDR SWAA2020021741399Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. / REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AT LOCATION M1675 PER AMM 33-51-06.SDR YENA2020021710172Battery · failedFT # 766, GCM-JFK. PER BATT CAPACITANCE CK, PERFORMED ALT PROCEDURE IAW W/O 1042318; R & R ALL EPSU BATTS ( 10WL, 11WL, 12WL, 13WL) IAW AMM 33-51-38. BITE TEST OF EPSU'S GOOD IAW AMM 33-51-38.SDR YENA2020021710171Battery · failedFT # 766, GCM-JFK. PER BATT CAPACITANCE CK, PERFORMED ALT PROCEDURE IAW W/O 1042318; R & R ALL EPSU BATTS ( 10WL, 11WL, 12WL, 13WL) IAW AMM 33-51-38. BITE TEST OF EPSU'S GOOD IAW AMM 33-51-38.SDR YENA2020021710170Battery · failedFT # 766, GCM-JFK. PER BATT CAPACITANCE CK, PERFORMED ALT PROCEDURE IAW W/O 1042318; R & R ALL EPSU BATTS ( 10WL, 11WL, 12WL, 13WL) IAW AMM 33-51-38. BITE TEST OF EPSU'S GOOD IAW AMM 33-51-38.SDR YENA2020021710169Battery · no testFT # 766, GCM-JFK. PER BATT CAPACITANCE CK, PERFORMED ALT PROCEDURE IAW W/O 1042318; R & R ALL EPSU BATTS ( 10WL, 11WL, 12WL, 13WL) IAW AMM 33-51-38. BITE TEST OF EPSU'S GOOD IAW AMM 33-51-38.SDR SIMA202002141002Charger · failedEMERGENCY LIGHT AT LH EMERGENCY DOOR IS INOP-C/A-RAR BATTERY POWER SUPPY #3 IAW 33-50-04 AND REMOVED AND REPLACED LH EMERGENCY DOOR EXIT IDENTIFIER SIGN IAW 33-50-13 OPERATIONAL CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1ASMI S/N 73057SDR R61A2020021410187Battery · inoperativeFWD 3 EMERGENCY LIGHTS FLICKER. TROUBLESHOT SYSTEM AND R&R FWD CEILING EMERGENCY LIGHTS BATTERY PACK IAW AMM 33-50-01.SDR DALA2020021421158Lens · missingSHIP 655 SEAT 11 CD OVERHEAD CLEAR EMERGENCY LIGHT LENS MISSING. CORRECTIVE ACTION: INSTALLED NEW LENS AS REQUIRED. (6894459)SDR DALA2020021421149Battery · unsecureSHIP 6714 WHILE WKG JOB CARD 3351-7001 NUMEROUS EMERG INTERIOR LIGHTS IN THE AFT CABIN INOP. CORRECTIVE ACTION: SECURED BATTERY AT POWER SUPPLY RACK M737. RETEST EMERG LIGHT OPS CKS GOOD. (6488454)SDR DALA2020021321133Fuse · failed(LOG 5928174) DURING INSPECTION FOUND SEAT EMERGENCY LIGHTS OUT FROM SEAT 23-33. T/S PER WIRING DIAGRAM MANUAL B737 33-51-11. FOUND BAD FUSE ON POWER SUPPLY M1672. REPLACED SAME REF B737 AMM 33-57. OPS CHK GOOD.SDR AALA2020021329007Power Supply · no testAIRCRAFT WAS GROUNDED: DURING PS CHECK, FAILED EMERGENCY LIGHT TEST. MAINTENANCE ACCOMPLISHED TSM TASK 33-51-00-810-808-A AND FOUND EMERGENCY POWER SUPPLY UNIT AT FAULT AND REPLACED POWER SUPPLY PER AMM 33-51-38.SDR SWAA2020021241365Light · inoperativeFORWARD OVERWING EXIT SIGNS (EMERGENCY) L1208 INOP. / R&R LIGHT IAW AMM.SDR SWAA2020021241364Light · inoperativeFORWARD OVERWING EXIT SIGNS (EMERGENCY) L1207 INOP. / R&R LIGHT IAW AMM.SDR SWAA2020021241363Fuse · inoperativeFORWARD OVERWING EXIT SIGNS (EMERGENCY) L1208 INOP. / R&R FUSE IAW AMM.SDR SWAA2020021241362Power Supply · inoperativeEMERGENCY LIGHT POWER BY M1675 ( / FORWARD CABIN ) WERE INOP. / R&R POWER SUPPLY IAW AMM.SDR SWAA2020021241361Power Supply · inoperativeEMERGENCY LIGHT POWER BY M1676 / (FORWARD CABIN) WERE INOP. / R&R POWER SUPPLY IAW AMM.SDR SWAA2020021241334Power Supply · inoperativeEMERGENCY LIGHT POWER BY M2816 (FORWARD CABIN) WERE INOP. / R&R POWER SUPPLY IAW AMM.SDR SWAA2020021241317Fuse · inoperativeFORWARD OVERWING EXIT SIGNS (EMERGENCY) L1207 INOP. / R&R FUSE IAW AMM.SDR SIMA202002121001Light · inoperativeGALLEY EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED GALLEY EMERGENCY LIGHT IAW EMB AMM 33-50-09-000-801-A AND 33-50-09-400-801-A OPC GOOD ENDSDR PNSA20200212102Light · unsecureTRACK LIGHTING STRIP CAME LOOSE, RE-SECURED.(ROW 5)SDR AALA202002129006Battery · faultedAIRCRAFT WAS NOT GROUNDED: RIGHT OVERWING EXIT SIGN INOPERATIVE. MAINTENANCE REPLACED RIGHT CENTER EMERGENCY LIGHT POWER UNIT BATTERY PER AMM 33-50-01.SDR DALA2020021201101Cover · missingEMERGENCY FLOOR LIGHTING MISSING COVER GREEN RUNNING MAN, LOCATED LIGHT COVER & RE-ATTACHEDSDR MASA2020021100060Light · inoperativeROW 15 OVHD EMER LIGHT INOPSDR SWAA2020051828472Battery Pack · dischargedEMERGENCY LIGHT POWER BY M2816; M1675 AND M1676 ' '(FWD CABIN) ARE INOP. / REPLACED EMERGENCY LIGHT BATTERY PACK POWER SUPPLY M2816; M1675; M1676; OPS TEST GOOD IAW AMM 33-51-06-960-805 AND AMM 33-51-0G-960-806 ' 'WN6839; CP4369; WN5541; CP4370; WN6354; CP4371SDR SWAA2020022841980Lens · brokenBROKEN EMERGENCY EXIT LENS GALLEY 4 AT AFT GALLEY AREA. / R&R LENS IAW AMM.SDR FDEA2020021400323Battery Pack · inoperativeN912FD FOUND EMERGENCY BATTERY PACK OF DOOR L1 LOW REASON CODE : FAILED OPS CK. & REPLACED WITH SERVICABLE UNIT OFF MPN: 2013-1A CPN: 3301128 POS: 1 SRL: 39538 TAG NBR: 7I9496 ON MPN: 2013-1A CPSDR DALA2020022041292Wire Harness · damagedFOUND DURING SERVICE CHECK EMERGENCY LIGHT ON SEAT 36A INOPERATIVE. REPLACED WIRE HARNESS FROM SIDE WALL TO SEAT. SYSTEM OPERATION IS NORMAL.SDR DALA2020021311118Sign · unsecure(AIRCRAFT 6815, L/P 1484411) EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:653. CORRECTIVE ACTION: SECURED EXIT SIGN LOC 653.SDR DALA2020021311116Sign · wrong part(AIRCRAFT 5652, L/P 6952463) FOUND TWO OVERWING EMERGENCY EXIT SIGNS WITHOUT PROPER ARROWS. CORRECTIVE ACTION: R/R'D EXIT SIGNS PER B757 AMM 33-41-01.SDR ASAA2020021203151Sign · detachedR2 DOOR EXIT SIGN FELL OFF. GROUNDED - YES. RESECURED EXIT SIGN LOCATED IN AFT GALLEY R/H SIDE OF WASTE CONTAINER AS REQUIRED OK TO CONTINUE SERVICE.SDR SWAA2020021241311Cover · detachedAISLE OVERHEAD EXIT SIGN COVER DETACHED. / INSTALLED COVER PER AMM.SDR AALA202002129003Battery · faultedAIRCRAFT WAS NOT GROUNDED: 11WL EMERGENCY POWER SUPPLY UNIT BATTERY FAULT. MAINTENANCE REPLACED 11WL BATTERY PER AMM 33-51-38.SDR AALA2020021219011Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY/BATTERY FAULT 11WL FAILED EMERGENCY LIGHTS OPERATIONAL TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY 11WL PER AMM 33-51-38.SDR ASAA2020021103141Battery Pack · failedREF T/C 78233001AFT LH EMERGENCY EXIT LIGHTS FAILED AFTER RECHARGE. GROUNDED - YES. REMOVED AND REPLACED AFT LH POWER SUPPLY BATTERY PACK IAW B737-800 AMM 33-51-06-960-805. GROUND VERIFICATION TEST IS GOOD.SDR AALA202002119003Battery · faultedAIRCRAFT WAS NOT GROUNDED: 11WL ESPU BATTERY FAULT. MAINTENANCE REPLACED BATTERY PER AMM 33-51-38.SDR SIMA202002110002Light · inoperativeLH FWD WING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH FWD WING EMERGENCY LIGHT IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECKED GOOD. END.SDR DALA2020021101077Bulb · inoperativeCREW REST LADDER AND COMMON AREA EMERGENCY EXIT SIGNS INOPERATIVE. FOUND ALL 24 BULBS BURNT OUT BETWEEN BOTH SIGNS AND RELAMPED.SDR DALA2020021001025Charger · failedCEILING EMERG LIGHTS INOP AT ROW 22-25. R/R EMERG LIGHT BATTERY CHARGER BATTERIES (3E) REF MD88 AMM 33- 53. OPS CKS OK. (LP6896559)
Back to JASC 3350