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 R61A201701150046Light · malfunctionedCREW REPORTED THAT TWO EMERGENCY LIGHTS WERE STUCK ON WITH AN EMERGENCY LIGHT BATTERY FAULT MESSAGE. MAINTENANCE RESET AIRCRAFT POWER IAW AMM AND OPS CHECKED GOOD.SDR N6WA2017011501Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT STAY ILLUMINATED. CHARGED FOR SIX HOURS OPS NORMAL IAW AMM 33-51-17.SDR DALA2017011700354Lens · unsecureTHE FLIGHT ATTENDANT DISCOVERED THAT AN EMERGENCY EXIT SIGN DIFFUSER COVER AT 01C WAS LOOSE. MAINTENANCE SECURED THE LENS AND OPS CHECKED GOOD.SDR DALA2017011700353Lens · unsecureTHE FLIGHT ATTENDANT DISCOVERED THAT AN EMERGENCY EXIT SIGN DIFFUSER COVER AT 01C WAS LOOSE. MAINTENANCE SECURED THE LENS, AND OPS CHECKED GOOD.SDR CALA2017011600109Fuse · blownEMER LIGHTS AT G-2 & G-3 GALLEYS INOP. REPLACED EMER LT POWER SUPPLY FUSES AND C/O OPERATION TEST FOUND NORMAL AS PER AMM 33-51-06-960-801 REV78.SDR SIMA20170115002Charger · failedOVERWING EMERGENCY AFT LIGHT INOPERATIVE. TROUBLESHOT THE EMERGENCY LIGHT IAW FIM 33-50-00-810-804-A. R & R THE BATTERY CHARGER ASSY AND BATTERY IAW AMM 33-50-04. OPS CHECKED GOOD AT THIS TIME.SDR AALA20170118009Power Supply · no testEMERGENCY EXIT LIGHT AT OVERHEAD BIN 10DEF FAILED CARD 2904. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2017011911300Lens · looseLT BULLNOSE LIGHT LENS LOOSE AT ROW 6. SECURED LENS PER SIP.SDR AALA20170118006Battery · failedAIRCRAFT WAS GROUNDED. EMERGENCY POWER SUPPLY UNIT 13WL AFT LEFT FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170115004Battery Pack · dischargedAIRCRAFT NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHTS IN FIRST CLASS ARE VERY DIM. REMOVED AND REPLACED BATTERY PACK AT L1 DOOR IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20170115003Battery · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT 14WL MIDDLE RIGHT FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20170115002Battery · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT 15WL MIDDLE LEFT FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201701159009Light · unsecureAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT AISLE 15C DANGLING. MAINTENANCE REINSTALLED AND TIGHTENED SCREWS TO AISLE EXIT LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701159007Battery · dischargedAIRCRAFT WAS NOT GROUNDED. L1 EMERGENCY LIGHT BATTERY FAILED. REPLACED LIGHT BATTERY PER JOB CARD 33C20033002.SDR ASAA2017011419378Battery Pack · dischargedWHILE ACCOMPLISHING TASK CARD 78233001 LIGHTS FROM SEAT ROW 25 AFT ON LEFT SIDE OF AIRCRAFT AND CENTER AFT GALLEY LIGHT FAILED 15 MIN CHECK AFTER DEEP CYCLE OF BATTERIES. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK AT POWER SUPPLY M1673 AND M1672 REF AMMSDR SWAA2017011611187Sign · brokenFORWARD GALLEY EXIT SIGN BASE BROKEN. R&R SIGN IAW AMM.SDR RAIA201701130001Light · unknownLARGE EMERGENCY EXIT LIGHT, AFT OF LT OVERWING EXIT IS INOPERATIVE. OPS CHECKED LARGE EMERGENCY EXIT LIGHT, AFT OF LH OVERWING EXIT(#23), OPS CHECK GOOD.SDR ASAA2017011319377Nut Plate · brokenLT FWD OVERWING EMERGENCY EXIT LIGHT LENS COVER HAS 2EA SPINNING FASTENERS. NUTPLATES ARE BROKEN. ACFT GROUNDED. REPAIRED IAW AMM 33-51-04-960-802 PARAGRAPH F(3) THROUGH (9). COMPLETED STEP F(10) THROUGH G(1). LIGHT OPS TEST GOOD, IAW AMM 33-61-04.SDR AALA201701149003Lens · unsecureAIRCRAFT WAS NOT GROUNDED. DOOR 4L EMERGENCY SIGN FELL OFF. REPLACED LENS COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701149001Lens · missingAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT LENS COVER AT 1L MISSING. MAINTENANCE REPLACED LENS COVER PER AMM 33-50-00.SDR DALA2017011700415Light · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. REPLACED EMERGENCY FLOOR LIGHT LENS PER AMM 33-51.SDR DALA2017011700414Light · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. REPLACED EMERGENCY FLOOR LIGHTING LENS PER AMM 33-51.SDR DALA2017011700413Light · inoperativeEMER PATH LIGHT INOP AND LENS MISSING ROW 10B WHITE LIGHT. RELAMPED AND REPLACED LENS COVER REF AMM 33-51.SDR AALA20170117008Battery Pack · dischargedAIRCRAFT NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT L1 DOOR INBOARD SEAT IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY PACK IAW AMM 25-65-00. OPERATIONAL CHECK GOOD.SDR AALA20170116016Lens · missingAIRCRAFT NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHT AT SEAT 14A IS MISSING LENS COVER. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170116015Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT L4 DOOR HAS A DETACHED LENS COVER. REATTACHED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20170116013Light · inoperativeAIRCRAFT NOT GROUNDED. L2 EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170116012Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT R1 DOOR NEAR FLOOR IS DETACHED. REATTACHED EXIT SIGN IAW AMM 33-51-13. OPERATIONAL CHECK GOOD.SDR AALA20170116009Lens · missingAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY PATH LIGHT AT SEAT 22A HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 25-25-01. OPERATIONAL CHECK GOOD.SDR AALA20170116007Battery · failedAIRCRAFT NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 11WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170113041Power Supply · failedAIRCRAFT NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHTS FOR ROW 7 THROUGH 12 FAILED TEST. REMOVED AND REPLACED POWER SUPPLY M1676 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170113028Control Unit · failedAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHTING ROWS 1 THROUGH 3 BOTH SIDES FAILED TEST. REMOVED AND REPLACED WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT IAW DMC-B787-A-33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20170113023Power Supply · failedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT IDENTIFIER AT L3 DOOR FAILED TEST. REMOVED AND REPLACED POWER SUPPLY M33405 IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR VNAA2017011300015Relay · malfunctionedEMERGENCY LIGHTS TURN ON AND OFF WITHOUT SWITCH. REMOVED AND REPLACED RELAY K135 IN JB11 PCB5.SDR DALA2017011700387Lamp · inoperativeTAIL COMPARTMENT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR DALA2017011600351Cover · damagedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHT AT SEAT 3C IN THE CABIN WAS DAMAGED. MAINTENANCE SECURED THE COVER.SDR DALA2017011600350Cover · damagedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHT AT SEAT 2C IN THE CABIN WAS DAMAGED. MAINTENANCE REPLACED THE COVER.SDR CALA2017011600114Light · brokenFOUND ZONE "A" PARTITION LT & RT EMERGENCY LT BROKEN. REPLACED ZONE A PARTITION LT & RT EMERGENCY LIGHT AND CARRY OUT OP TEST FOUND ''SATIS'' REF TO AMM 33-51-05-960-802 REV 78.SDR CALA2017011600113Light · brokenZONE B PARTITION LT & RT EMERGENCY LT BROKEN. REPLACED ZONE B PARTITION LT & RT EMERGENCY LIGHT AND OP TEST CARRIED OUT FOUND NORMAL AS PER AMM 33-51-0 6-960-802 REV 78.SDR SWAA2017011611198Lens · looseL1 DOOR EXIT SIGN LENS LOOSE. INSTALLED LENS PER SIP.SDR SWAA2017011611175Strip · damagedRT EMERGENCY FLOOR TRACK GLOW STRIP DAMAGED AT ROW 1. R&R STRIP PER AMM.SDR R61A201701130042Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT STRIP AT SEAT 1C WAS LOOSE. MAINTENANCE SECURED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR SIMA20170113004Bulb · inoperativeSERVICE DOOR HINGE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SERVICED DOOR EXTERNAL EMERGENCY LIGHT BULB IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A OPC GOOD END.SDR JJBA20170113008Bulb · inoperativeGREEN ADVISORY LIGHT, EMERGENCY SIGN INOPERATIVE. SECURED THE BULB OPS CHECKED GOOD.SDR CALA2017011300107Switch · malfunctionedEMERGENCY LIGHTS WILL NOT GO OUT. CREW CYCLED THE EMERGENCY LIGHT SWITCH IN THE COCKPIT AND CABIN. LIGHTS NOW OPS NORMAL.SDR CALA2017011300106Charger · inoperativeAFT EMERGENCY LIGHTS ILLUMINATED. REPLACED THE CHARGER, OPS GOOD.SDR CALA2017011300105Lamp · inoperativeEXTERIOR EMERGENCY EXIT LIGHT AT AFT SERVICE DOOR INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMAL.SDR CALA2017011300104Lens · missingEMERGENCY EXIT SIGN DOES NOT TURN. REPLACED LENS COVER. OPS CHECKED NORMAL.SDR CALA2017011300102Sign · inoperativeEMERGENCY EXIT SIGN INOPERATIVE IN THE FLIGHT DECK. REPLACED THE SIGN IAW MM 33-51-01. OPS. CHECKED NORMAL.SDR CALA2017011300100Battery Pack · no testAFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. REPLACED THE BATTERY PACKS. OPS TESTED OK IAW AMM 33-51-06-960-802 REV.78.
Back to JASC 3350