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 DALA2019070304081Shroud · damagedSHIP 686 AISLE SIDE SEAT SHROUD DAMAGED AT SEAT 18D. EEPL (WHITE) MISSING. CORRECTIVE ACTION: REPLACED 18D SHROUD BUMPER ASSY AND EEPL LIGHT ASSY PER CMM 25-21. (5444996)SDR SWAA2019070534591Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R&R BATTERY PER AMM.SDR SWAA2019070534589Lens · missingEXIT SIGN MISSING. R&R EMERGENCY LENS IAW AMM.SDR SWAA2019070534573Lens · missingEMERGENCY EXIT LENS MISSING. R&R LENS IAW AMM.SDR SWAA2019070534557Light · inoperativeEMERGENCY EXIT LIGHT INOP. RELAMPED PER AMM.SDR SWAA2019070534553Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITANCE CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2019070534539Lens · damagedEXIT LIGHT ON AFT WALL OF LAV A DAMAGED. R&R EXIT LIGHT IAW AMM.SDR SWAA2019070234431Lens · missingFORWARD ENTRY DOOR EXIT SIGN MISSING. INSTALLED LENS IAW AMM.SDR SIMA20190702003Charger · failedEMERGENCY EXIT LIGHTS FLOOR STRIP ROW 12 INOP. C/A-REMOVED AND REPLACED #3 EMERGENCY BATTERY AND CHARGER IAW AMM 33-50-04. OP CK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1ASMI S/N 9510.SDR MASA2019070211934Light · inoperativeEMER EXIT SIGN GALLEY SVC DOOR 1 BULB INOP. REPLACED BULB.SDR MASA2019070211931Light · inoperativeROW 19 OVHD EMERG EXIT SIGN 1 BULB INOP. PLACED ON MEL.SDR MASA2019070211930Light · inoperativeROW 19 OVHD EMERG EXIT SIGN 1 BULB INOP. PLACED ON MELSDR MASA2019070211929Light · inoperativeROW 9 CEILING LEVEL EMER FLOOD LIGHT INOP. PLACED ON MELSDR SWAA2019070534588Light · inoperativeINTERIOR LIGHT INOP. RELAMPED IAW AMM.SDR SWAA2019070534543Lens · missingEMERGENCY EXIT LIGHTS "NOT ARMED" LENS MISSING. R&R LENS REF AMM.SDR AALA201907029042Battery · faultedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS WHEN PERFORMING CIDS1 EPSU SYSTEM TEST, DIR1 ACTIVE ATA 33-51-00 BAT/EPSU (13WL) FAULT. REMOVED AND REPLACED BATTERY PACK 13WL IAW AMM 33-51-00. OPS CHECK GOOD.SDR SWAA2019070334498Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019070234454Battery Pack · dischargedR2 DOOR EMERGENCY EXIT LIGHTS INOP. R&R AFT RH BATTERY PACK IAW MM.SDR SWAA2019070334432Lens · missingL2 DOOR EMERGENCY EXIT INDICATOR LENS MISSING. R&R LENS IAW AMM.SDR AALA201907039002Flashlight · faultyAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT POSITION, 3L, RED LIGHT INDICATED LOW BATTERY. MAINTENANCE REPLACED 3L FLASHLIGHT PER MM 25-64-00.SDR JJBA20190701001Light · inoperativeEMERGENCY LIGHTS FOUND IN ARMED POSITION. EMERGENCY LIGHTS WILL NOT ILLUMINATE. R&R EMERGENCY LIGHTS 1-4. OPS CHECK SAT. (#1 PN 2013-1A SN 101459 TSN:55547:56 CSN: 23980 #2 PN ABS-2013-1A SN 38159 TSN: 1389:01 CSN: 1204 #3 PN: ABS-2013-1A SN 48554 TSN: 1389.01SDR AALA201907029025Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS TEST FAILED. MAINTENANCE REPLACED BATTERY PER STANDARD PRACTICES.SDR AALA2019070290004Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: DURING EPSU TEST FOR L3 DOOR REPLACEMENT, 10WL AND 12WL FAILED TEST. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-38.SDR DALA2019070203992Battery Pack · defective(LOG 5452443) FND BATTERY PACK AND POWER SUPPLY BAD AT AFT RIGHT ABOVE GALLEY. R/R PER AMM 33-51 OPS CHKS GOOD.SDR DALA2019070203980Power Supply · inoperativeTHE CEILING EMERGENCY LIGHT AT 1R DOOR IS NOT ILLUMINATING. MAINTENANCE DISCOVERED THAT NO POWER WAS GETTING TO THE LIGHT. THEY REPLACED THE BATTERY POWER SUPPLY B5- 259 PER AMM 33-51. THE OPERATIONAL CHECK WAS GOOD. (LP #5947570 )SDR SROM2019F00225Battery · dischargedEMERGENCY EXIT SIGN/LIGHT AT LH OVERWING EXIT WILL NOT STAY LIT.SDR AALA201907019056Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: DURING EPSU TEST FOR L3 DOOR REPLACEMENT (SLIDE), 10WL AND 12WL FAILED TEST. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-38, NO FAULTS NOTED.SDR SWAA2019070534563Mount · brokenEXIT LIGHT LENS MOUNT BROKEN. R&R EMERGENCY EXIT LIGHT IAW AMM.SDR SWAA2019070534558Battery Pack · dischargedL1 DOOR UPPER EMERGENCY LIGHT IS OUT. R&R BATTERY PACK IAW AMM AND WDM.SDR AALA201907049003Battery · faultedAIRCRAFT IN BASE MAINTENANCE: 15WL BATTERY FAULT FOR CIDS 1. INSTALLED NEW REPLACEMENT BATTERY AT LOCATION 15WL. CIDS1 TEST PASSED. IAW AMM 33-51-00.SDR DALA2019070204013Power Supply · inoperativeSHIP 6701 EMERGENCY LIGHTS OUT AT ROW 27-32 DEF. CORRECTIVE ACTION: REPLACED POWER SUPPLY M10568 NO HELP. T/S PER WDM 33-51-22. ALL WIRES CHECK GOOD. FOUND NO POWER TO PIN 1 D9723J. SLAVED IN 2ND POWER SUPPLY NO HELP. INSTALLED 3RD NEW POWER SUPPLY NOW OPS CHESDR SWAA2019070334497Cover · dislodgedRT OVERWING EXIT LIGHT COVER DISLODGED. R&R COVER PER AMM.SDR SWAA2019070234453Housing · damagedLT OVERWING CEILING AREA CENTER AISLE EMERGENCY EXIT LIGHT HOUSING DAMAGED AT ROW 11. R&R LIGHT PER AMM.SDR SWAA2019070334452Lens · unsecureOVERWING EXIT SIGN CENTER AISLE LENS NOT SECURE. SECURED LENS IAW AMM.SDR DALA2019070103999Light · inoperativeEMERG LIGHT OFF WING EMERG EPSU EXT LT FAULT, RELAMPED ALSO R/R OVERWING RT EPSU WITH BATTERY.SDR ASAA2019063029891Unknown · malfunctionedAFT FWD LEFT LAV EMERGENCY LIGHT REMAINS ILLUMINATED WHEN IT SHOULD BE EXTINGUISHED. GROUNDED - YES. RESET A/C ELECTRICAL POWER OPS CHK OF AFT FWD LAV EMERGENCY LIGHT GOOD IAW AMM 20-60-99-760-001.SDR AALA201907029029Control Unit · faultyAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS WIRELESS CONTROL UNIT FOR EMERGENCY LIGHTS AT DOOR 4L FAULT. REMOVED AND REPLACED WIRELESS CONTROL UNIT. OPS CHECK GOOD.SDR AALA201907029022Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: ESPU 2WL FAILED EMERGENCY LIGHT SYSTEM TEST. MAINTENANCE REPLACED RIGHT HAND ESPU 12WL PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR R61A201906300672Battery · discharged**WHILE IN HEAVY CHECK** MAINTENANCE FOUND EMERGENCY EXIT SIGN ON FORWARD LAVATORY DOES NOT ILLUMINATE. MAINTENANCE REMOVED AND REPLACED #2 EMERGENCY BATTERY REF AMM 33-50-01.SDR DALA2019063003990Battery Pack · discharged(LOG 6275858) DURING INSPECTION FOUND EMERGENCY LIGHT CHECK FOUND SEATS 18-23 LIGHTS INOPERATIVE. R&R BATTERY PACK PER AMM 33-51. OPS CHECK GOOD.SDR R61A201906300670Light · inoperativeCOCKPIT EMERGENCY LIGHT INOP. R&R LIGHT IAW AMM 33-50-03.SDR ASAA2019063029883Power Supply · inoperativeR1 DOOR EMERGENCY LIGHT INOP (EXTERIOR) & INTERIOR FWD GALLEY FLOOR PROXIMITY EMERGENCY LIGHT INOP. GROUNDED - YES. REPLACED RT EMERGENCY POWER SUPPLY OPS CHECK GOOD. REF AMM 33-51-06 EMERGENCY LIGHTS OK FOR SERVICE.SDR SIMA20190630001Fuse · blownEMERGENCY EXIT PATHWAY LIGHTING AT 9-10 NOT WORKING. C/A-FOUND 3 FUSES BLOWN ON #3 EMERGENCY LIGHTING BATTERY CHARGER. REMOVED AND REPLACED THE 3 BLOWN FUSES, REF: AMM 33-50-04. ALL EMERGENCY LIGHTS NOW OPS CHECK GOOD.SDR AALA201907019037Battery · dischargedAIRCRAFT WAS NOT GROUNDED: DURING OPERATIONS CHECK OF EMERGENCY LIGHTS TEST, FLAGGED EPSU BATTERY. MAINTENANCE REPLACED EPSU BATTERY PER AMM 33-51-38-401.SDR DALA2019070103938Power Supply · inoperativeDURING SERVICE CHECK, FOUND AFT ZONE LEFT EMERGENCY FLOOR LIGHT INOPERATIVE. REPLACED POWER SUPPLY 17WL. LP 5426004SDR YENA201906290383Battery · dischargedFLT 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED; REMOVED & REPLACED EPSU BATTERIES AT FIN# 10WL AND 12WL PER AMM 33-51-38.SDR YENA201906290382Battery · dischargedFLT 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED; REMOVED & REPLACED EPSU BATTERIES AT FIN# 10WL AND 12WL PER AMM 33-51-38.SDR REXA2019062901057Battery · dischargedLOWER EMERGENCY SIDEWALL LIGHTS INOP AT ROW 12 LEFT AND RIGHT SIDES. FOUND BATTERY FOR EMERGENCY LIGHTS DEAD (PS-43) R&R BATTERY IAW AMM33-51-17 OPS TEST NORMAL.SDR R61A201906290669Power Unit · inoperativeAFT CABIN EMERGENCY EXIT SIGN DOES NOT ILLUMINATE. R&R AFT EMERGENCY POWER UNIT (EXIT SIGN #3 POWER UNIT) IAW AMM 33-50-01.SDR SWAA2019070234427Battery Pack · dischargedR2 DOOR LOWER EMERGENCY LIGHT ASSEMBLY INOP. R&R BATTERY PACK IAW AMM.
Back to JASC 3350