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 SIMA20180201006Light · inoperativeNR 2 EMERGENCY LIGHT STRIP INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT STRIP IAW AMM 33-50-12.SDR SIMA20180201004Sign · inoperativeDURING A CHECK, FOUND EMERGENCY EXIT SIGN IN THE FRONT OF SEAT 3B TO BE INOPERATIVE. REMOVED AND REPLACED THE SIGN IAW AMM 33-50-13. OPS CHECKED IAW AMM 33-50-00, CHECKED GOOD. NO DEFECTS NOTED.SDR MASA2018020112948Light · inoperativeROW 8 EMERGENCY OVERHEAD FLOODLIGHT INOPERATIVE.SDR SIMA20180201001Lamp · inoperativeLEFT AFT EXTERIOR OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD IAW AMM 33-50-10.SDR SWAA2018020719486Battery Pack · failedFORWARD LT EMERGENCY LIGHT BATTERY PACK FAILED DEEP CYCLE CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018020719485Light · inoperativeR2 DOOR EMERGENCY EVAC SLIDE EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR IPXA2018020126090Battery · no testEMERGENCY LIGHT BATTERY 1 FAULT ALERT DURING EMERGENCY BATTERY TEST. REPLACED THE BATTERY IAW 33-51-01-401.SDR DALA2018020600710Sign · unsecureEXIT SIGN FELL OFF AT ROW 1. RESECURED SIGN IAW MM. OPERATION CHECKS GOOD.SDR DALA2018020100703Light · unsecureEMERGENCY FLOOR LIGHTING INOPERATIVE AT 22B. SECURED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR SWAA2018020519516Lens · looseLT EMERGENCY EXIT BULLNOSE LIGHT LENS LOOSE AT ROW 24. SECURED LENS PER AMM.SDR SWAA2018020519513Light · inoperativeRT OVER WING EMERGENCY EXIT LIGHT BULB INOP. RELAMPED LIGHT PER MM & WDM.SDR AALA20180202001Battery Pack · failedEMERGENCY BACK UP BATTERY 10WL FAILED DURING CIDS TEST. MAINTENANCE REPLACED THE POWER SUPPLY UNIT IAW MM 33-51-38 . TESTED AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802019020Lens · missingEMERGENCY LIGHT LENS IN THE FORWARD GALLEY, RIGHT SIDE OF ISLE MISSING. INSTALLED THE LENS IAW AMM 33-51-00. TESTED OK.SDR AALA201802029008Lamp · inoperativeLAVATORY D EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE LAMPS.SDR AALA201802029007Lamp · inoperativeSEAT 21C BLUE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW 25-22-52.SDR DALA2018013100631Light · brokenEMERGENCY LIGHT AT SEAT 33G IS BROKEN OUT FROM SEAT CLOSE OUT PANEL, REATTACHED 33G EMERGENCY LIGHT PATH TO SEAT AND SECURED.SDR DALA2018020100610Lens · brokenCLEAR EMERGENCY LIGHT LENS BROKEN, REPLACED THE LENS.SDR DALA2018020100592Light · looseSEAT 28D MOUNTED EMERGENCY LIGHT LOOSE. SECURED THE LIGHT. OPS NORMAL.SDR AALA201802019014Light · brokenSEAT 10C EMERGENCY LIGHT BROKEN. REPLACED THE LIGHT ASSY. OPS CHECKED GOOD. OK FOR SERVICE.SDR SIMA20180131003Light · damagedL5 EMERGENCY LIGHT STRIP DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12SDR SIMA20180131002Light · damagedR3 LIGHT STRIP IS DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT STRIP IAW AMM 33-50-12.SDR SWAA2018013119449Cover · missingEMERGENCY EXIT ROW OVERHEAD EXIT SIGN COVER MISSING. INSTALLED COVER PER SIP AND CMM.SDR UIEA2018013100156Light · inoperativeL4 EXT EMERGENCY LIGHT INOP. REMOVED AND REPLACED EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-16 OPS CHECK OK.SDR UIEA2018013100157Light · inoperativeLT FUSELAGE AFT OF LEFT WING EMERG LIGHT INOP. REMOVED AND REPLACED EMERGENCY LIGHT IAW AMM 33-51-16.SDR AALA201802029025Control Unit · faultyAIRCRAFT WAS NOT GROUNDED: REMOTE WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT CONFIGURATION DID NOT AGREE WITH OTHER WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNITS, WITH FAULT CODE 33-12131. MAINTENANCE REPLACED DOOR 4L WIRELESS EMERGENCY LIGHTING SYSTEMSDR AALA20180326003Battery Pack · inoperativeTHE OVERHEAD EXIT SIGN AT THE FRONT OF THE LEFT ROW IN FIRST CLASS IS NOT WORKING. REPLACED ALL THE BATTERY PACKS.SDR AALA20180326006Battery · dischargedTHE EMERGENCY LIGHTS ON THE SIDE OF SEATS OF 20H WAS NOT WORKING. REPLACED BATTERY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180326005Battery Pack · inoperativeTHE EMERGENCY LIGHTS ON THE SIDE OF SEATS AT ROWS 20AB - 24AB WERE NOT WORKING. REPLACED THE BATTERY PACK AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA20180326010Battery Pack · inoperativeALL THE OVERHEAD EXIT SIGNS IN COACH ARE NOT WORKING. REPLACED THE BATTERY PACKS.SDR AALA20180326009Battery Pack · dischargedEMERGENCY LIGHTS ON THE SIDE OF SEATS 32H THROUGH 41H ARE NOT WORKING. REPLACED THE BATTERY PACKS.SDR AALA2018020629028Control Unit · faultyTHE AIRCRAFT WAS NOT GROUNDED. **AHM ALERT** CLASS 31. REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNITS. WITH FAULT CODE 33-12131 TIME 1630.21 CYCLES 180. REPLACED WELS CONTROL UNIT PER AMM 33-51SDR AALA2018020629027Control Unit · faultyTHE AIRCRAFT WAS NOT GROUNDED. **AHM ALERT** CLASS 07. DOOR 4 LEFT HAND REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNITS. WITH FAULT CODE 33-12107 TIME 1630.21 CYCLES 180. REPLACED WELS CONTROL USDR E07A201802140015Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON.SDR HALA2018020100028Cids · malfunctionedL2 DOOR EXIT SIGN STAYS ILLUMINATED DURING FLIGHT. RESET CID 1 AND 2.SDR AALA201802029013Control Unit · no testAHM ALERT, CLASS 31, REMOTE CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNITS. FAULT CODE 33-12131. MAINTENANCE REPLACED THE L4 DOOR WIRELESS EMERGEMCY LIGHT SYSTEM CONTROL UNIT IAW AMM 33-51-07. OPS CHECSDR SWAA2018020719482Lens · looseRT OVERWING EMERGENCY EXIT LENS LOOSE. SECURED LENS PER MM.SDR SWAA2018020719472Battery Pack · dischargedFORWARD SERVICE DOOR EMERGENCY EGRESS LIGHT INOP. R&R BATTERY PACK PER AMM.SDR AALA201802029014Control Unit · no testAHM ALERT, CLASS 07, L4 DOOR REMOTE CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERGENCY LIGHTING SYS CONTROL UNITS. FAULT CODE 33-12107. REPLACED WIRELESS EMERGENCY LIGHT SYSTEM CONTROL UNIT IAW AMM 33-51-07.SDR SWAA2018020519535Battery · failedFORWARD RT EMERGENCY LIGHT SEGMENTS FAILED CAPACITY CHECK. R&R BATTERY IAW MM AND WDM.SDR SWAA2018020519534Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK AT POSITION M01668. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018020519515Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK AT POSITION M01674. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018020519508Battery · failedFORWARD LT EMERGENCY LIGHT SEGMENTS FAILED CAPACITY CHECK. R&R BATTERY IAW MM AND WDM.SDR SWAA2018020619476Light · inoperativeLT EMERGENCY HATCH LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA201802029022Control Unit · faultyAHM ALERT, CLASS 31. REMOTE CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNITS, FAULT CODE 33-12131. RAN SYSTEM CONFIGURATION REPORT IAW AMM DMC-B787-A-33-51-00-03A-300D-A. REMOVED AND REPLACED CONTROL UNISDR AALA201802029021Control Unit · faultyAHM ALERT, CLASS 07. L4 DOOR REMOTE CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNITS. WITH FAULT CODE 33-12107. REMOVED AND REPLACED THE CONTROL UNIT IAW AMM 33-51-07. OPS CHECKED NORMAL.SDR AALA201802029024Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY AISLE LIGHT LENS AT STATION 27 MISSING. NEW EMERGENCY AISLE LIGHT LENS INSTALLED PER AMM 25-63-00.SDR ASAA2018013023358Lens · missingMISSING EXIT ROW SIGN COVER AT ROW 16 DEF. GROUNDED - YES. INSTALLED NEW LENS COVER, OK FOR SERVICE.SDR AALA201802019011Power Supply · defectiveEMERGENCY LIGHT POWER SUPPLY 14WL FAILED TO TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-38. OK FOR SERVICE.SDR DALA2018013000575Battery Pack · dischargedEMERGENCY LIGHTS FROM ROW 4 THRU 13 INOPERATIVE. REPLACED EMERGENCY BATTERY PACK AT ROW 4. OPERATION CHECKS GOOD.SDR MASA2018013012945Battery Pack · dischargedRT FWD OVER WING EMER EXIT SIGN INOP. REPLACED BATTERY PACK.
Back to JASC 3350