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 SWAA2019053133228Battery · dischargedR1 DOOR ESCAPE SLIDE EMERGENCY LIGHTS INOP. R&R BATTERY IAW AMM.SDR SWAA2019053133227Power Supply · inoperativeR1 DOOR ESCAPE SLIDE EMERGENCY LIGHTS INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019053133226Power Supply · inoperativeR1 DOOR WAY LINING EMERGENCY LIGHTS INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019053133225Power Supply · inoperativeEMERGENCY LIGHTS INOP BETWEEN BS. 449 TO BS. 500. R&R POWER SUPPLY IAW AMM.SDR SWAA2019053133212Battery · dischargedR1 DOOR WAY LINING EMERGENCY LIGHTS INOP. R&R BATTERY IAW AMM.SDR IPXA2019052842560Msc · defectiveINSPECTION TYPE:N/A DURING PREFLIGHT, EMER LIGHT TEST, EMER LT BAT 1 LO ALERT. DEFERED PER MEL 33-50-2, DMP CW, PLARARD INSTALLED. **SUPPLEMENTAL SDR** T/S REF FIM 33-51-00-101 FIG 104. REPLACED MSC NO FAULTS NOTED REF MM 31-42-01. DEFERRAL CLEARED. IPC 31-4SDR CALA2019053100852Battery Pack · dischargedLAST SEVERAL ROWS OF PAX AISLE EMERGENCY LIGHTING INOP. REMOVED AND REPLACED BATTERY PACK AT LOCATION M1673 IAW AMM 33-51-06, OPS CHECK GOOD.SDR AALA20190528006Sign · brokenAIRCRAFT WAS NOT GROUNDED: EXIT SIGN AT DOOR L4 BROKEN AND UNATTACHED AT BOTTOM, CLEAR LENS MISSING. MAINTENANCE REPLACED EXIT SIGN AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-13.SDR SWAA2019053033169Light · inoperativeLT EMERGENCY LIGHT INOP AT ROW 20. R&R LAMP PER AMM.SDR SCNA20190528067Light · inoperativeROW 24L EMERGENCY LIGHT INOP. ROW 14L EMERGENCY LIGHT INOP. R&R LAMP AT ROW 24L FOR THE EMERGENCY LIGHT. OPS CHECK GOOD AT THIS TIME. PLACED EMERGENCY LIGHT AT ROW 14L ON MEL. R&R LIGHT ASSY. OPS CHECK GOOD. THIS CLEARS MEL.SDR AALA201905299010Switch · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SWITCH BROKEN INSIDE AUTO OFF SWITCH, WILL NOT TOGGLE OFF. MAINTENANCE REPLACED SWITCH GUARD PER SWPM 20-83-11.SDR AALA201905299006Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT FLASH LIGHT AT DOOR 2R AFT WAS INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA201905299005Battery Pack · faultedAIRCRAFT WAS GROUNDED: DURING EMERGENCY LIGHT TEST ON CIDS, EPSU 13WL AFT LEFT FAULTED. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-38.SDR AALA20190528004Battery · lowAIRCRAFT WAS NOT GROUNDED: DOOR 2L WITH EPAS LOW BATTERY. MAINTENANCE REPLACED EPAS BATTERY PER AMM 52-11-20.SDR SWAA2019052933141Light · brokenR1 DOOR EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT PER MM.SDR SWAA2019052933133Light · inoperativeLT OVERWING EMERGENCY LIGHT INOPERATIVE. R&R LAMP IAW AMM.SDR DALA2019052903281Terminal · out of positionFA REPORTS THAT EMERGENCY LIGHTS FLICKERS ON/OFF AT HALF BRIGHTNESS AT 3-4 MINUTE INTERVALS IN FLIGHT. FOUND OVERHEAD EMERGENCY LIGHT SWITCH TERMINAL TOUCH ADJACENT STRUCTURE. REPOSITION TERMINAL. PER WDM 33-51. REF SWPM CH 20. CKS GOOD. (LP5564892)SDR VNAA2019052711102Light · inoperativeLOWER EMERGENCY FLOOR LIGHT WILL NOT ILLUMINATE. REMOVED/REPLACED LIGHT. IAW CRJ200 AMM 33-51-10-000/400-801. OPS CHECK GOOD.SDR VNAA2019052711101Light · inoperativeMIDDLE CEILING EMERGENCY LIGHT AFTER EMERGENCY SIGN WILL NOT ILLUMINATE. REMOVED AND REPLACED MIDDLE AFT CEILING EMERGENCY FLOODLIGHT IAW CRJ200 AMM 33-51-16-000/400-801. OPS TESTS GOOD AT THIS TIME.SDR Q2SA2019060427420Battery Pack · dischargedAIRCRAFT GROUNDED. EMERGENCY LIGHT OVER R1 DOOR INOP. REMOVED AND REPLACED RH EMERGENCY BATTERY PACK IAW B737 AMM 33-51-51. OPS CHECK GOOD.SDR DALA2019052903349Battery Pack · dischargedSHIP 663 DURING CK FOUND EMERGENCY LIGHT INOP AT SEATS 9-10-11. CORRECTIVE ACTION: REPLACED BATTERY PACK IN CHARGER M10568 PER AMM 33-51 OPS CKS GOOD. (5618734)SDR ASAA2019052729513Lens · missingEMERGENCY EXIT LIGHT COVER AT MID CABIN MISSING. GROUNDED - YES. REPLACED MID CABIN AISLE EMERGENCY EXIT LIGHT LENS AS REQUIRED.SDR AALA20190528002Battery Pack · faultedAIRCRAFT WAS GROUNDED: DURING EMERGENCY LIGHT TEST ON PS CHECK, CIDS FAULTED EMERGENCY POWER SUPPLY UNIT 13WL, AFT LEFT BATTERY PACK. REPLACED BATTERY PACK PER AMM 33-51-38.SDR SWAA2019052933146Fuse · blownLT EMERGENCY LIGHTS INOP BETWEEN ROWS 9 TO ROWS 12. R&R FUSE PER AMM.SDR SWAA2019052933134Lens · missingCENTER OVERHEAD EXIT SIGN (FACING AFT) MISSING. INSTALLED LENS PER MM.SDR ASOA201905274021Charger · inoperativeIAH - THE FLIGHT ATTENDANT REPORTED THAT THE EXIT SIGN ABOVE THE EXIT ROW WAS NOT ILLUMINATING, AND THE AISLE PATH LIGHTING FROM ROWS 19-24 WERE FOUND INOPERATIVE AS WELL DURING MX INSPECTION. THE #4 EMERGENCY LIGHT BATTERY PACK AND CHARGER WERE REMOVED AND RESDR ASOA201905274020Battery · dischargedIAH - THE FLIGHT ATTENDANT REPORTED THAT THE EXIT SIGN ABOVE THE EXIT ROW WAS NOT ILLUMINATING, AND THE AISLE PATH LIGHTING FROM ROWS 19-24 WERE FOUND INOPERATIVE AS WELL DURING MX INSPECTION. THE #4 EMERGENCY LIGHT BATTERY PACK AND CHARGER WERE REMOVED AND RESDR SWAA2019052833106Light · inoperativeLT EMERGENCY LIGHT INOP AT ROW 12. RELAMPED LIGHT PER AMM.SDR AALA201905289006Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK, FOUND EMERGENCY LIGHTING DID NOT WORK ON POSTION M33409. MAINTENANCE REPLACED POWER SUPPLY PER AMM 33-51-06.SDR AALA201905289005Socket · brokenAIRCRAFT WAS GROUNDED: L1 DOOR EXIT EMERGENCY LIGHT WOULD NOT COME ON WHEN TESTED. MAINTENANCE FOUND SOCKET L33122 BROKEN AND REPLACED L1 DOOR LIGHT ASSEMBLY SOCKET PER AMM 33-51-00.SDR AALA20190527002Battery · dischargedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS DOOR 5L EMERGENCY EXIT IDENTIFIER FWD / AFT AND EXIT SIGN ABOVE DOOR INOP. REPLACED EMERGENCY POWER SUPPLY BATTERY AT DOOR 5L. OPS CHECK IS GOOD IAW AMM 33-51-06-960-802.SDR IPXA2019052742514Warning System · false activationINSPECTION TYPE:N/A EMER LIGHTS EICAS MSG. OPS CHECKS OF EMERG. LIGHTS GOOD PER AMM 33-51-00-715-105.SDR SWAA2019053033187Sign · unsecureMID-CABIN EMERGENCY EXIT SIGN FELL OFF. REINSTALLED SIGN PER AMM.SDR SIMA20190526003Charger · inoperativeGALLEY EMER LIGHTS AND FLOOR STRIPS 1-3 INOP. C/A-REMOVED AND REPLACED #2 EMERGENCY BATTERY AND CHARGER IAW W/C 33-700-19. PERFORMED OPS CHECK IAW W/C 33-700-17. OPC GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 113277SDR DALA2019052903294Light · unsecure(AIRCRAFT 5805, L/P 1092689) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. RESECURED LIGHT. OPS NML.SDR DALA2019052903291Housing · damaged(AIRCRAFT 6701, L/P 5757409) SEAT 18D EMERGENCY PATHWAY LIGHT DAMAGED. REPLACED LIGHT HOUSING. OPS NORMAL.SDR N6WA2019052601Light · inoperativeEMERGENCY EXIT LIGHT IN GALLEY HAS BURNT BULB. RELAMPED IAW CMM 33-24-10 OPS CHECKED GOOD NO FURTHER DEFECTS NOTED.SDR QXEA2019052800225Light · inoperativeF/A EMERGENCY LIGHT "NORMAL" BACKLIGHT IS OUT. REMOVED FROM SERVICE. RELAMPED F/A EMERGENCY "NORMAL" BACK LIGHT AT FWD F/A JUMPSEAT. FUNCTIONS AS REQUIRED. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR SWAA2019052833122Lens · missingRT OVERWING EMERGENCY LIGHT FLOOR SIDE WALL EXIT LENS MISSING. R&R BATTERY PACK PER MM.SDR SWAA2019052833021Lens · missingRT OVERWING EMERGENCY LIGHT FLOOR SIDE WALL EXIT LENS MISSING. R&R CHARGER PER MM.SDR SWAA2019052833020Lens · detachedEMERGENCY EXIT SIGN OVER AISLE DETACHED FROM PASSENGER BAY. INSTALLED LENS PER SIP.SDR AALA20190526002Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: CABIN SEATS 33D TO 38D EMERGENCY FLOOR PROXIMITY LIGHTS INOPERABLE. REPLACED POWER SUPPLY M33401 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER 33-51-06-960-803 AND 33-51-06-960-801.SDR DALA2019052603250Light · inoperativeEMERGENCY FLOOR LIGHTING INOPERATIVE. REFITTED LIGHT ASSSEMBLY. SYSTEM OPERATION IS NORMAL.SDR DALA2019052603245Power Supply · inoperativeEMERGENCY LIGHTS AT ROWS 15AB-22AB ARE INOPERATIVE. REPLACED AISLE EMERGENCY LIGHTS POWER SUPPLY. SYSTEM OPERAITON IS NORMAL.SDR AALA20190526004Battery Pack · dischargedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS SEAT MOUNTED EMERGENCY LIGHTS INOP AT SEAT ROWS 7 THRU 9. REPLACED BATTERY PACK M33098, OPS CHECK NORMAL IAW AMM 33-51-06.SDR DALA2019052703238Power Supply · inoperative(LOG 5745420) DURING INSPECTION FOUND EMERGENCY LIGHTS FROM ROW 22 AFT NOT COMING ON. REPLACED POWER SUPPLY AND BATTERY PACK, CKS OK.SDR DALA2019052703236Cover · missing(LOG 5745421) DURING INSPECTION FOUND EMERGENCY LIGHT COVER MISSING FROM STA 260 FWD GALLEY A/C RIGHT FLOOR AREA. REPLACED LIGHT ASSY P/N 0201924-1007, CKS OK.SDR SIMA20190525004Light · damagedLT FLOOR PROXIMITY STRIP LIGHTS #8 STRIP LIGHTING ASSY IS DAMAGED. C/A-COMPLETE: REPLACED LIGHT STRIP IAW AMM 33-50-12.SDR SIMA20190525003Light · damagedRT FLOOR PROXIMITY STRIP HAS DAMAGED RT FWD PROFILE. C/A-COMPLETE: INSTALLED NEW RT FLOOR PROXIMITY SIDEWALL ASSY. IAW AMM 33-50-12.SDR DALA2019053103338Light · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. FWD TO MEL 33-50-03A. REPLACED EPL ASSY AT 25D, AND REPLACED EPL @29D IAW 33-50, OPS CHK NML.
Back to JASC 3350