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 HNAA2018121200314Light · inoperativeMAIN DOOR EMERGENCY LIGHT INOP. REMOVED THE MAIN DOOR EMERGENCY LIGHT COVER IAW AMM TASK #25-23-04-000-801-A. REMOVED THE EMERGENCY LIGHT ASSEMBLY FROM THE MAIN DOOR EMERGENCY LIGHT COVER AND REPLACED WITH NEW ASSEMBLY AND RETAINED HARDWARE INSTALLED MAIN DOORSDR AALA201812129014Shroud · damagedAIRCRAFT WAS NOT GROUNDED: ROW 13ABC EMERGENCY LIGHT SHROUD DAMAGED. MAINTENANCE REPLACED LIGHT SHROUD AT ROW 13ABC PER CMM 25-22-52 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201812129013Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY ISLE LIGHT ON 25C INOPERABLE. MAINTENANCE REPLACED LIGHT ON 25C AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA2018121211007Lamp · inoperativeSERVICE DOOR HINGE COVER EMERGENCY LIGHT INOP-C/A-RAR SERVICE DOOR HINGE COVER EMERGENCY LIGHT LAMP IAW EMB 140 AMM 33-50-09. OPC GOODSDR SIMA2018121211006Battery · failed12C UPPER EMERGENCY EXIT SIGN INOP-C/A-T/S PER WM 33-50-50 REMOVED AND REPLACED #3 EMERGENCY BATTERY AND CHARGER IAW W/C 33-700-19 NO FIX, FURTHER T/S RAR #5 INVERTER IAW EMB AMM 33-50-11-000-801-A AND 33-50-11-400-801-A OPC GOOD NO DEFECTS NOTED AT THIS TIME SDR SIMA2018121211005Light · inoperativeCOCKPIT EMERGENCY LT INOP-C/A-RAR COCKPIT EMERGENCY LIGHT IAW EMB AMM 33-50-05-000-801-A AND 33-50-05-400-801-A. NO FURTHER DISCREPANCIES WERE FOUND. END.SDR SIMA2018121211004Bulb · inoperativeMAIN ENTRANCE DOOR EMERGENCY FLOOD LIGHT INOP-C/A-REMOVED AND REPLACED MAIN ENTRANCE DOOR EMERGENCY FLOOD LIGHT BULB IAW EMB 145 AMM 33-50-10. OPS CHECK GOODSDR MASA2018121111585Bulb · inoperativeROW 15 CEILING LEVEL EMER FLOOD LT INOP
PLACED ON MELSDR SIMA20181211002Light · malfunctionedON A/C SHUTDOWN WITH GPU CONECTED EMERGENCY LIGHT COME ON-C/A-PERFORMED ELECTRICAL RESET IAW E 175 AMM 24-42-00 AND EMERGENCY LIGHT WORKING NORMAL IAW E175 AMM 33-50-00SDR REXA201812111226Inverter · inoperativeDURING POST FLIGHT NOTICED EMER-LIGHTS NOT OPERATIONAL
CHARGED EMERGENCY LIGHT BATTERY PACKS IAW CMM 25-60-03 REPLACED INVERTER PS3LY IAW AMM 33-51-07 OPS CHECK GOODSDR YENA2018121400845Light · detachedFT # 80, RNO-JFK. WHITE EMERGENCY ISLE LIGHT ON ROW 1ABC HANGING DOWN + MISSING LENS; REPLACED 1ABC EMERGENCY LIGHT LENS AND SECURED ASSY AS REQ OPS CK GOOD REF 33-50-00SDR SWAA2018121227628Battery · dischargedRT OVERWING EXIT SIGN INOP. R&R BATTERY PER AMM.SDR SWAA2018121227617Battery · dischargedLT OVERWING EXIT SIGN INOP. R&R BATTERY PER AMM.SDR SWAA2018121227616Lens · brokenFORWARD GALLEY DOOR EMERGENCY EXIT LENS BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2018121227601Cover · missingR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. R&R COVER IAW SIP.SDR ASAA2018121027335Sign · disconnectedAFT CEILING EXIT SIGN DISCONNECTED. GROUNDED - YES. RESECURED AFT CEILING EXIT SIGN AS REQUIRED. OPS CHECK IS GOOD. NO FURTHER ACTION IS REQUIRED AT THIS TIME.SDR HNAA2018121200313Light · inoperativeFLOOR EMERGENCY LIGHT STRIP BETWEEN ROWS 15 AND 16 INOP. R&R LIGHT STRIP. OPS CK GOOD IAW AMM TASK 33.50.12.00/400.801.A.SDR IPXA2018121206798Lens · missingL1 DOOR EMERGENCY EXIT LIGHT LENS WAS MISSING. REPLACED LIGHT ASSY, OPS NORMAL.SDR IPXA2018121216812Lens · missingL1 DOOR EMERGENCY LIGHT MISSING THE LENS. REPLACED THE LIGHT ASSY IAW AMM 33-51-17-0401, OPS TESTED GOOD.SDR IPXA2018121136804Battery Pack · dischargedEMERGENCY POWER BATTERY 1 LOW. R & R THE BATTERY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201812119021Battery Pack · inoperativeEMERGENCY LIGHTS AT THE R4 DOOR WAS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR REXA2018121001230Battery Pack · dischargedTHE EMERGENCY EXIT SIGNS AT THE BOTTOM IN ROW 13 ARE BOTH INOP ON EACH
SIDE.
R&R'D #3 EMERGENCY LIGHT BATTERY PACK & POWER SUPPLY IAW AMM 33-51-17.
OPS CK'S GOOD. OK FOR SERVICE.SDR REXA201812111229Battery Pack · dischargedTHE OVERHEAD EXIT SIGN IN ROW 13 THREE BULBS ARE NOT COMING ON.
R&R'D #3 EMERGENCY LIGHT BATTERY PACK & POWER SUPPLY IAW AMM 33-51-17.
OPS CK'S GOOD. OK FOR SERVICE.SDR SIMA201812110003Bulb · inoperativeWHILE PERFORMING PS-1 CHECK FOUND SERVICE-DOOR EMERGENCY LIGHT OUT.-C/A-REMOVED AND REPLACED SERVICE-DOOR EMERGENCY LIGHT BULD IAW EMB 145 AMM TASK 33-50-09-000-801-A AND AMM TASK 33-50-09-400-801-A. OPS CHECK GOOD.SDR AALA201812119020Battery Pack · inoperativeEMERGENCY LIGHTS IN AFT ECONOMY CABIN SEATS WERE INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA201812119014Lens · missingFLOOR EMERGENCY LIGHT LENS WAS MISSING LT ROW 20. MAINTENANCE REPLACED THE LENS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR MASA2018121011584Bulb · inoperativeLH FWD WING EMERGENCY EXIT 1 BULB OUT
REPLACED BULBSDR DALA2018121007117Power Supply · inoperativeEMERGENCY CEILING LIGHT FROM SEAT 1-20, 2 LIGHTS OVER THE 2L DOOR, AND FROM SEAT 32-34 ARE ALL INOPERATIVE. AT THE AFT STAIR DOOR THE LIGHTS ARE VERY DIM AND FLICKERING. MAINTENANCE CHANGED B5-101 AND B5-102 BATTERIES OUT OF THE BATTERY POWER SUPPLY, AND REPLASDR DALA2018121007116Battery Pack · inoperativeON THE SERVICE CHECK, MAINTENANCE FOUND THAT THE AFT OVERWING EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE DETERMINED THAT THE EMERGENCY LIGHT BATTERY PACK, B5-230, WAS INOPERATIVE. THE BATTERY PACK WAS REPLACED AND THE OPERATIONAL CHECK WAS GOOD REF B717 AMSDR SIMA20181209005Light · damagedRT FLOOR EXTRUSIONS NR 1 AND 2 ARE DAMAGED. C/A-COMPLETE:REMOVED AND REPLACED RT ISLE EXTRUSIONS NR 1, 2 IAW AMM 33-50-12.SDR SIMA20181209007Light · dimPAX DOOR EMERGENCY LIGHT DIM. C/A-COMPLETE:REMOVED AND REPLACED PAX DOOR EMERGENCY LIGHT ASSY. IAW AMM 33-50-10.SDR SIMA20181209004Light · damagedEMERGENCY LIGHT EXTRUSIONS ARE DAMAGED NR 1, 2 ,3 AND 8. C/A-COMPLETE:REMOVED AND REPLACED LT ISLE EXTRUSIONS NR 1, 2 ,3 AND 8. IAW AMM 33-50-12.SDR JJBA2018121809013Cover · crackedCABIN 1 LH EMERGENCY LIGHT STRIP PLASTIC COVER CRACKED. REMOVED AND REPLACED CRACKED #1 LH PHOTO LUMINESCENT FLOOR PROXIMITY STRIP LIGHT ASSEMBLY.SDR JJBA2018121709012Cover · crackedCABIN EMERGENCY LIGHT STRIP 1RH PLASTIC IS CRACKED AND PHOTO LUMINESCENT STRIP IS FADED. REMOVED AND REPLACED CRACKED AND FADED #1 RH PHOTO LUMINESCENT FLOOR PROXIMITY STRIP LIGHT ASSEMBLY.SDR JJBA2018121709011Light · missingCABIN EMERGENCY LIGHT STRIP 5LH MISSING 1 SEGMENT OF THE PHOTO LUMINESCENT STRIP. REMOVED AND REPLACED #5 PHOTO LUMINESCENT FLOOR-PROXIMITY STRIP LIGHT ASSEMBLY.SDR SWAA2018121427679Fuse · blownRT OVERWING EXIT SIDE WALL LIGHT INOP. R&R FUSE PER AMM.SDR DALA2018121107182Light · unsecureEMERGENCY SEAT MOUNTED LIGHT DAMAGED 26D. SECURED LIGHT.SDR SCNA20181209132Light · inoperative21ABC EMERGENCY LIGHT INOP. R&R LAMP 21ABC EMERGENCY LIGHT. OPS CHECK OK.SDR AALA201812139010Light · damagedSEAT MOUNTED EMERGENCY LIGHT AT ROW 25 WAS DAMAGED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19. OPS OK.SDR AALA2018121329035Lens · looseEXIT LIGHT COVER MISSING ON THE RIGHT SIDE OF RT EMERGENCY DOOR SLIDE. SECURED THE LIGHT LENS IAW AMM 33-51-17.SDR AALA2018121329033Light · damagedSEAT MOUNTED EMERGENCY LIGHTS AT ROW 32 WAS DAMAGED. REPLACED THE EMERGENCY LIGHTS IAW AMM 33-51-19. OPS OK.SDR AALA2018121329032Lens · missingSEAT ROW 19LT WAS MISSING THE EMERGENCY LIGHT LENS. THE AIRCRAFT WAS GROUNDED. REPLACED THE LENS IAW CMM 25-40-07.SDR DALA2018121207169Shroud · brokenEMERGENCY EXIT LIGHT SEAT 22C FLOOR SHROUD BROKEN FROM MOUNT, INSTALLED NEW SHROUD/COVERSDR AALA201812139008Switch · inoperativeEMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE SWITCH IAW AMM.SDR SWAA2018121027542Cover · missingRT EMERGENCY EXIT SIGN MISSING BY R3. R&R SIGN COVER PER SIP.SDR SWAA2018121027442Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA201812119013Light · malfunctionedFORWARD PORTABLE EMERGENCY LIGHT DID NOT OPERATE NORMALLY. MAINTENANCE REPLACED EMERGENCY LIGHT AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-53-00.SDR ASOA2018121194070Sign · inoperativeIAH - DURING MAINTENANCE INSPECTION THE EMERGENCY EXIT SIGN ON THE LEFT HAND COCKPIT PARTITION WA SFOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SIGN, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SESDR AALA201812109028Lens · damagedSEAT 8D EMERGENCY LIGHT WAS DAMAGED, THE RED LENS WAS MISSING. MAINTENANCE REPLACED THE LIGHT ASSEMBLY IAW AMM 35-51-19-0401, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR MASA2018120911583Epsu · dischargedFWD GALLEY 2 EXIT SIGNS INOPERATIVE. REPLACED LT FWD EPSU.
Back to JASC 3350