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 R61A201811091123Light · damagedPHOTOLUMINESCENT STRIP IN FRONT OF WARDROBE DAMAGED. R&R PHOTOLUMINESCENT STRIP PER AMM 33-50-21.SDR SWAA2018111926925Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY CHECK AT LOCATION M01676. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018111926924Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY CHECK AT LOCATION M01674. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018111926923Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018111926922Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018111926921Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018111926883Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAIL CAPACITY CHECK AT LOCATION M01668. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018111326720Battery · failedAFT LT EMERGENCY LIGHTS BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018111326629Battery · failedLT FORWARD EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018111326628Battery · failedAFT RT EMERGENCY LIGHTS BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR ASAA2018110826818Light · inoperativeAFT R2 DOOR EXT EMERGENCY LIGHT INOP. GROUNDED - YES. RELAMP R2 DOOR EXIT EMERGENCY LIGHT PER AMM 33-51-04.SDR ASOA2018111385316Sign · inoperativePILOT REPORTED "EMERGENCY LIGHT OVER FA JUMPSEAT NOT WORKING". MX REMOVED AND REPLACED EMERGENCY EXIT WARNING SIGN OVER FA JUMPSEAT. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2018111396608Sign · detachedSHIP 692 EXIT SIGN 2L FALLING OFF. CORRECTIVE ACTION: REINSTALLED SAME (5357864).SDR AALA201811139010Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY 14WL FAILED A BITE TEST IAW JC 26L00005005. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR YENA201811080771Housing · defectiveFT 422, NAS-JFK. AFT GALLEY EXIT SIGN OVERHEAD SHORTING OUT. REPEAT INOP FROM PREVIOUS FLIGHT WHEN BANGING ON IS TEMPORARILY FIXED. R&R AFT GALLEY OVERHEAD EMERGENCY EXIT HOUSING ASSY IAW AMM 33-51-00. OPS CHK OK.SDR DALA2018111206580Light · broken(AIRCRAFT 659, L/P 4487978) EMERG. LIGHTS AT 2DC BROKEN. REPLACED EMERG. LIGHT LENSES ASSY. AT 2DC. REF B757 AMM 33-51. OPS NORMAL.SDR AALA201811119001Light · detachedCABIN SIDE WALL PANEL AT A-B SIDE, EMERGENCY LIGHT DETACHED, WIRES EXPOSED. SECURED. NO DAMAGE NOTED. OK FOR SERVICE.SDR AALA201811099014Cover · looseR4 DOOR EXIT LIGHT COVER WAS LOOSE. MAINTENANCE REPLACED LIGHT COVER.SDR AALA201811099012Lens · brokenBROKEN EMERGENCY LIGHT LENS IN THE PASSENGER CABIN. REPLACED THE LENS IAW AMM 33-51-13-400-001-A.SDR AALA201811099011Lens · brokenBROKEN EMERGENCY LIGHT LENS IN THE PASSENGER CABIN. REPLACED THE LENS IAW AMM 33-51-13-400-001-A.SDR AALA201811099010Lens · brokenBROKEN EMERGENCY LIGHT LENS IN THE PASSENGER CABIN. REPLACED THE LENS IAW AMM 33-51-13-400-001-A.SDR AALA201811099009Lens · brokenBROKEN EMERGENCY LIGHT LENS ON THE PASSENGER DOOR. REPLACED EMERGENCY LIGHT LENS IAW AMM 33-51-13-400-001-A.SDR SIMA201811098001Inverter · inoperativeEMERGENCY EXIT LIGHT BY MAIN DOOR INOP.-C/A-REMOVED AND REPLACED #1 EMER. LIGHT DC/AC INVERTER IAW EMB140 AMM 33-50-11, OPS CHECK GOOD.SDR SIMA201811098003Light · nonePAX DOOR EMERGENCY LT INOP-C/A-PERFORMED OPS CHECK OF PAX DOOR EMERGENCY LT IAW EMB AMM TASK 33-50-00-700-801-A OPS CHECK GOODSDR AALA201811099008Light · brokenTHE R2 DOOR EMERGENCY EXIT LIGHT ON THE RIGHT SIDE OF DOOR IS COMPLETELY BROKEN. MAINTENANCE REMOVED AND REPLACED THE LIGHT ASSY, OPS CHECKED NORMAL IAW AMM 33-51-01.SDR AALA201811099004Light · unsecureSEAT 4C EMERGENCY FLOOR LIGHT UNSECURE. SECURED THE EMERGENCY FLOOR LIGHT IAW AMM 25-21-41-400-001-A, AND AMM 33-51-19-400-003-A.SDR DALA2018110806545Housing · damaged(AIRCRAFT 686, L/P 5199018) SEAT ROW 45 EMERGENCY PATH LIGHT HOUSING ASSY DAMAGED/HANGING. REPLACED ROW 45 EMERGENCY LIGHT HOUSING ASSY.SDR Q2SA20181107410Battery · dischargedAIRCRAFT GROUNDED. ALL BATTERY PACKS FOR THE EMERGENCY LIGHTS FAILED DURING THE TESTS. REF TASK 3500444 2000-0105. REMOVED AND REPLACED ALL BATTERIES FOR THE EMERGENCY LIGHTING. REF TASK 33-51-51-962-015. OPS CHECKS PERFORMED - PASSED. REF TASK STEP 3E (4).SDR Q2SA2019022700105Battery Pack · no testBATTERY PACKS FOR THE EMERGENCY LIGHTS FAILED DURING THE TEST. PACKS REPLACED WITH P/N 2013-1A (9EA).SDR SWAA2018111326642Lens · looseRT OVERWING EMERGENCY EXIT LIGHT PLACARD LOOSE. R&R LENS PER AMM.SDR AALA201811099005Light · unknownOVERHEAD EMERGENCY LIGHTS CAME ON AND REMAINED ON. ACCOMPLISHED A BITE TEST AND OPS TEST IAW AMM 33-51-00. TESTED GOOD. NO FAULTS. OK FOR SERVICE.SDR REXA201811091071Sign · inoperativeAFT OVERBOARD EMERGENCY CALL LIGHT INOP.
VERIFIED MID-CABIN (RED) EMG LIGHT VERY DIM. ITEM DEFERRED IAW MEL
23-40-1K (B). ENTERED IN MM02 MXC NOTIFIED 98765.***REPLACED MID CABIN
OVERWING EXIT LOCATING AFT SIGN IAW AMM 33-51-07. OPS CK GOOD. REMOVE
D SDR SIMA201811087003Inverter · inoperativeDURING OPC OF EMERGENCY LIGHTING SYS. FLOOR STRIPS FROM 3A TO 6A WERE INOP-C/A-REMOVED AND REPLACED #3 EMERGENCY LIGHT DC/AC INVERTER, OPC GOOD, IAW AMM 33-50-11SDR AALA201811089026Ballast · inoperativeCOVE LIGHT 26L WAS INOPERATIVE. MAINTENANCE REPLACED THE BALLAST AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-21-11.SDR AALA201811089024Lens · missingSEAT 22D WAS MISSING EMERGENCY LIGHT RED LENS. MAINTENANCE REPLACED EMERGENCY LIGHT IAW AMM 33-51-19, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811089002Lens · missingEMERGENCY LIGHT LENS WAS MISSING AT SEAT 24C. INSTALLED THE LENS.SDR AALA201811089007Lens · brokenEXIT SIGN BROKEN. LEFT SIDE. REPLACED EXIT LIGHT LENS IAW AMM 25-10-00.SDR AALA201811089005Power Supply · malfunctionedRECEIVED A CIDS 1 MESSAGE. EMERGENCY LIGHT/EMERGENCY POWER SUPPLY UNIT 14WL MID R. CLASS 1. PERFORMED TROUBLESHOOTING IAW TSM 33-51-00-810-868A. LIGHTS WORK, FAULT STILL EXISTS. REPLACED THE EPSU 14WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR SWAA2018110826606Light · inoperativeAFT SERVICE EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018110826603Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK INOP AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR SWAA2018110826594Battery · failedAFT GALLEY RIGHT SIDE EMERGENCY BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR DALA2018110706537Lens · detached(AIRCRAFT 692, L/P 5357858) 2L EXIT DOOR LIGHT COVER FELL OFF/LOOSE. REINSTALLED AND SECURED 2L EXIT DOOR LIGHT COVER AS PER B757-200 AMM 33-51.SDR DALA2018110706525Sign · detached(AIRCRAFT 692, L/P 5357857) 2L EXIT SIGN FELL OFF DURING TAXI. RESECURED 2L EXIT SIGN COVER, OPS CHECK GOOD PER B757 AMM 33-50.SDR MASA2018110711506Light · inoperativeSEAT 1C PHOTOTLUMINESCENT STRIP INOP. PLACED ON MELSDR SIMA201812106006Light · inoperativeLH PASSENGER ESCAPE HATCH LINING LOWER EMERGENCY LIGHT INOP.-C/A-COMPLETE:REMOVED CONNECTED AND REINSTALED LH PASSENGER ESCAPE HATCH LINING LOWER EMERGENCY LIGHT OP CK CW IAW EMB 145 AMM 33-50-13SDR SIMA201812106005Bulb · inoperativeEMERGENCY LIGHT ON SERVICE DOOR INOP-C/A-COMPLETE:REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT BULB IAW EMB 145 AMM 33-50-09. ILLUMINATION CHECK GOOD.SDR SWAA2018111326626Light · inoperativeLT EMERGENCY LIGHT INOP AT SEAT 9. RELAMPED LIGHT PER MM.SDR 2WAA2018111306Light · inoperativeFOUND BOTH RIGHT SIDE LOWER EMERGENCY EXIT LIGHT INOP.SDR REXA2018111360197Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY PACK #1 IS DEAD/INOP
REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK #1 IAW CRJ 200 AMM 33-51-04 OPS CHECK GOOD IAW CRJ 200 AMM 33-51-04-710-801 AAR AP 344SDR AALA201811097002Power Supply · inoperativeLEFT EMERGENCY EXIT LIGHT WAS INOPERATIVE. REMOVED & REPLACED THE POWER SUPPLY M33406 AT THE L3 DOOR, OPS CHECKED GOOD IAW MM 33-51-06-960-003.
Back to JASC 3350