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 SIMA202002107001Battery Pack · inoperativeL/H AND R/H HAND AFT EXTERIOR OVER WING EMERGENCY LIGHTS INOP "TRANSFERRED FROM NRWC 848-SGF-03052 ITEM 1" RWK 678084-C/A-L/H AND R/H EXTERIOR OVER WING EMERGENCY LIGHTS DEFERRED PER MEL 33-29. REMOVED AND REPLACED # 4 EMERGENCY BATTERY AND CHARGER IAW W/C 3SDR CALA2020020800369Light · malfunctionedB777-33-3-7030 R/H NO.4 DOOR EXTERIOR EMER LT FOUND ILLUMINTED REFER NR LP 9130049 R/H NO.4 DOOR EXTERIOR EMER LT REPLACED AND OP TEST RESULT NORMAL AS PER AMM 33-51-04SDR CALA2020020800368Battery Pack · inoperativeSUPPORT TASK LLAR EMER LT FOUMS UNILLUMINATED REFER NR LP 9131122 LLAR EMER LT CHARGER REPLACED AND OP TEST RESULT NORMAL AS PER AMM 33-29-01SDR CALA2020020800367Power Supply · inoperativeSUPPORT TASK DR R3 EMERGENCY LT PWR SUPPLY (M33401) INOP REFER NR LP 9131097 DR R3 EMERGENCY LT PWR SUPPLY (M33401) REPLACED AND OP TEST FOUND NORMAL AS PER AMM 33-51-06 ADD EMP:V896992SDR MASA2020020700053Light · inoperativeROW 6 CEILING LEVEL EMER FLOODLIGHT INOP PLACED ON MELSDR QXEA2020020700088Light · dirtyF/A REPORTS EMERGENCY STRIP ON FLOOR IS BLACK. REMOVED FROM SERVICE. CLEANED EMERGENCY STRIP ON FLOOR L/H SIDE AT SEAT 2A-4A.NO OTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR MASA2020020600052Light · inoperativeROW 20 OVHD EMERG FLOOD LIGHT INOP- PLACED ON MELSDR AALA2020020769019Connector · faultyAIRCRAFT WAS NOT GROUNDED: 12 ABC SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED CONNECTOR PER WDM 33-51-07.*** (CLOSED)SDR P5CA2020021300033Battery Pack · no testTEST FAIL: FOUND EMERGENCY BATTERY PACK M5168 CAN NOT STAY ON 15 MINS.(<P>1) IAW AMM 33-51-04-002-009-001 REV 97, REMOVED EMERGENCY BATTERY POWER PACK ASSY M5168.</P><P>2) IAW AMM 33-51-04-402-012-001 REV 97, INSTALLED EMERGENCY BATTERY POWER PACK ASSY M5168.<SDR P5CA2020021300044Battery Pack · no testFOUND EMERGENCY LIGHT POWER PACK FUNCTIONAL FAIL.(<P>IAW AMM 33-51-04-902-001-001 REV 97, REPLACED EMERGENCY LIGHT POWER PACK M5170 AND PERFORMED POWER SUPPLY TEST, THE RESULT WAS SATISFACTORY. </P>)SDR SWAA2020021214294Fuse · inoperativeR/H EMERGENCY AISLE LIGHT INOP AT ROW 14. / R&R FUSE ON CHARGER PER AMM.SDR SWAA2020021214273Lamp · inoperativeL2 DOOR EMERGENCY SLIDE LIGHT WAS OUT. / RELAMPED LIGHT PER AMM.SDR SWAA2020021214196Battery Pack · no testEMERGENCY LIGHTS BATTERY FAILED CAPACITY CHECK AT L/H MIDDLE LOCATION (M1669). / R&R BATTERY PACK IAW AMM.SDR YENA2020021060166Power Supply · no testFT # 872, SLC-JFK. DURING EMERGENCY LIGHT SYSTEM OK IAW W0 1040731 FOUND FWSA; R & R EPSU (10WL) IAW AMM 33-51-38. OPERATIONAL OK GOOD. EMERGENCY SYS LIGHT OK GOOD.SDR YENA2020021060165Battery · failedFT # 872, SLC-JFK. PER BAT CAPACITY CHECK IAW W/O 1040731, PERFORMING ALTERNATIVE METHOD & REPLACED ALL EPSU BATTS REF AMM 335100-710-003-01; REPLACED EMERGENCY LIGHT BATTS (10WL, 11WL, 12WL, 13WL) IAW AMM 33-51-38. EMERGENCY SYSTEM LIGHT CHECK GOOD.SDR YENA2020021060164Battery · failedFT # 872, SLC-JFK. PER BAT CAPACITY CHECK IAW W/O 1040731, PERFORMING ALTERNATIVE METHOD & REPLACED ALL EPSU BATTS REF AMM 335100-710-003-01; REPLACED EMERGENCY LIGHT BATTS (10WL, 11WL, 12WL, 13WL) IAW AMM 33-51-38. EMERGENCY SYSTEM LIGHT CHECK GOOD.SDR YENA2020021060163Battery · no testFT # 872, SLC-JFK. PER BAT CAPACITY CHECK IAW W/O 1040731, PERFORMING ALTERNATIVE METHOD & REPLACED ALL EPSU BATTS REF AMM 335100-710-003-01; REPLACED EMERGENCY LIGHT BATTS (10WL, 11WL, 12WL, 13WL) IAW AMM 33-51-38. EMERGENCY SYSTEM LIGHT CHECK GOOD.SDR YENA2020021060162Battery · no testFT # 872, SLC-JFK. PER BAT CAPACITY CHECK IAW W/O 1040731, PERFORMING ALTERNATIVE METHOD & REPLACED ALL EPSU BATTS REF AMM 335100-710-003-01; REPLACED EMERGENCY LIGHT BATTS (10WL, 11WL, 12WL, 13WL) IAW AMM 33-51-38. EMERGENCY SYSTEM LIGHT CHECK GOOD.SDR QXEA2020020700087Light · looseFLOOR TRACK LIGHTING IN FRONT OF 1B IS LOOSE. REMOVED FROM SERVICE. RE-SECURED EMERGENCY FLOOR-PATH-LIGHT ASSEMBLY IN FRONT OF 1B REF Q400 AMM TASK 33-51-16-400-801. NO FURTHER DEFECTS. RETURNED TO SERVICE.SDR SIMA202002076003Lamp · inoperativeLH OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH OVERWING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECK GOOD.SDR SIMA202002076002Charger · inoperativeBOTH EXTERNAL OVERWING AFT EMERGENCY LIGHTS INOP-C/A-TROUBLE SHOT OVERWING AFT EMERGENCY LIGHTS IAW EMB WIRE MANUAL 33-50-50. FOUND #4 EMERGENCY BATTERY AND CHARGER BAD. REMOVED AND REPLACED #4 EMERGENCY CHARGER AND BATTERY ASSEMBLY IAW EMB W/C 33-700-19. OPSSDR DALA2020020700974Battery Pack · inoperativeDURING S/C FOUND FWD EMER LIGHT BATTERY PAK INOP, R&R RWD BATT PAKSDR WX0A202002073470Battery Pack · no testEMERGENCY LIGHT TEST FAILS AFT EPSU BATTERY / REMOVED AFT EPSU BATTERY"SDR WX0A202002073469Battery Pack · no testEMERGENCY LIGHT TEST FAILS MID-RIGHT EPSU BATTERY / REPLACE MID-RIGHT EPSU BATTERY"SDR WX0A202002073468Bulb · inoperativeRH EMERGENCY EXIT SIGN HAS BULBS INOP / REPLACED INOP BULBS"SDR WX0A202002073467Bulb · inoperativeLH EMERGENCY EXIT SIGN HAS BULBS INOP / REPLACED INOP BULBS"SDR REXA2020020760186Battery Pack · inoperative"L+R AFT EMERGENCY LIGHTS ON EXTEROIR ARE INOP.
""R+R BATTERY PS38 IAW CRJ-700 JOBCARD 33-90-701. P/N ON: 2013-1ASMI S/N ON: 12219. PN OFF: 2013-1ASMI SN OFF: 8622
"SDR MASA2020020760051Lamp · inoperativeROW 18 CEILING LVL EMER FLOOD LT INOP- RELAMPED OPS CKS GOODSDR SWAA2020020641183Battery Pack · inoperativeR/H OVERHEAD EMERGENCY AISLE LIGHT INOP AT ROW 14. / R&R BATTERY PACK IAW MM.SDR SWAA2020020641165Charger · inoperativeR/H OVERHEAD EMERGENCY AISLE LIGHT INOP AT ROW 14. / R&R BATTERY CHARGER IAW MM.SDR SWAA2020020641142Light · crackedR/H PASSENGER CABIN PHOTOLUMINESCENT STRIP CRACKED AT ROW 30. / R&R STRIP PER AMM.SDR DALA2020020600950Lens · missing(LOG 6457827) DURING INSPECTION FOUND EMERGENCY PATH LIGHT AT 34DEF MISSING LENS. R/R'D EMERGENCY PATH LIGHT ASSY PER CMM 25-25-47. OPS CKS GOOD.SDR SWAA2020030942308Battery Pack · inoperativeINOP EMERGENCY LIGHT BATTERY PACKS M1672 AND M1673 AT PASSENGER CABIN REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS M1672 AND M1673 AT PASSENGER CABIN IAW AMM 33-51-06-960-805. PERFORMED TEST OF THE NEW BATTERY PACK IAW AMM 33-51-06-960-805 TEST SDR SWAA2020030442136Battery Pack · inoperativeINOP EMERGENCY LIGHT BATTERY PACKS M1668 AT PASSENGER CABIN. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS M1668 AND M1670 AT PASSENGER CABIN IAW AMM 33-51-06 -960-805 AND PERFORMED TEST OF THE NEW BATTERY PACK IAW AMM 33-51-06-960-805 TEST IS GOOSDR SWAA2020030442111Battery Pack · inoperativeINOP EMERGENCY LIGHT BATTERY PACKS M1670 AT PASSENGER CABIN REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS M1668 AND M1670 AT PASSENGER CABIN IAW AMM 33-51-06 -960-805 AND PERFORMED TEST OF THE NEW BATTERY PACK IAW AMM 33-51-06-960-805 TEST IS GOODSDR SWAA2020030442084Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACKS M1674 INOPERATIVE AT PASSENGER CABIN. / R&R BATTERY PACK IAW AMM.SDR SWAA2020030442083Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK M1669 INOPERATIVE AT PASSENGER CABIN. / R&R BATTERY PACK IAW AMM.SDR SWAA2020030342016Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK M1670 INOPERATIVE AT PASSENGER CABIN. / R&R BATTERY PACK IAW AMM.SDR SWAA2020030342015Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACKS M1675 INOPERATIVE AT PASSENGER CABIN. / R&R BATTERY PACK IAW AMM.SDR ASOA2020021405505Bulb · blownDURING MX INSPECTION ROW 23 CEILING EXIT LIGHT WAS FOUND INOP. MX REMOVED AND REPLACED ROW 23 CEILING EXIT LIGHT BULB WITH OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE 2/12/2020.SDR DALA2020021061057Lens · missingSHIP 6715 EMERGENCY LIGHT LENS COVER MISSING AT R-1. CORRECTIVE ACTION: REPLACED MISSING COVER IN REF TO B757 AMM 33-51. (6428974)SDR DALA2020021071052Light · damaged(AIRCRAFT 5815, L/P 6376965) AISLE LIGHT DAMAGED ON SEAT 27D. CORRECTIVE ACTION: REPLACED LIGHT AND BUMPER ASSY PER CMM 25-21-52.SDR DALA2020020601038Light · inoperative(LOG 6337388) DURING INSPECTION FOUND AISLE SEAT 30 EMERGENCY ESCAPE PATH LIGHT INOPERATIVE. OPS TEST EMERGENCY ESCAPE PATH LIGHT AT LIGHT SEAT 30 PER B737 AMM 33-51. OPS TEST GOOD.SDR DALA2020020701018Power Supply · inoperativeDURING SERVICE CHECK, FOUND EMERGENCY LIGHTS INOPERATIVE ON THE LEFT SIDE OF AIRCRAFT ROWS 22AB TO THE BACK ROW. REPLACED DOOR 4L EPSU. LP 6956916SDR AALA2020020769015Battery · faultyAIRCRAFT WAS GROUNDED: 15WL BATTERY FAULT IN SMOKE CLASS 2. MAINTENANCE REPLACED 15WL POWER SUPPLY UNIT BATTERY PER AMM 33-51-38.SDR DALA2020020761008Power Supply · malfunctionedFOUND RT MID CABIN EMERGENCY LGTS ALL DIM.REPLACED POWER SUPPLY BETWEEN SEATS 21FG AND 22FG. SYSTEM OPERATION IS NORMAL.SDR R61A2020020750158Light · missingFLOOR LEVEL EXIT PATH STRIP MISSING AT SEAT 7B. INSTALLED PHOTOLUMINESCENT INDICATOR STRIP LIGHT AT SEAT 7B IAW AMM 33-50-21.SDR AALA202002079005Flashlight · brokenAIRCRAFT NOT GROUNDED: FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT HOLDER BROKEN. REMOVED AND REPLACED FA FLASHLIGHT IAW AMM 25-64-00.SDR YENA2020020750160Battery · no testFT # 102, JFK-BUF. EMERGENCY LIGHT POWER UNIT #1 FAILS OPERATIONAL CHECK; REMOVED AND REPLACED EMERGENCY LIGHT POWER UNIT #1 PER E190MM 33-50-01,OPS CHECK GOOD.SDR HALA2020020760061Cids · malfunctionedON PARKING CHECKLIST, WHEN TURNING OFF EMERGENCY EXIT LIGHT EMERGENCY LIGHT ILLUMINATED AND WOULD NOT CYCLE OFF. RESET CIDS NBR 1 AND 2. LP 7228076
Back to JASC 3350