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 MASA2018060813308Light · inoperativeROW 14F EMERGENCY LIGHT INOPERATIVE. REPLACED BULB.SDR KCSA201806081142Light · inoperativeEMERGENCY LIGHT IN UPPER DECK STAIRWELL INOP.SDR DALA2018060803886Power Supply · inoperativeZONE 2 FLOOR EMERGENCY LIGHTS WERE INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY PACK M33404 IAW AMM 33-51-06.SDR DALA201806183896Lens · detachedL2 DOOR EXIT SIGN LENS DETACHED. INSTALLED THE LENS.SDR DALA2018061104014Housing · damagedEMERGENCY ESCAPE PATH LIGHTING HOUSING TORN OFF SEAT 37B. REPLACED HOUSING MCO/PLAC REMOVED.SDR DALA2018060903963Light · brokenEMERGENCY LIGHT AT SEAT 24C WAS BROKEN, REPLACED THE EMERGENCY LIGHT.SDR SWAA2018061122641Battery Pack · dischargedFORWARD SERVICE EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018061122617Light · looseLT AFT EMERGENCY EXIT LIGHT LOOSE. R&R LIGHT ASSEMBLY PER MM.SDR AALA2018061189017Bulb · missingROW 8A EMERGENCY LIGHT, BULB AND COVER MISSING. REPLACED THE LIGHT ASSEMBLY.SDR AALA201806119002Sign · missingSMALL EXIT SIGN ON LOWER PART OF THE L2 DOOR WAS MISSING. REPLACED EXIT SIGN, OK FOR SERVICE.SDR AALA201806119001Power Supply · no testEMERGENCY POWER SUPPLY 15WL FAILED A BATTERY CAPACITY TEST. REPLACED THE POWER SUPPLY, AND BATTERY. OPS CHECKED GOOD.SDR DALA2018060903918Light · inoperativeEMERGENCY SEAT MOUNTED LIGHTING INOPERATIVE AT 4C. REINSTALLED.SDR ASAA2018060874965Lens · detachedEXIT LIGHT LENS AT ROW 16F DETACHED. ACFT GROUNDED. REPLACED THE LIGHT AND LENS, OPS GOOD.SDR DALA2018060803913Sign · malfunctionedEMERGENCY EXIT FWD FACING MID CABIN EXIT SIGN INOP, CYCLED 1L EMERGENCY LIGHT SW. EXIT SIGN NOW CKS GOOD.SDR DALA2018060803912Lens · missingLT OVERWING EXIT SIGN IDENTIFIER MISSING, INSTALLED LT OVERWING DOOR LOWER EXIT IDENTIFIER LENS.SDR AALA201806089021Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY DOOR SLIDE LENS FELL OFF. RESECURED EMERGENCY EXIT DOOR SLIDE LENS. CHECKS OK PER AMM 33-50-00.SDR IPXA2018060830414Battery Pack · inoperativeEMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-01-700-802. SYSTEM CHECKED OK.SDR MASA2018060713305Light · inoperativeROW 18 OVERHEAD EMERGENCY FLOOD LIGHT WAS INOPERATIVE. SDR FDEA201806071417Power Supply · inoperativeRT R1 DOOR EXTERIOR SLIDE LIGHT INOP. REPLACED EMERGENCY LIGHT POWER SUPPLY M00730 PER MM CH 33-51-07-2. A/C READY FOR CONT SERVICE.SDR YENA201806070236Battery Pack · inoperativeDURING A CABIN EMERGENCY LIGHT TEST, FAILED FOR EMERGENCY LIGHT 12WL. REMOVED AND REPLACED THE EPSU 12WL BATTERY PACK IAW AMM 33-51-38-000-002-A, AND 33-51-38-400-002-A. OPS TESTED GOOD IAW AMM 33-54-38-805-058-A. OPENSDR UIEA2018060701062Battery · inoperativeFOUND THE EMERGENCY LIGHT FUNCTION ABNORMAL IN THE UPPER DECK AREA. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY M5168 IAW AMM 33-51-04-902-001-001, REV 42 AND PERFORMED AN EMERGENCY LIGHT TEST. RESULT WAS SATISFACTORY.SDR UIEA2018060701064Lamp · inoperativeFLOOR EMERGENCY LIGHT FORWARD OF SEAT 4J INOPERATIVE. REPLACED THE LAMP, OPS CHECKED GOOD IAW AMM 33-51-10- 912-064.SDR UIEA2018060701065Lamp · inoperativeFLOOR EMERGENCY LIGHT, AFT RIGHT SIDE OF FWD COAT CLOSET WAS FOUND INOPERATIVE. RELAMPED THE EMERGENCY LIGHT. OPS CHECKED GOOD IAW AMM 33-51-10-962-054.SDR UIEA2018060701068Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE ABOVE SEAT 33C. REPLACED THE LAMPS, OPS CHECKED GOOD IAW AMM 33-51-05-002-039.SDR UIEA2018060701069Lamp · inoperativeFLOOR EMERGENCY LIGHTS INOPERATIVE FROM SEATS 31C TO 38C. REPLACED THE LAMPS IAW AMM 33-51-05-002-034, OPS CHECKED GOOD.SDR UIEA2018060701067Lamp · inoperativeFLOOR EMERGENCY LIGHT AFT OF SEAT 19H WAS FOUND INOPERATIVE. REPLACED THE LAMP, AND OPS CHECKED GOOD IAW AMM 33-11-10-962-064.SDR SIMA20180606014Fitting · crackedNR 1-2-3-5 LT ISLE FLOOR LIGHT EXTRUSION CRACKED. REMOVED AND REPLACED NR 1,2,3, AND 5 LT ISLE FLOOR LIGHT EXTRUSIONS IAW AMM 33-50-12.SDR SIMA20180606015Battery · dischargedNR 2 EMERGENCY LIGHT BATTERY INOP. REMOVED AND REPLACED NR 2 EMERGENCY LIGHT BATTERY AND CHARGER IAW WC 33-700-19. OP CHECK GOOD.SDR ASOA201806065152Battery Pack · inoperativeDURING AN INSPECTION, THE FORWARD EMERGENCY LIGHT STRIP WOULD NOT ILLUMINATE. R & R THE BATTERY AND CHARGER, OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2018061122659Cover · missingR2 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROW. R&R COVER PER AMM.SDR AALA201806079029Power Supply · malfunctionedAIRCRAFT WAS NOT GROUNDED: OVERWING EMERGENCY LIGHTS WERE ON IN ARMED MODE. MAINTENANCE RESET LEFT HAND OVERWING EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018060879023Power Supply · no testEMERGENCY POWER SUPPLY FAILED TO TEST. REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR AALA2018060879019Lens · missingSEAT 3C MOUNTED EMERGENCY LIGHT LENS MISSING. REPLACED THE LIGHT ASSEMBLY IAW 33-51-19. OPS CHECKED NORMAL.SDR DALA2018060803885Battery Pack · no testFAILED EMERGENCY LIGHT BATTERY PACK AT BS 1338. THE BATTERY PACK WAS REPLACED IAW AMM 33-53-00. OPS TESTED GOOD IAW AMM 33-53-00.SDR HALA2018060700285Light · inoperativeRIGHT SIDE LAST ENTRY DOOR EXTERIOR EMERGENCY LIGHT OUT FOUND DURING PERFORMING T/C 33-001-00. FOUND THE LIGHT SOCKET LOOSE, SECURED, AND OPS CHECK OK.SDR HALA2018060700284Light · inoperativeEMERGENCY LIGHTS AT SEAT 3H INOPERATIVE. REPLACED THE LIGHTS AND COVERS. OPS CHECKED NORMAL.SDR YENA201806076235Battery Pack · failedLEFT MIDDLE EMERGENCY LIGHT ON THE WTB FAIRING WAS INOPERATIVE. R & R THE EMERGENCY LIGHT BATTERY PACK. PERFORMED AN OPS CHECK, ALL CHECKED GOOD IAW AMM 33-50-80.SDR SWAA2018060722615Battery Pack · dischargedLT BIN BULLNOSE EMERGENCY LIGHT INOP AT ROW 12. R&R BATTERY PACK PER AMM.SDR SWAA2018060722614Battery Pack · dischargedRT BIN BULLNOSE EMERGENCY LIGHT INOP BETWEEN ROW 8 TO ROW 18. R&R BATTERY PACK PER AMM.SDR SWAA2018060722611Battery Pack · dischargedLT BIN BULLNOSE EMERGENCY LIGHT INOP BETWEEN ROW 1 TO ROW 9. R&R BATTERY PACK PER AMM.SDR SWAA2018060722606Cover · missingLT FLOOR LEVEL OVERWING EXIT SIGN COVER MISSING. R&R COVER IAW MM.SDR SWAA2018060722604Light · inoperativeFORWARD ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018060722595Battery Pack · dischargedFORWARD EMERGENCY LIGHTS INOP AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR SWAA2018060722589Sign · missingFORWARD ENTRANCE EMERGENCY EXIT LIGHT COVER MISSING RED ARROW ON SIGN. R&R SIGN PER AMM.SDR DALA2018060703864Warning Message · false activationDURING DESCENT, THE EMERGENCY LIGHTS EICAS ANNUNCIATION ACTIVATED. THE EMERGENCY LIGHTS WERE NOT ON, AND THEY WERE ARMED AT THE TIME. NO PLF OR EXISTING CORRELATED FAULTS IN MAT. GROUND TESTED THE EMERGENCY LIGHT SYSTEM. ALL OPS NORMAL. NO EICAS MESSAGE,SDR MASA2018060763302Light · inoperativeONE CEILING EMERGENCY LIGHT AT ROW 15 WAS INOPERATIVE.SDR 29GA2018060700001Light · inoperativeDURING PREFLIGHT, EMERGENCY LIGHT WAS NOT WORKING. CYCLED CIRCUIT BREAKER L-8. OPS CHECKED GOOD IAW AMM 33-50-00.SDR DALA2018060763861Battery Pack · inoperativeMAINTENANCE FOUND THE AFT EMERGENCY EXIT, OVERWING SIGNS INOPERATIVE. THE POWER SUPPLY BATTERY PACK WAS REPLACED IAW AMM 33-51-03. OPS CHECKED SATISFACTORY.SDR 29GA2018060600001Power Supply · failedSEVERAL SECTIONS OF THE EMERGENCY LIGHTS WERE INOPERATIVE. R & R THE POWER SUPPLIES 20LN AND 23LN IAW AMM 33-50-10-04-1. OPS CHECKED GOOD.SDR HALA2018060600281Socket · unsecureRIGHT SIDE LAST ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. FOUND DURING T/C 33-001-00. FOUND LIGHT SOCKET LOOSE, SECURED THE SOCKET, OPS CHECKED OK.
Back to JASC 3350